greg,

i was just trying your script. a few doubts

1.should i configure the job on the same server on which i need to capture the trace ? what if the trace...

you can follow this link psoted omn this site

http://www.sqlservercentral.com/Forums/Topic456549-54-1.aspx

thanks greg and george for your help.

george,

i was just having a word with my VMWare administrator and he was telling that he will be configuring the base hardware the same...

logshipping can be configured using enterprsie amanger if you ahve sql server enterprise edition.

incase of standard edition you will need to run script to configure log shipping.

in case of...

thanks george for your help.

i did not understand what you meant by this statement.

why put the prod server on vmware and test on dedicated machine? Surely less risky and impact...

hi terry,

thanks for your response.

please could you guide me as to what things i need to take into condiderations while moving the d/b from physical servers to vmware.

thanks greg for your response.

we are planning to move the production dbs to vmware . where as the test db will be on the physical m/c which is now being...

thanks greg and mani for your help. i had a tough time searching my packages after the upgrade !!! 😛

thanks gail for your help

hi all,

thnaks for all the help.

the problem was found. somebody accidentally inserted a lot of records in these tables. we are now in the process of deleting all the unwanted...

executed sp_spaceused and got the follwoing result for the heavily used table

Table Name|row_count|reserved|data|index size |unused|schema name

Notification|71603|44886096 KB|44875328 KB|4080 KB|6688 KB|dbo

WorkOrder|49323|44774984 KB|44760448 KB|7392 KB|7144 KB|dbo

**********************

NOTIFICATION TABLE SCRIPT

if exists (select...

Sachin,

thanks for the reply.

the d/b is in simple mode. so it is not the question of the transaction log backup.

thnaks everybody for the help. if i drop and recreate the user everything works fine.....but i was wondering as to why when i jsut give additional rights to the user...

thanks kevin for your help.

i tried creating a new user and this thing worked. but if i give rights (dbcreator) to an exisiting user it does not. don't know as...

sorry i did not mention it earlier i am using sql server 2000