• composite WHERE condition in SQL Server

    In Oracle, I can do: Select * from table where field1 || field2 in ('01XX','02YY','03ZZ') ; Where field1 has values of 01,02,03 and field2 has values of XX,YY,ZZ etc Can I do the same thing in SQL Server, or do I need define some derived fields to get the same effect?

    MarcW25 pointsBadges:
  • Hiding the system views table from Microsoft Access

    How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql server express 2005 cannot see drive on my server (drive q)

    I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?

    Shircol25 pointsBadges:
  • The most-watched IT questions this week: Dec. 8, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs...

    ITKE346,195 pointsBadges:
  • SQL Server 2008 & Team Foundation 2008

    Hi All, Just wondering if anyone has had issue with using SQL Server 2008 with Team Foundation Server 2008. I know there was a compatibility error that occurred when you tried to installing TFS with SQL Server 2008 however this was address with TFS SP1, are there any issue or error that I should...

    Db23290 pointsBadges:
  • (rsErrorOpeningConnection) Could not obtain information about Windows NT

    I am trying to deploy a report to the Reporting Services Server 2008 but keep running up against this error:

    Amcintryre5 pointsBadges:
  • How can I affect the user profile previous sign-on date with out sign on interactive.

    We have a windows system for invoices from our suppliers. To exchanges files the system map to a folders in I-series IFS-system. We have a special user profile for the system to use. The system map to I-serie and every thing is ok all the servers stays up day and night. The problem is after 60 days...

    TBJSweden0 pointsBadges:
  • SQL DTS package scheduling

    When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

    Gic5 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • Reconnecting to databases in SharePoint after server wipe

    My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and "reconnect" to the databases that already are there or do I need to start all over?

    ITKE346,195 pointsBadges:
  • SQL Server 2005 Performance optimiztion

    I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files....

    ITKE346,195 pointsBadges:
  • SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

    I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

    ITKE346,195 pointsBadges:
  • The most-watched IT questions this week: Nov. 24, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...

    Michael Morisy8,323 pointsBadges:
  • SQL Server 2005 Error Registering database

    I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables "Error registering database - operation is not allowed when object is closed" Thanks for help where I have to look to solve that problem.

    ITKE346,195 pointsBadges:
  • The IT Blog Top 10: Oct. 29, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

    ITKE346,195 pointsBadges:
  • Crystal Reports problem

    here's the coding for my crystal report display The above code is written in the report viewer form's load event method. 'this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue,...

    Obhasha0795 pointsBadges:
  • How do I confirm all the data moved from Source to target for different tables

    How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks

    Gvsatyam5 pointsBadges:
  • hardware requirement for sql 2005.

    Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir

    Infrastucture25 pointsBadges:
  • Nominate a member for our latest Panasonic flatscreen giveaway

    In our latest (and biggest!) IT Knowledge Exchange giveaway, we're giving thanks to the star members of the community who provide quality contributions in their questions, answers and discussions. Did a member answer your question in a particularly great way?Did someone recently contribute to a...

    ITKE346,195 pointsBadges:
  • sql help

    is there a way to update multiple records in a table the meet criteria from another table. here is what i'm trying update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) thanks in advance

    Cowboypgmr0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following