Its sitting on a SQL Server 2008 table.

One thing that has helped is setting the On truncation to ignore rather than fail component. I looked through the data and...

Well, granted this is different in that it returns the column names of those containing the queried value. I found it here: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2

Here goes:

CREATE PROCEDURE FindMyData_Number

...

I have a number of questions.

1. Are you using the Excel Source?

Yes, although I've tried converting the data to csv format and importing it using the flat file connector. ...

Duh. Right, sorry.

Why not use SQL Server Integration Services? In SSIS 2008, you can use the import/export wizard to specify the input as an Excel file. You can then choose...

Hi,

No actually I just want a monitoring tool that identifies the most common performance issues and allows me to export it into a common file format, such as csv, tsv...

Is it customary for the customer or the remote DBA provider to furnish the VPN? I was thinking of setting up a VPN with SSL for my practice so...

Hi,

Do you want to send me your resume, location and hourly rate to rsteckly@idealcode.net.

Looking forward to it,

Ron

Hmm...thanks for the comments.

Obviously, coming from the developer world I might be "certified" but short on experience. I'm going to partner with a much more seasoned DBA to ensure...

Hi Jeff,

Would you mind emailing me offline to talk about the problems you've faced? I really want to make sure that what I offer people doesn't give them the...