I have already written a stored procedure and placed in my blog http://sugeshkr.blogspot.com which archive data for a datefield every 45 days you can change the sp as per...

The full backup will be backup of all the pages in the database and it need not be necessarily as the same size of the database it may be slightly...

In the excel set the column that has those value to be of type text and in sql server use the datatype either char/varchar to import the data and that...

What michael says is right. You can't have integrated scuirty parameter true and use the uder id and password combination. If you find difficult building your connection string build a...

Since you say that for one user it works and for the other it doesn't it sure that its a permission issue for the user for whom, it does not...

In 2005 you have to use SSIS to import and export data. I hope your requirement is achieveable with SSIS and can be done perfectly.

Brandie, read the link below to know thing about HOPPING in sql

http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp

in sql 2005 yu can use sys.dm_exec_coonection to find what's the type of connection is being made....

George --

Just FYI.. you are in a 2005 forum and remember that you can't use enterprise manager with sql 2005. also few syntax for logins have changed in sql 2005.

I did some tuning in the server side than the query and achieved something beeter than what it was before. The things i did.

1. Enabled /3GB switch to make the...

the query should be select * from [DSTAGE].dbo.SALES.

your syntax is wrong.

Still your system stored procedures uses the same naming convention change is that they belong to different schema than earlier versions. So better to keep your database server safe and...

The select can have the nolock hin in it. The transaction can be read commited. Any more suggestion read for isolation levels in BOL or the below link

By default loclz connections use shared memory protocol, are you sure that the protocol being used us TCP/IP. you can check this with DMvs.

You can use the GUI to create a new user assign permission. Start the management studio and navigate to security folder to play with the users, roles and permissions.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

You can download the upgrade document here.