I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that...
Hi What if I have some user , who has access to the SQL Server Client Tools, & he types in sql - L in the command line & gets access to the names...
Hi Heard a lot of people talk abt production & development environment what all do they mean ..... Does supporting a production environment mean...
I am doing log shipping, Now there is some data that i need to insert into my master & then use that for some hours & get rid of it, I dont want the...
Hi The following is the result of the DBCC Showcontig DBCC SHOWCONTIG scanning 'publishers' table... Table: 'publishers' (2057058364); index ID:...
Can someone please explain the difference between the Full & Bulk Logged recovery using some senario ... I cant understand teh difference have read...
HI is there any command to knw whether any table in a DB is pinned Please help..
Hi I have configured SQL Mail on my Server, everything was working fine, but all of a sudden, its stopped , I am damn sure there is something wrong...
Hi I have to give a report out stating the Min,Avg & max values of the memory utilization . Now when I run the perfmon it shows me the values ,...
Hi Need all the aceptable values for the various Perfmon counters that we need to monitor for the SQL Server. Thanks Regards aki
Hi I need some templates or document examples to create a Disaster Recovery Planning document for SQL Server. Please help. Regards
Can someone let me know any 10 things that are usally automated using the SQL Server Agent, I mean besides backup what all can i automate Thanks
What all are the command , or what for should one look out to confirm if nothing is wrong with the DB & its the application that is creating a prob.....
Can someone tell me atleast 10 tasks to automate using the SQL Server Agent. Thanks
How does one figure out, I mean compare the results after some changes have been done to the SQL Server, I mean the method in which the comparision...
Hi I need to document all the tables & the fields of it & the data type , the PK & FK keys & all that Can anyone suggest the fastest method to...
Hi I have a DB that has some indexes clustered as well as non-clustered, The Db is being used , I want to run the index tuning wizard. Can i drop...
I have a windows like permission structure. Lets say we have users who belong to groups & there are rights that are given to a group A user can be...
Hi I have 3 tables & 10 projects with 10 tables each , I have create 10 different databases. Now I have 2 options either I make a sharedDB for all...
Hi I have heard that SQL Server can support upto 10,000 users, What if my application , connects to the sql & does not do antything then , why...
Separate names with a comma.
