Yes that is the best answer i think.

The other ideas of creating the SPs and running them every 30 seconds will be pain as well as resource consuming .

Regards

This is your answer my friend 🙂

sp_msforeachtable 'ALTER SCHEMA test TRANSFER ?'

this will change the schema to test .You can change it to employee.

make sure you are in the...

If i am not wrong you are looking for the current size of all the objects in a Database and current size of all the tables in a database .

You...

Actually you are right .T-Logs DO NOT work on the principal of porportional fill...

I apologize for my previous mail .....

Regards

Abhay

Pradeep its not the round robin algorithm that SQL uses any more .Perhaps it would have been in the earlier builds .But 2000 onwards we use proportional fill algorithm i.e....

Here is your answer for both SQL Server 2000 and 2005 :

backup log test with no_log <-- take the tail log backup .

dbcc shrinkfile (test_log2,emptyfile) <-- shrink it and empty...

you should have a backup to restore 😀

and that should be valid ..

Please ask what you want to know ...this was a closed ended question .

I am not sure how...

check the attachment

(1) is this doable? ie can i install multiple instances on a cluster, and have them use specific cpu cores? eg let's say i have installed 3 instances on a...

Please type the complete error from the error log ..

The dump error is usually quite big ..

This is a kind of Assertion/Exception raised by SQLDumper utility (SQl Debugger)..you also have the Query due to which this is happening .

You can run this query in the QA...

Yes if you are using a Trusted connection then SQL will use Windows authentication .The othe option is to use login and password (do Sqlcmd /? to know more)

Secondly ,...

Its good to try this option .Once you are the Admin on the server , you can do anything ..But you messed big time my friend 🙂 ...this is how...

Dear friend(s),

/3GB switch is related to Virtual memory .

When any new proccess borns it gets 4 GB of virtual memory .

This 4Gb is divided into 2GB (used by OS for...

I think we use the stack space for keeping the context of the thread during context switching .Thats the reason i used it :-)..You can always correct me Paul:-).