Surely I remove the Built\In admins. Why should I give Windows admins sysadmin permission in SQL Server?

fan.eddy (12/20/2008)

---

-do...

How are you altering the table?

You should be able to add new columns by using the ALTER command inTSQL. But you cannot use the table designer in SSMS because...

Run the following code

use tempdb

go

exec sp_helpfile

Also try executing the code from profiler in SSMS and see what error you get.

I don;t think the problem is in the webcofig but in your procedure. can you post the code of your OCRCMGetInvalidProductId procedure?

One comment I'd like to make.

In SQL 2005 when using sys.sysdependencies it does not always show all depend objects. Especially in the case where you create the procedure first while...

In case you have blanks in your database name you have to use parenthesis around the database name.

EXEC sp_MSforeachdb

'USE [?]

SELECT Table_Catalog,Table_Name, Column_Name

FROM INFORMATION_SCHEMA.COLUMNS'

I don't think thats possible with a standard maintenance plan, but you could use the Execute Sql Script task to execute a script for the differential and tlog backups. In...

For most cases the correct way would be NO SHRINK.

If you search around you will find loads of posts why shrinking your database is not recommended.

jayesh_kherwadi (12/17/2008)

---

Yes I am using Redgate SQL Backup tool to backup. Do you think that might causing job to fail? but i cant understand the reason why its generating error...

dcumming (12/17/2008)

---

Presumably by SSMS you mean SQL Server Management Studio

when i open that it asks to connect to a server, i cancel that as i don't know the login.

From there,...

In Enterprise Mangaer under Management\Database Maintenance Plans

Paul, you've posted this in the SQL 2005 forum, but the maintenance plan you're using is from 2000. So I'm not sure which version you're actually using.

Anyway the code you...

During installation who have to decide if you use Windows only authentification or Windows and SQL. In the second case you have to enter a password for the sa account...

What do you use for making your backups?

Usually VDI errors occur when using some third-party backup solution, I've never seen them with native SQL Server backup.