You could use the migration assistant or simply SSIS.

If you're not comfortable with SSIS, you can set it up with the Import/Export wizard and save it as package for further...

If your database is maintained properly (I'm assuming it is), shrinking the data files will have no effect in the long run (files will likely grow again), so I think...

Roust_m (11/14/2011)

---

Hi,

They are going to put a lot of records with nvarchar(max) values into a table (around 3 million). The table will grow from 3GB to 300GB and make...

Personally, I would change the collation for the whole database.

If this is the only database on the instance, I would also change the instance default collation, in order to avoid...

GilaMonster (11/14/2011)

---

I'm already taking a...

Me too. Morning means night for you....

With my powers of divination I foresee just a few more threads like this one and Gail taking a break from the forums again.

:hehe:

Create a scheduled task in windows scheduler and set it up to run cmd.exe with...

Congrats Jason for winning T-SQL challenge 63!

I'm not a C++ developer, wouldn't know where to start.

This page on MSDN will probably help you: http://msdn.microsoft.com/en-us/library/ms130892(SQL.90).aspx

However, keep in mind that SQLNCLI OLE DB provider is a low-level,...

Yes

Is SQLNCLI provide their own API for connection or retrieval of data from SQL Server or use api of...

This should help:

http://spaghettidba.com/2011/10/13/concatenating-multiple-columns-across-rows/

Roy Ernest (11/8/2011)

---

Hey everyone, I am hijacking the thread with an "Off Topic"

I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal) His idea is...

AFAIK DTS packages have always been stored in msdb, not in master.

select *

from msdb.dbo.sysdtspackages

The same applies to SQL Server 2005.

I don't think I understand the rest of your question. How...

You can connect to SQL Server using either ODBC, OLEDB or SQLNCLI (SNAC).

SQL Native client is a mix of OLEDB and ODBC, but that shouldn't be a concern.

The connection library...