Viewing 15 posts - 106 through 120 (of 135 total)
Some good ideas.
Thanks for your help.
Howard
June 4, 2005 at 11:24 am
Thanks for the reply.
I was hoping for a way to compress the backups prior to copying them to my server.
June 4, 2005 at 9:31 am
You said: Also, your query is returning rows everytime the ID in test = an ID in test. This will always evaluate to True. You will get a row...
March 8, 2005 at 11:34 am
For those that are following this thread in response to this suggestion:
March 8, 2005 at 9:54 am
For some reason the following example does not work. It gives me a higher count than all of the other examples.
SELECT * FROM TEST
WHERE ID IN (SELECT ID FROM TEST)
OR ID...
March 8, 2005 at 9:47 am
Thanks to everyone for the excellent responses to my question.
Howard
March 8, 2005 at 9:33 am
Both appear to work just fine. Thanks for your help.
Do you have any idea as to which one would be more efficient when running against large tables?
Howard
March 3, 2005 at 2:26 pm
Noel:
Thanks for all of your help.
Howard
February 16, 2005 at 3:39 pm
Noel:
The jobs are sending the email on job completion or job failure.
How do I know if the jobs are using the Address Book?
Howard
February 16, 2005 at 11:19 am
Noel:
Thanks for the input. I had looked at this incident from Microsoft earlier but I don't believe that it is the cause of my problem or I am not sure that if...
February 16, 2005 at 9:45 am
Both SQL Service and Sql Server Agent are running the service under the same account 'SQLService' account, not the local system account.
February 16, 2005 at 7:12 am
Thanks for information. I will check this out if this happens again.
Howard
February 15, 2005 at 3:21 pm
Thanks for the suggestions. I checked the logs and nothing unusual.
I finally restarted the server and everything came up okay. Still don't know what is causing this problem to occur...
February 15, 2005 at 9:20 am
Thanks to all for the excellent responses.
Howard
December 8, 2004 at 8:22 am
I came up with the following based on your example but I get an "Incorrect syntax near the keyword 'where'." message on line 4. Can you help me out with...
December 8, 2004 at 6:39 am
Viewing 15 posts - 106 through 120 (of 135 total)