You can do it via vbscript. Here's a snippet of code that you can work from:

Dim objNet, sServerName, sUserName, sDomainName



Set objNet = CreateObject("WScript.Network")



With objNet

sServerName...

I admire your tenacity and ingenuity Steve. 😉 I just took the lazy man's way out and did a search for "duplicate index" on the SQL Server Central search....

Well, for some reason I just didn't think this one through. If I had to do this from start, the CaseClosed flag wouldn't exist in the Case table at...

Gary, interestingly enough, the application has an audit table already established with the typical fields (AuditDateTime,User,TableName,FieldName,OldValue,NewValue,etc) and as it turns out, this is one of the problems with the original...

amachanic,

1) This technique is still being used many years after it's creation, and being used by many other developers that may at first balk at the concept due to purity...

amachanic,

Yes, I realize that it's not 1NF. In fact, I mention that in the article.

Now, I know that there are probably a number of you who immediately see that...

I read the article thinking that I might find a technique that could make my database designs either easier, faster, or better in SOME way, but I don't believe this...

Look at some of the articles here http://www.sqldts.com/default.aspx?6,101,101,5,1 This should give you some ideas on what you're looking for.

David

I think that having a GUID as a PK is an acceptable (didn't mention preferred) practice. Having it then clustered seems to make no sense whatsoever. I highly...

PCNutall, can you give us an idea of what your udf looks like? It sounds to me like all you've done is move the dynamic aspect of the sql...

quote:

---

3 additional suggestions.

1. Add a check that prohibits injected SQL from being run in you where clause. (It's actually a...

I'm not sure if I understand all the issues, but since you have 2 tables that are basically the same, but with just different aged data, I would first make...

I do a lot of data mart / warehouse development for one of the top 3 banks in the US and they have 100's of SQL Server installations and some...

You should be able to just back it up to a fast tape system and restore from the tape. The tape shouldn't take more than 4-6 hrs probably. ...

I'm currently using the format of:

/******************

Name: s_MyProc

Parameters: @p1,int,in,This parameter does ...

Purpose: This proc does ...

Background: The reason we needed this proc was...

Example: EXEC s_MyProc 1 (this...