Once you create the SSIS package, save it to the folder path Microsft SQL Server-->90-->DTS-->Packages-->Your Package Name.

To run this as a job..create a new job and when you create the...

I recently installed SP3 on an A/P cluster. The build is 4028. Its working fine for the moment, would like to know if there are any issues...

Thanks!!

What version of SQL are you using? As Manu suggested check for jobs in the management folder in SQL 2000 and under SQL Servre Agent for SQL 2005.

Thanks!!

Guys, SQL 2005 SP3 has rolled out. I have upgraded my Server to SP3 as I was experiencing an issue with SP2. Are there any known issues with SP3 till...

AD and SQl get preferences alike if its a Mixed mode authentication. To be certain that it is not a permission issue I would suggest to use the SQL login...

Once the transaction is completed is the session still running, if so try closing the session out.

Thanks!!

Do this before you try to run the reset status statement..

USE master

GO

...

make him the ddlAdmin. And revoke the permission once he adds the column to it.

Thanks!!

What error does the user get when he tries adding a column from the Management Studio??

Thanks!!

Check in the error logs. What does it say for this database name. Is the disk that holds the data files for this online? How about the log files?

Thanks!!

If this is a new instance, did you install it as a Named instance?

Migrate the DB and then run sp_revlogin to transfer the logins.

As Earl said, you need to change the owner of the schemas to dbo and then delete the obsolete logins....

Does anyone know if this calls for re-installation of SQL server or is there any hotfix for such an issue, because the server is on SP2 at this time. The...

You can upload a picture in jpg or any other format as an attachment. The link for attachment is at the very end when you are replying to a post.

Thanks!!

LOGICAL FRAGMENTATION:-It is the level of fragmentation in your leaf nodes. Why does this happen?

The reason is when ever you insert or delete a row from your table the indexes...