Viewing 15 posts - 1 through 15 (of 24 total)
Is sp_addscriptexec only visible in 2000? I don't see it in my SQL 7.
September 26, 2003 at 10:44 am
On another note, the DTS doesn't let me select the system tables in the destination (its SQL 7). Have I just missed something here?
September 25, 2003 at 5:11 pm
What would the DTS package look like that's been described? Would it just be copying the appropriate syscomment and sysobject rows to the new database?
Any code samples...
September 25, 2003 at 5:10 pm
If you were to use IsNull earlier and if it is a NULL, converting it to a date that is sure to be outside of your range, it could solve...
August 11, 2003 at 3:34 pm
I should also point out that I'm able to send mail through, but only if it doesn't have a @query=. Text messages seem to work okay.
AndreQ
August 11, 2003 at 1:51 pm
Yes, my statement in the first line of the first message was that I was running SQL 7.
Does anyone know of a way that I can do this...
July 30, 2003 at 9:42 am
Maybe we're running a different kind of SQL server. The only related type tables in our MSDB database are sysdtscategories and sysdtspackages. There is nothing about any log...
July 30, 2003 at 9:37 am
My SQL Server tells me that package logging is only available in 2000. I'm running SQL 7. Nice idea, though.
July 29, 2003 at 2:40 pm
Is there a way for me to save this information? The load on the server is lighter overnight when its run and that's the time I'd like to have knowledge...
July 29, 2003 at 2:14 pm
Fair enough. Many, many sites have the motioned ads.
How about moving them to the right where I can then shrink my window away from them? Check...
July 10, 2003 at 11:20 am
Back to the original question. The story goes is that Codd came up with an earlier version he called QL or "Quel," for Query Language. The next time around...
May 27, 2003 at 11:43 am
Never mind. I just found
master.dbo.xp_varbintohexstr
May 23, 2003 at 4:48 pm
The code that I'm dealing with requires a prefix that may or may not be there. The suffix is just a straight counter with leading 0's.
I would...
May 23, 2003 at 9:16 am
No, you're not.
Your last response gives me some good ideas for future projects, but the website that I posted in my last response (the one about temporary tables)...
May 22, 2003 at 2:53 pm
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first...
May 22, 2003 at 1:25 pm
Viewing 15 posts - 1 through 15 (of 24 total)