quote:

---

created a simple DTS package using ADO

---

Can you post the connection string, with replacements for...

The Microsoft SQL Server client tools can be installed on a Windows 98 platform. What you may have to do is go into the Client Network Utility (also part...

Hi Mark,

I made the transition myself a couple of years ago without too much trouble. In '98 and '99 I did systems administration for the AF and for BellSouth's...

Yeowch! And you can quote me.

sp_ is reserved for SQL Server system stored procedures, but they aren't reserved... Which means Microsoft doesn't want you to use them, but they...

Here's a discussion that's going on in the Backup section. Steve Jones has a script referenced that will shrink the log file. Some other methods are also discussed,...

How are the stored procedures named on your databases? They aren't sp_ per chance, are they?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

A couple of people mentioned Profiler and that's a bread and butter tool here. One thing Profiler will give you when you do a capture is *how* the data...

We use Visio where I work pretty much because it's part of the MSDN Universal. I agree it is fairly limited. We did review ERWin and weren't very...

If you are looking to do processing, there is an Analysis Services Processing Task. So far as an icon is concerned, it's shaped like a cube.

If you are looking...

How are you accessing SQL? Via ADO?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

We dealt with this issue with a former organization. Had a group of contractors in working on a Sybase database running on NT 4.0 and they thought nothing of...

I'm looking forward to VB.NET. Too many "little" issues with VB.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

You might take a look at the CASE statement to get divergent paths in the SELECT statement. There are some pretty good examples in Books Online... especially using CASE...

What you are most likely going to have to do is

DECLARE @result int

EXEC @result = master.dbo.xp_cmdshell '<command line>'

or something similar and test @result. That's the only way to get the...

Wow. Though I'm not surprised, I guess. I understand why Microsoft probably didn't send anything about it because they don't consider it a security vulnerability (assuming everyone would...