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.