Since your new to triggers and it looks like you're dealing with a ticketing system, one thing to be aware of is that triggers in SQL Server 7 and the...

I pretty much stick with EM or Visio for modeling, mainly because those are the choices I'm limited to. Neither one really suits my fancy because there's a lot...

You can choose a non-obvious key and encrypt the files with it. Even if someone is looking at the VB program, the person has to realize you're using a...

The question about how they were defined is for haidong. SQL Server type of procedures will use @P1, @P2, ... @Pn. But generally this is a bad practice...

I've not installed App Center Server, but the way it works I don't see how it cannot add overhead. Clients talk to the App Center Server, and the App...

JOINs can take advantage of pre-existing indexes. They don't create them. That's what Antares is getting at. So far as joins are concerned, think of things in...

I've been looking, and I am not seeing any other solution other than dropping to command shell, either with ipconfig /all or nbtstat -a <hostname>.

For instance:

SQL Server 2000 does a better job of caching ad hoc execution plans, but it still isn't at the level of stored procedures. Also, there was that matter of...

I agree with Steve wholeheartedly because, well, I did try the search about a year ago (on Google no less) and found and installed a stored procedure/view decryption program on...

This is generated by the server, and you'll see the parameters clearly for Cursors and prepared SQL statements.

If you are trying to track what are truly user defined...

Two minor changes. There are two areas where mx.COL2 should read mx.MAXCOL2. Don't switch the SELECT clause to mn.COL2, it'll actually increase the cost of the query. ...

Ah, I see an issue now. Since you don't have SQL Agent running and you're trying to get it from the server, there aren't any processes running under the...

First, have you created a profile in Outlook and verified you have the ability to send and receive? Is it configured as a POP3 server? This is outside...

No, Aunt Martha protects her recipe with a cast-iron pan.

K. Brian Kelley

bkelley@sqlservercentral.com

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

Do the clients have Query Analyzer?

K. Brian Kelley

bkelley@sqlservercentral.com

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