What application are you using for the unzip process?

As for the question "so do i need to create nearly 100 identical tables to audit them", do you just want to keep track or actually keep the data?

You don't have to have a "telnet server set up". You just use the command prompt: telnet 1433/1434. You can also type SQLCMD /L to see which...

In Visual Studio 2005 there is an additional parameter in the connection string-providerName. Here is a sample of one I use:

add name="cstCWR" connectionString="Data Source=server;Initial Catalog=dbname;User ID=user;Password=pwd"

...

A couple of questions:

1. Is the SQL instance you're connecting to a named or default instance?

2. Any chance you could post the connection string you're using?

Thanks-

TC

A couple of questions:

1. Do you still have BUILTIN\ADMINISTRATORS on the SQL instance?

2. Which account do you have the MSSearch service running under?

At one place I worked we had the...

Take a look at the context of your connection. I noticed that you say select ... from tempdb..sysobjects, but your drop table statement does not include tempdb.."table_name". Try...

Thanks for the excellent article, Sushila. I've thought for some time that a kind reminder of manners was needed for the site, and you managed to hit points for...

I found this link on the IBM site:

Transforming WebSphere Information Integrator Event Publisher messages with WebSphere Message Broker.

Hope it's useful.

No. The restriction is an Exchange-based restriction to prevent people from using your company's email server as a spam profilerator.

When sending from Access or VB, are you using an SMTP engine installed locally on your computer?

If you are using Exchange as the email software and running the...

Do you want to see the results "on-the-fly" through a message box, or is it part of a bigger plan like a DTS package or other function?

I developed a DTS package for a client that is very similar to what you are looking to do. It uses T-SQL to obtain the name of the filename/location...

I am glad to see you used SQL in such a useful way. I use DTS packages to pull information from each of our syslog servers into a database...

Are you looking for a shared SQL environment or merely a place that will house and monitor a SQL server that you can call your own? In the shared...