You can read the SQL Books Online for the best info about SQL. the BOL came with the install, or I should say... should have been installed. If you are...

Yes I did, I always install everything.

Let me look around in there see what I can see.

What happened to being able to use SQL Server and keeping things simple?

Thanks

Andrew SQLDBA

Now this is really off. The keyboard cuts work fine on a server that I have and use. But they do not work on the laptop. I have sever 2003...

You can have as many different instances on one box as you like. I myself, have just finished installing SQL 2000, SQL 2005 and SQL 2008 all on my laptop...

Easy way, no, no easy way.

You can create a SQL Script to do that. Drop the Constraint, truncate the table and create the Constraint again. Or you can script out...

Once you disable a SQL job, it is disabled.

You have an issue with something else firing off that package. Something like a stored procedure can fire off a DTS package....

Gail

I did not see anything in the SQL BOL, and I have also looked in the 2008 BOL. I see nothing about this going away. But I am blind in...

One small question....

What user account are you using to run SQL Service under?

If it it not a domain account, then you cannot use xp_cmdshell to perform any command line operations....

Wow, you are really going the long way around to do change the path. No need for that all code, really. Especially not the xp_cmdshell methods.

A simple detach, move...

Since you are moving the physical box, then all you would have to be concerned with are the connection strings, if you use the IP Address in them. If you...

I copied them from Microsoft site. It was just when I tried to open the MSI, I received a message. So, I went to where the MSI had expanded the...

What are you wanting to return? Or expecting the query to return? The query is actually performing EXACTLY what you asked. No matter the number of rows in the table,...

Creating a backup of a SQL database is very simple. And you can perform this from any environment without the risk, or too much risk of harming anything.

Even while the...

Look in the SQL Books Online under "Alter Table"

Andrew SQLDBA

What you are basically doing is creating a query.

You do not have to go step-by-step with this. You can simply open a new query pane, and type in the query....