MCDBA EXAMS

Can any one tell Which are the exams to take for MCDBA and books prefered for the same

mulitple nic cards

We have two servers, one an application server and one a database server with sql server7 /NT4. The…

DTS import from excel

i am trying to import data from MSExcel to SQL 7.0 database. i have to import data from one spread …

SQL Server Administration

Can any one guide me on SQL Administration on topics i need to concentrate, ie, specific topics eg.…

INSERT UPDATE DELETE permissions

I am running SQL 2000 s/p 1. When my users leave at the end of the day, they have permissions to IN…

SQL server administration

Any body can guide me on topics i need to concentrate on sql admin.

Createing a Stored Proc from a Stored Proc

(SQL 2000 SP1) Basically I have been asked to find a way to create a new stored procedure in a diff…

Loading MDF/LDF files

Hi, I need to recover data from MDF/LDF files, is this: 1. possible to do 2. how is it done, do I n…

Stored procedure into a table?

Hello, If you have a stored procedure like: create proc testProc as select * from myTable Is there …

Text File Import Errors: Missing Rows

Another department have written a DTS package which uses Text File Import rather than direct DB con…

Scheduling Batch Cmd from SQLAgent

Mornin' all, I've been trying to use the SQLAgent to run a batch command on the server but nothing …

TSQL -insert script in MSQL database

Thank you very much for your useful help I need to import in my SQL database external data from acc…

mmc.exe error

When I right click on table and go to Desing. I get an mmc.exe application error. Teh instruction a…

Veritas Backup/Restore

I read some of the previous questions regarding Veritas, but need a little more detailed informatio…

Referencing objects as dbo.