You could try the following in an asp page:

set adoConn = Server.CreateObject("ADODB.Connection")

response.write adoConn.version

...

It is definitely a useful procedure to have, especially when there are cases when you would like to be left alone and get on with the real work instead of...

Must close the newline terminator ...

SET @Query_tmp =

'BULK INSERT dbo.dbAnntest FROM '+@TmpLocation+' WITH (FIELDTERMINATOR = ''\t'', ROWTERMINATOR = ''\n'')'

What version of Sql Server? 7.0 did not come with these options...

Try using DTS ...

I don't know your reasons for restricting certain apps from connecting to the SQL Server.

Much better would be to create the login and make this login a user...

First off, if the sprocs are using cursors and don't do any updates (i.e. update using the cursor), ensure that the cursors are declared as read-only.

From the symptoms described, it...

This calls for some lateral thinking ...

First off, we require a list of database names in the backup_set;

then we require the last date when differential backups took place;

then we require...

The right way to perform backups is to backup the database followed immediately by a backup of the transaction log. This way, you maintain the logs at a reasonable size...

try:

sp_helpsort

from QA. HTH.

Have you updated the stats?

Check the Auto Update Stats option under Options - if it isn't set, then execute sp_updatestats in the database, from QA. Might take a long...

Have you tried restarting the SQL Server? It appears you might be having "zombie" troubles ... (a process that is really dead, but locks still being held by the SQL...

I expect you have detached the database.

From a theoretical point of view, it appears that SQL server is trying to create a new log file on top of the...

Have passwords / accounts expired?

Try using LEFT as in:

USE pubs

GO

SELECT 'title'=LEFT(title, 5)

FROM titles

ORDER BY title_id

GO