Up to you as to what you want to support and how much you have to spend on the project.

Drop the index

Insert data less than or equal to 900 bytes (900 varchar, 450 nvarchar)

Change the column to VARCHAR(900) or NVARCHAR(450)

Create the user in the database and assign it the correct permissions or change your connection string to use SQL auth with an account that has access.

ChrisM@Work (2/28/2013)

---

Morrison's are stocking a new Adnams ale, Ghost Ship. It's vaguely similar to the famous Thornbridge ales, Jaipur, Kipling and Wild Swan but a little sweeter. Lush even in...

Take a look in my signature for the string splitter, that should do what you want.

Is booking number varchar(30) in the DB?

If not look at computed columns and stick an extra column on the end of the table with the formula given to convert it...

Break SSRS, the install creates the DB's in that collation so the app must need it in that collation, so I wouldn't change it.

Its not going to cause you any...

No if SQL needs to dump 20GB for the crash it will dump 20GB.

do all backups, backup to that directory or to subdirectories?

what options have you set on the cleanup task?

told it to transvers subfolders if you have 1 cleanup task for all database backups?

Select from sys.server_permission for server wide permissions (grant deny roles etc) joined to sys.server_principles

Select from sys.database_permissions in each database for DB wide permissions joined to sys.database_principles

No only for 2008 R1

Keep your eye on this URL, it gets updated when things come out

http://support.microsoft.com/kb/321185

Rebuild online is where the index is available for use while the rebuild is happening.

Rebuild offline is where the index is not available for use while the rebuild is happening.

Not...

yes to which? rebuilds or creates?

Then the uninstall hasn't uninstalled properly, re-run the uninstaller via the add remove programs.

Failing that format the machine and rebuild from the OS up, or install SQL with a different...