can u please let me know, how a service broker helps us to catch queries and how to set it up?

exactly you wrote 80% same thngs wat he asked....

following Ques.. i remember.

Q1 explain ACID

Q2 explain how a T-log follows ACID properties with example

Q3 difference between 32 bit and 64 bit

Q4...

ohh thanks..., so in transactional replication, after disabling jobs when we enable them again, dont they work as same previous they working or i need to start all the jobs...

is that possible to shrink a file less than to its initial size. i used to think that shrinkfile can be used to claim only unalloacted space. when i see...

no i am saying data size is 4 gb but mdf has initial size 191 GB. and m reducing it from the same window wat shown in screenshot but...

i am using 2005

ya m a DBA and DBs and login created by me

u r right, i checked the sql server log, i found that "BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically...

exactly, can i get script to get user of a database with their role, so that i can appy them to another database. in a single shot, it very iritating...

ya but the things is, we dont have much space in disk, we have around 600 databases in our UAT server, so for getting space m trying to remove older...

ohh i placed question in 2008 forum, sorry

i cant take compressed backup, using 2005.

i have done a normal backup

i am sending some important counter report, please have a look on it and let me knw what this report is saying and what kind of action shud i take,

this...

my server's Total memory is 8 GB and Sql server takes avg 5.3-5.9 GB

are you saying it is not worth ??? how wud i knw its more than worth??

do...

i have splited tht column in a separate table bt in the server i have only one drive so i cant make filegroup in a diff drive, bt i have...