When you say, u scheduled the job, did u wait for the job to run? Because I think once you create the maintenance plan, it has to run at least...

Rookie and Squffey,

I have a question on same lines and hopefully u guys can help me. My services account and sql server agent account both are set to run under local...

I am just interested to know, what company or project you work with?

How many DBA's do you have to handle 100's of sql server? Are we talking actual sql servers or...

tempdb rebuilds itself everytime a sql server is started. Trying shutting down sql server and restarting and see if that helps...

taj

Ramesh,

Try this..this is a unorthodox way but you have to try it to see if it works...I have tried it and it works fine on user databases.  Create a blank...

Thanks..you were right at mark....BOL should say something about this.

Thanks once again

OK....if you get it please let me know. I would like to test it too.

I have never seen or heard anyone using it.

TIA,

I dont think it is a good idea to register sql servers through the script. You should register the servers manually because there are manual settings needed to do the registration.

I...

I think recosta is right. That is not a sql server error so must have been put in if certain condition is true....Looks like its ignoring the condition and displaying...

Now I think of it and after trying some scripts here is my 2 cents.

when you logging a failure you will not get the record because during the record failure,...

t

Are u performing your insert, updates and delete through a stored procedure. If Yes then its can be done. Basically you would have to create a second shadow table for...

Table locking is very tricky and simple in sql server if you understand it. First check table locks using sp_lock and see if actually table is being locked or use the enterprise manager to...

Well, I have worked with sp_spaceused and frankly speaking the numbers dont make much sense to me either. but to get better picture of the database space being used, I...

I agree with all the surrporters of the Redgate. Its a great product. Been using it for about 2 years now. no complaints yet..

Taj