The backups store the path of each file that was backed up, by default a restore will restore these files to the same path.

The trouble comes when restoring on a...

Another way is to detach the files, rename them in explorer, then reattach them

If the database is called Foo

and has the files:

  Foo.mdf

  Foo_log.ldf

and you want to rename to

  Foo.mdf

 ...

It's probaly deciding the computed column is non-deterministic thus not much good for a key as it could change could every time you query the table.

Try changing the column to...

The permission in SQL Server 2005 is VIEW DEFINITION.

Note that disabling the user from viewing the definition can have side effects upon apps that depend upon being able to view...

sorry, the first insert_A shows the error i would have expected. But the insert_B is failing with an internal query error instead of the error I would have expected (this...

I get this same problem when I refresh the database (until then it shows the green circle), both local and remote.

Enabling the browser service seems to solve this so I...

1) I've always had the SA account disabled and had no trouble, MS patches use your local login, or one you specify for the update.

2) You can't disable windows authentication,...

If you used \ as an escape char you now have two escapes, \\ and \'

Using ' as the escape char you only have one escape '' (this is the...

To stop this being a problem, could you not set the maintenance plan to delete backups older than 22 hours instead of 24? This way it should always remain uneffected...

As mentioned previously, Sql Server returns the columns in the physical order they were defined, so the only way to change their order is to redefine them. This is done...

It will use whatever account is running the package. Thus if the user was running it, it would be the user's account. If sql agent runs it, it will be...

What if you ouput the data to excel using a dynamic parameterised sql command so that it always has the same input names, even if the column name it goes to...

Print only displays about the first 8000 chars or so then gives up.

I wrote this sp a while back for printing large multi-line varchars.

It will try to print a line...

Could you place an insert trigger on table to generate the next id as it's inserted?

In the user interface you can then display something like "New invoice" instead of an...

Another way to disallow direct updates to balance, and have triggers update the balance as invoice and payment tables have new rows inserted / updated / deleted.