Viewing 15 posts - 3,526 through 3,540 (of 3,666 total)
Is the "Z" drive on the server or is it a mapped drive on another machine?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 16, 2009 at 1:19 pm
If I'm not mistaken, a friend of mine ran into the same problem.
After search the internet, I believe he found out that this is caused by a BUG.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 16, 2009 at 8:42 am
If the table have keys that uniquely identify the rows then you do not need to use row by row logic.
Run a query that returns a list of rows that...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 15, 2009 at 7:56 am
Can't you use the REPLACE function when specifying that field to replace spaces with nothing?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 18, 2008 at 9:57 am
Connect as? Oh I hate and love that. Hate that I have to use it but love that it is available.
If you running the DTS manually, you...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 18, 2008 at 9:55 am
There are numerous reasons why you may be getting that error. I'm not an expert on network security so I'm going to stay clear of that one.
One option that...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 18, 2008 at 9:33 am
My thought is to go for the SQL 2005 first then you can try the upgrade exam to 2008.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 9, 2008 at 10:41 am
After reading:
"Returns the current database system timestamp as a datetime value without the database time zone offset."
I thought there would be a difference, because of the reference to the...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 9, 2008 at 9:06 am
Which one should you use?
Simple, look at both values and you'll see the difference. I guess the correct answer to your questions is that it depends what you want...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 9, 2008 at 8:46 am
It was so easy that I went to the trouble of looking it up to be sure it wasn't a trick.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 4, 2008 at 9:19 am
Irish Flyer, 1434 is not a default for SQL 2000.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 3, 2008 at 7:44 am
I don't know the answer to your problem but it does remind me of setting up the import of a few files using SSIS.
I hope they add the ability to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 18, 2008 at 9:16 am
try: convert(char(8), DateField, 112)
replace DateField with the field that holds the date.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 17, 2008 at 9:24 am
I think you have to approach this issue from 2 side.
#1 - I agree with the previous post about training. With the training should come a clear...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 17, 2008 at 8:46 am
I'd be tempted to start with correcting the compatibility level, then re-indexing, one index at a time. It has the potential for immediate payback.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 14, 2008 at 10:06 am
Viewing 15 posts - 3,526 through 3,540 (of 3,666 total)