Viewing 15 posts - 41,566 through 41,580 (of 49,562 total)
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
I'm guessing that the table in question is very small?
That's normal for a small table. Anything under about 1000 pages, you don't need to worry about fragmentation
January 20, 2009 at 4:53 am
Jeff Moden (1/19/2009)
GilaMonster (1/19/2009)
🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.
Maybe not...
January 20, 2009 at 1:28 am
Jack Corbett (1/19/2009)
My classic typo that gets past the spell checker is when I mess up "does not". Can anyone guess what my typo is?
I keep mixing 'or' and...
January 20, 2009 at 1:21 am
Jeff Moden (1/19/2009)
Jack Corbett (1/19/2009)
Here's a good blog post about people just implementing solutions form the internet or forums without caring why:http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html
I found this on a tweet by Jonathan Kehayias.
How...
January 19, 2009 at 3:37 pm
That'll happen any time an insert doesn't succeed (due to a constraint violation, a datatype conversion error or a trigger rollback) or when rows are deleted. The id will be...
January 19, 2009 at 10:02 am
shakir (1/19/2009)
Please give me detail solutions.....
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 19, 2009 at 9:39 am
Jason Manthei (1/19/2009)
Hello,I have 1 database on my server that the recovery model is automatically changing from full to simple making my transaction log backup routines fail.
SQL will not automatically...
January 19, 2009 at 9:38 am
krypto69 (1/19/2009)
Like this Gail?
Exactly.
Would you mind editing your earlier post to do the same? It's nothing to do with the data or values, it's just to prevent the large...
January 19, 2009 at 9:22 am
Sure. Have you looked in the articles section of this website?
You can read through this - Managing Transaction Logs[/url] and this http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
And if you're still unsure, ask.
January 19, 2009 at 8:27 am
Viewing 15 posts - 41,566 through 41,580 (of 49,562 total)