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...

If my experience is any indication, you will want to have separate machines for the SQL server and Terminal Server. All of our overseas users, and many of our domestic...

We have an in house developed program that lets users check passwords in and out for privileged ID's. The program lets you select the ID, then you click Check Out...

RYan Ackley (1/30/2008)

---

I am a former member of the SSRS (SQL Server Reporting Service) 2008 development team. I was a developer. I would like to respond to some of your...

Applying patches without any testing is really bad, and will, at some point, lead to severe problems. We've been with our vendor for over 20 years, have a great relationship...

I'll also add that the vendor should not be doing anything to a production server that hasn't been tested thoroughly on a test server. If your company is subject to...

We use the underscore _ character as a separator. Using periods can lead to confusion, given that other programming languages use them as separators for actions on objects. I hate...

My company's policy is that no one, ever, gets to use sa. Software that claims to requrie SA is either rewritten by the vnedor to use a dbo ID, or...

I'll add my endorsement of the Reacher novels. Great stuff. I'v ealso been reading anything by James Rollins, the Agent Prendergast novels by Douglas Preston and Lincoln Childs. Right now,...