Is tempdb set to autogrow? If not, that might be the issue as well. One application I support makes liberal use of temp tables. A guy I knew at another...

If your encryption tool works like PGP, it may be trying to use or create temporary working folders. You may need to give permission on the folders to the account...

I second the backup and restore method. Create the databases on the new machine, then restore a backup from the old machine. Copying the mdf and ldf files is a...

My wife wanted me to get an MBA. I pointed out that I would either have to quit my job, or spend evenings and weekends for the next several years...

I would love to improve the vendor package I support, but management won't let me unless I can convince the vendor to make the change. Which happens occasionally. Unfortunately, some...

We only have one instance per server, so that simplifies things somewhat. Each server has service accoutns that follow a naming ocnvention that includes the server domain and the server...

On more than one occasion, I've wished for a BCD data type like IBM uses on the AS/400 (iSeries now). Specify enough places, nad there's never a rounding issue. Of...

I've been doing things with computers seriously since 1973, when I was in the 10th grade, and have spent most of my working life using computers to improve business. However,...

If I'm taking a few days off and staying at home, I'll check email a few times jsut to make sure there's nothing catastrophic hapening. If I leave town, I...

Here's something I've used lately for listing columns in a query:

select 'a.' + column_name + ','

from information.schema.columns

where table_name = 'table name you want'

order by ordinal_position

This gives me the prefix and...

In SQL2000 a user with rights on the destination server can save a DTS package directly to the new server.

Open the package in the first server

Choose Package->Save As from the...

Ghanta (3/23/2008)

---

Found the problem.... the problem was with the ODBC driver. I have to move this table to dev server and do that that export. I have a table with...

Is there any reason not to just create a table with create table tempdb..tablename...., and then explicitly drop the table when it's no longer needed? Taht table will survive until...

Here's a two sample of bcp commands I use to transfer data from one database to another:

bcp Database..TableName out Drive:\FolderName\table.out -T -S SourceServerName -n

bcp Database..TableName in Drive:\folderName\table.out -T -S...

The biggest issue we've had with using money datatypes is that reports in Crystal, and other tools, put a $ sign on each foeld by default. Given tha tI support...