Viewing 15 posts - 1,546 through 1,560 (of 2,496 total)
For SQL Server 2005, the server components and the client tools are on separate CDs. Try installing the tools using the Tools CD.
If you are installing from a DVD,...
November 27, 2008 at 6:29 am
I agree that the PASS keynotes are often just marketing. And too often the marketing is aimed at senior managers rather than technical staff.
When I see a...
November 26, 2008 at 3:00 am
Most people recommend leaving 1 to 2 GB outside SQL Server for Windows use, but the amount you really need to allow is site dependant.
Assuming you do not have any...
November 25, 2008 at 5:03 am
If you cannot get your query to work, try the following troubleshooting:
1) You are running a Windows command - bcp - so try running this outside SQL Server. If...
November 25, 2008 at 4:46 am
My mainframe experience does not cover VSE, but I notice you are getting some good advice from people who do have these skills. What you want to do is...
November 25, 2008 at 4:27 am
If your Senior DBA has asked you to do this, it is worth discusing the issue with that person. Although you can use the BOL references to tell you...
November 25, 2008 at 4:19 am
The in-place upgrade can sometimes fail after it has disabled SQL Server 2000 and before SQL Server 2005 is working. If this hapens you will have to uninstall SQL...
November 24, 2008 at 4:56 am
The question was 'What are included columns in SQL Server 2008'. I don't see that the status of included columns in SQL Server 2005 is relevant to the question.
If...
November 13, 2008 at 2:29 am
SQLServerFineBuild contains SPs to script out SQL Agent jobs and scripts to reload them. It also has SPs to script table, views, SPs, Users, etc. Even if you...
November 11, 2008 at 3:43 am
Why worry about fingerprints when you can use DNA. Scientists tell us that every person's DNA is unique, so here we have an infallible way of proving identity and...
November 11, 2008 at 3:35 am
As George pointed out, by 'default' location I mean the original location they are placed in by the SQL Server install.
Regarding msdb, if your installation has a lot of CRUD...
November 10, 2008 at 5:34 am
IBM publish all the DB2 manuals online. It can be a pain to find them, but Google knows most of the places...
The best practice documentation and research...
November 10, 2008 at 5:28 am
SQL Server 2000 really needs to run using an account with local admin rights in Windows. Although there is a theoretical possibility of running it with less rights, there...
November 10, 2008 at 5:19 am
The Readme file for SQL Server 2005 says how much space will be used on the system drive, and how much will be used for the program files if you...
November 10, 2008 at 5:11 am
If the biztalk jobs are failing, you may need to set up a SQL Agent proxy for the biztalk account. See BOL for details of how to do this.
November 10, 2008 at 5:03 am
Viewing 15 posts - 1,546 through 1,560 (of 2,496 total)