Viewing 15 posts - 61 through 75 (of 251 total)
Heres what I think you could do (kinda like musical chairs):
Scenraio A (want to keep the UDT name the same)
1) Create a new temp type that is the same...
March 21, 2003 at 9:15 am
The above code is VBScript. It is designed to run in WSH, so just copy it into a VBscript file, and change the path ensuring you keep the \\\\ four...
March 21, 2003 at 8:59 am
What I would suggest is writing an XSLT that does an xsl:sort and use a xsl parameter for the sort. You can then pass the users parameter on to the...
March 21, 2003 at 8:33 am
Sorry, should have mentioned that I will post example VB6 code to do DNS lookups if anyone wishes.
Tim C.
//Will write code for food
March 20, 2003 at 9:06 pm
You could also do a DNS lookup through the API. That is if they ar enot putting spoofing their hostname like Chris said.
Tim C.
//Will write code for food
March 20, 2003 at 9:01 pm
You can use OPENXML for adding multiple rows. It is extremely fast. I can post an example tomorrow if you wish.
Tim C.
//Will write code for food
March 20, 2003 at 8:59 pm
Not only are you still thinking like a developer, but you are ignoring some very
sound advice from some knowledgeable people. At least about sql server anyway,
they may not...
March 20, 2003 at 8:54 pm
Are they hitting the DB directly? I use soap services to expose our com+ objects, and internally inside the com+ object when I obtain ObjectContext I also get a reference...
March 20, 2003 at 8:42 pm
eugene I think he was referring to being able to call .sql file(s) from within T-SQL file if I am not mistaken. Which is better left to batch files or...
March 20, 2003 at 8:35 pm
I actually like your code Phil. It is simple to the point of being elegant.
Tim C.
//Will write code for food
March 20, 2003 at 7:51 am
Paul watch out for putting spaces in your alias'es for your table and or column names. SQL Xml will convert them to the encoded version. AFAIK (I am not at...
March 19, 2003 at 5:40 pm
The only thing I can think of is writing a RegEx to run against the script. Would be beyond my regex capability, but I am sure it could be done....
March 19, 2003 at 5:23 pm
This script will let you know when files are created It is a straight copy and paste from the Windows 2000 Scripting Guide Book, and I have tested it out...
March 19, 2003 at 12:01 am
Like Gary said it is not nice, but here ya go : http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B180368 I have done this before, and IMHO that when I am storing this much text in SQL...
March 18, 2003 at 8:51 pm
Viewing 15 posts - 61 through 75 (of 251 total)