Does the query you use in BCP work when run from SSMS?

Try issuing DBCC FREESYSTEMCACHE('All') and then you should be able to shrink tempdb.

See here for more details: http://www.sqlservercentral.com/scripts/tempdb/72007/

Another option could be a reverse proxy listening on the "old" address, port 1433, and redirecting to the new address, named instance port.

Another suggestion:

http://www.sqlservercentral.com/scripts/tempdb/72007/

Create a SSIS package to populate the file, add the package to a job step and run sp_start_job.

Personally, I would try to avoid xp_cmdshell.

This is something you can change during the setup.

itsamarnath (12/1/2011)

---

I got the error message that sql server 2008 R2 setup required .net framework 3.5 SP1 to be installed?

what am I suppose to do here?

I see that .net framework...

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1214605.aspx

Create a work table in DB2 and insert all the Account Numbers, then select using "IN (SELECT AccountNumber FROM WorkTable)" in your OPENQUERY.

Yup.

SQL Server should stripe data between datafiles automatically. I think that rebuilding all clustered indexes after adding the new files should do the trick.

However, I would suggest to identify objects...

Try googl'ing "Exchange OLEDB provider".

You should be able to create a linked server and query Exchange data as a database.

Hope this helps

Gianluca

You can't create triggers on system objects. I've had the same issue some time ago with replication tables.

IIRC, it should work from a DAC connection, but I don't think it's...

Yes, add node to existing cluster.

Wrong password?