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...
If you have scripted the entire DB , then send the .sql file to the client , when he creates the DB he too would be able to get the DB Diagram .......
I mean as a DBA , what does it mean stating that I have exp with the production environment & having exp with the development environment.........
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...
There is no problem with the DB, its just that was trying to understand the concept ... <img src='/community/emoticons/emotion-1.gif' alt=':)' />...
LOL , so you plannin to do MCDBA or a MCSD, anyways dude its not a good idea to take help from Dumps.....
The BOL has a good amount to info .....
Hi The following is the result of the DBCC Showcontig DBCC SHOWCONTIG scanning 'publishers' table... Table: 'publishers' (2057058364); index ID:...
Constraints allow you to enforces the integrity of a database. A foreign key in one table points to a Primary key in another table. Thus you cannot...
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...
LOL what abt the coffee Waqar LOL
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
Hey got the entire Details from the BOL ..... Feature Disk space requirement Database Engine and data files, Replication, and Full-Text Search...
The SQL Server 2005 database components require between 95 and 300 MB of disk space, depending on the specific options chosen. A typical installation...
Hi I need some templates or document examples to create a Disaster Recovery Planning document for SQL Server. Please help. Regards
Separate names with a comma.
