Hi,

I Tested this script which runs on a specific database but it generates the script of only SQL Logins..Not the windows logins..

Could you please modify this to have both SQL...

Hi All,

Thanks a lot for the replies..

I have found a script which creates logins on the secondary server using linked server. This script runs on secondary server and can be...

Hi Experts..

I have a same kind of situation here..

TempDB is growing enormously and we are getting alerts continuously..

I have tried to check the following but and found nothing.

-open transactions on...

Thanks Steve!!! I think the script provided by Jonathan will help me.. But I am not at familiar with Power shell scripts 🙁 .. I am not sure how to...

Hi All,

Thanks a lot for all your prompt replies.

I knew that, sp_help_revlogin script can be used to transfer logins from one server to another. but my point is to a...

Hi,

Try out this script and run it on your database. It give the permissions of the users as output. copy it and run it on your destination DB.

SET NOCOUNT ON

DECLARE...

Hi,

The table has total nine Indexes. May be I have given the total indexes size. The other thing I observed from the query execution plan that the 92% cost is...

Hi,

Thanks much for the replies. The statistics are updated. I found that, the size of the database in 2005 is 24GB out of which the Index is of size 17GB....

Hi,

Thanks for your quick reply. The job is not running through SQL agent to modify the path in job setup. It is running through our third party tool which uses...

Hi All,

The script provided in both the url's is very good for 2005 environment. Is there a script for SQL Sever 2000 also. If so, can I have the link...

Hi,

I have a similar case, where one of my user asked us grant bulk insert permission, as he is trying to import a flat file using SSIS. I am new...

Hi David,

Thanks for the quick response. Hope the second link works.. I will try out and let you know.

KK

Hi Sameer,

I too have the same issue. We have a maitenance plan which runs on every weekend and failed with the same above error. As you posted, I have re-created...

Hi,

Before doing migration, you need to install upgrade advisory tool which shows you the issues comes with migration. This will help you to modify the things before only.

first migrate the...