I have to create a new database .
I need around 15 Tables to be created .
2 of the Tables have around 80 columns .
Rest of them have 5-10...
I have an excel sheet with the Specific Backup Details.
1.Server Name (Eg: Prod)
2.Database name ( Eg:ABC)
3.Backup Job (Eg: Prod...
I queried select * from sysdatabases and got list of 30 databases.
But I have 29 databases in the instance (GUI) .
Why doesn't the DB...
WE have a PROD environment with around 200 DB's. We used native SQL backups for DB backups. Recently, one of the DBA installed Quest...
Its not a real time question,,, But a question I faced in interview. Just wanted to if some one could answer it .
We have a database...
In our existing environment, We have SQL 2005 and Varicent Tool on same box. We have specific SSIS Packages which were put in a batch files and...
Separate names with a comma.