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

This is why all companies whould have policies on the management and protection of information that spells out the different classes of data (company use, private, etc) and what steps...

Try running some of the inquery analyzer so there's no impact from the application.

Personally, given how cheap memory is, I wouldn't try to run a server with less than 2GB...

In our environment, we have folks called DBA's whose main role is to check out a privileged ID from an automated ID control system, run the scripts they are given,...

And, if you work for a company whose stock trades on a US stock exchange, you better have comprehensive change management policies in place or the SOX police will be...

Why not query the information_schema views to get the data you are looking for? All of the contents of SP's, views, etc are exposed in those views.