Viewing 15 posts - 33,856 through 33,870 (of 39,736 total)
Where are the suck-ups? No votes for Andy, Brian or myself
. We have shirts and books to give away
July 11, 2005 at 10:57 am
You can create a linked server which will allow you to query a table on server B from server A. The syntax is in books online and there. There are...
July 11, 2005 at 10:50 am
As an update, I have moved this to administration (SQL Server 2k)
July 11, 2005 at 10:48 am
Beware of the times, which are also included. You might want to add one day to the end day if you are missing values.
July 10, 2005 at 7:33 pm
One of your fields is an identity field. Typcially you leave that field out of the insert () list and do not insert a value for it in the VALUEs...
July 10, 2005 at 7:32 pm
That's less fun. Besides, I think I learned a few things by reading all the posts ![]()
I ended up changing the alias name so...
July 10, 2005 at 7:30 pm
How do you tell that you have later dates? Is it just by the date? Is there some other linkage? If it's just by date, then how would you ever...
July 8, 2005 at 10:26 am
I like using something to differentiate variables from other code, especially non SQL languages.
for iCounter = 1 to 10
instead of
for counter = 1 to...
July 8, 2005 at 10:11 am
I think that things make more sense if we differentiate case sensitivity and programming is aided by using mixed case. But most humans don't work in mixed case well....
July 8, 2005 at 10:08 am
You can pass paraameters to a DTS package. There is also a looping example here: http://www.sqldts.com/default.aspx?246 that might work for you.
July 8, 2005 at 8:19 am
David,
That's really weird. AKAIK, BULK INSERT is a wrapper for the same code as bcp, but apparently that doesn't seem to be the case. All the servers have SP4? Are...
July 8, 2005 at 8:16 am
Have you checked that the SMTP server is receiving the message? It looks like it should work, but honestly, I've had issues with CDO/CDONTS. I used ASPEmail from my SQL...
July 8, 2005 at 8:07 am
I think the function might necessiate a materialization of the data in tempdb, such as an order by or a group by does.
July 8, 2005 at 8:05 am
That is strange. When you say they are spaced by 5 minutes, do you mean that the times between all emails are 5 minutes, as in one is sent and...
July 8, 2005 at 8:03 am
I tend to agree, though if you have some auditing requirement about the information that's stored there (job history, backups, package changes, etc), then you might want to move to...
July 8, 2005 at 8:01 am
Viewing 15 posts - 33,856 through 33,870 (of 39,736 total)