Viewing 15 posts - 41,566 through 41,580 (of 49,571 total)
Is the database you're running it from in compat mode 90? If, say, you're running it from master and using 3-part names to refer to the proc, then it will...
January 20, 2009 at 1:23 pm
homebrew01 (1/20/2009)
But, if they were critical, what would be the best method to recover ?
Restore the backup. The preferred solution to any such form of disaster is to...
January 20, 2009 at 1:19 pm
Andrew Gothard (1/20/2009)
Well, that depends largely on the attitude of the OP, Gail.
What does? The solution to exact specs or the advice about driving off a cliff? Or something else?
January 20, 2009 at 1:16 pm
Can you please load up management studio or query analyser and test the query out there.
January 20, 2009 at 1:12 pm
Chris Harshman (1/20/2009)
January 20, 2009 at 1:10 pm
S Hodkinson (1/20/2009)
I shall leave the developer to the attentions of senior management.
😀
January 20, 2009 at 6:56 am
pat (1/19/2009)
it is only numbers and integer it does not contains text!!numbers from 1 to atleast 55000
Thanks
Jeff's not asking about the col1 column. Are there any other columns in the...
January 20, 2009 at 6:30 am
Check the permissions on the file. Sometimes when you detach a database file, it looses all permissions. No idea why. Take ownership and then add permissions for the administrators back.
If...
January 20, 2009 at 6:25 am
You forgot one. http://www.sqlskills.com/blogs/paul/
January 20, 2009 at 6:12 am
tevers (1/19/2009)
So that's how outsourcing works!! The project goes to India and someone posts it as a question and then sends the answer back.
:hehe: 😀 :w00t:
Thanks. That...
January 20, 2009 at 6:10 am
Load it up in management studio or query analyser. You can't debug SQL properly from a web application
My guess, and this is just a guess, is that the variable you're...
January 20, 2009 at 5:35 am
mathewspsimon (1/20/2009)
Hi Gail,I am not too sure how I can do that.
How you can do what?
Only thing I see is it give the first part of the sql which shows...
January 20, 2009 at 5:28 am
What, specifically, are you looking for?
If you want info on the storage engine, Inside SQL Server 2005: The Storage Engine is full of information. There's some stuff on the query...
January 20, 2009 at 5:25 am
mathewspsimon (1/20/2009)
But this gives error.
And the error it gives would be ... ?
If it's a syntax error, print the string before you try to execute it. It's usually easy to...
January 20, 2009 at 4:58 am
Can you try logging on the the machine with an account that's a windows administrator, then try to connect to SQL with windows authentication. Providing this is not on Vista/Server...
January 20, 2009 at 4:55 am
Viewing 15 posts - 41,566 through 41,580 (of 49,571 total)