This might help

@echo off

CLS

set /p UserName=User Name:

set /p Institution =Institution:

set Args=

set Args= -q "SET NOCOUNT ON UPDATE USERACCOUNT SET USERPASSWORD = (SELECT 'ER' FROM USERACCOUNT WHERE USERNAME='%UserName%' AND INSTITUTION =...

also on scripting the logins sp_help_revlogin doesn’t scripted server roles

Use the following query to script the server roles from prod, and executed in test bed .

SELECT...

What is the error message u r getting ?

How many files does the backup set has?

Does the database has any secondary data files ?

if possible give the screenshots

Run the SQL upgrade analyser and findout if any depriciated queries are used in ur 2000 database. If not change the cmpt level .

If there was any,change the code...

Read articles from http://www.sql-server-performance.com/ ..It has all useful info on writing tuned queries.

Thanks JeremyE .

I did some search and got some info ..here s that

The information about killed sessions was available on one of the undocumented DMV sys.dm_os_ring_buffers , with ring_buffers...

sp_executesql will do

sergey.benner , I tried with the single image file as you specified ,, still the image was correpted .. Is there some thing else we need to check ?

Sample...

CREATE TABLE files

(

--FileId INT IDENTITY(1,1),

filepath varchar(512)

)

--I had my IMAGE file path in out.txt

BULK INSERT dbo.files

FROM 'D:\SQL\SQLWorkOut\out.txt'

WITH

(BATCHSIZE = 1,

ROWTERMINATOR =''

);

select * from files

CREATE TABLE bindata

(data varbinary(max),

fileid INT IDENTITY(1,1)

)

/*

CREATE NONCLUSTERED...

I tried the code by storing and retriving a Image File . Retival of new file by BCP command , the files are not meaning ful . Image does'nt displayed...