The client & server are in the same domain. We ran the setspn stuff against the SQL startup account in AD and enabled kerberos delegation.

I'm not sure how to...

I am trying to use the Transfer Login Task in SSIS to create logins on our new dev server from our old dev server. Both servers are SQL 2005...

I am trying to use Expression Builder to attach a file to an email. I want the file to be the most recent file in a particular folder. ...

Can we restore master, model, msdb backups to a 64-bit when they were done from a 32-bit? Are such stored procedures as sys.sp_tables_info_90_rowset_64 on the 32-bit install?

This link maybe helpful.

http://jesseorosz.spaces.live.com/blog/cns!E322FD91218E57CF!176.entry

I was told the software use to allow up to 8 characters. However, it was changed from 8 to 6. But you bring up a good point. ...

I am getting the same error. Did you ever find a answer to this?

What value type and value did you use for the variable?

My problem was I am working in 64-bit. There are no MDAC drivers for the 64-bit architecture. Therefore I can't refer to Excel or Access. To get...

I've made all of my changes through the maintenance plan.

I selected 'When the job fails' from the dropdown.

How would I create a temp table with identity column and then link them together?

I found this script works well with defragmentation.

USE database --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM information_schema.tables...

Can you use the Maintenance Cleanup Task?

Here is the input data.