Viewing 15 posts - 211 through 225 (of 860 total)
Usually time out errors occur due to blocking and deadlocking issues.I would advise you to run a profiler trace with locking events and also turn on trace flag 1222...
April 12, 2009 at 8:26 am
1.) Verify that SQL Server service is running
2.) Verify the instance name
3.) Verify the log in
4.) Go to Surface Area Configuration manager and Enable Remote Connections
5.) Verify whether TCP/IP communication...
April 12, 2009 at 8:02 am
processf3ac58 with spid=77 has been asking for an update 'U' lock on resource with KEY 5:72057594071154688
processf925c8 with spid=81 has is asking for an update lock 'U' on the same resource...
April 11, 2009 at 8:02 am
Tony (4/10/2009)
Hi,Where I can find a list of all DMV's in SQL 2005 and, if possible,what they are used for?
Thank you,
T.
SQL 2005 ships with over 70 dmv's both documented...
April 11, 2009 at 7:48 am
madhu.arda (4/10/2009)
April 11, 2009 at 7:39 am
Grant Fritchey (4/10/2009)
I also know of a book that might help a bit. 😉
😀
I have got that too
April 10, 2009 at 5:39 am
Rowan (4/10/2009)
But just a quick question. I created a sql 2005 db as a test, and imported the two tables I use into this...
April 10, 2009 at 4:22 am
faiz_ku (4/9/2009)
April 10, 2009 at 4:18 am
sbvenkatesh77 (4/9/2009)
Can you please tell how to verify whether .Net framework work correct or not / corrupted.Bala
I am not so sure Bala, Sorry. I would google it a bit, its...
April 9, 2009 at 11:42 pm
Vivek (4/9/2009)
Indexes are not implemented in the database by the client so there are no indexes implemented on the database.
And how many rows your return!!?? Why doesn't your client implement...
April 9, 2009 at 11:27 pm
Vivek (4/9/2009)
My problem is this I have made an procedure which fetch data from a table which contain records in lakhs
that is 1,00,000 for everyone...
April 9, 2009 at 11:10 pm
iqtedar (4/9/2009)
can i say that truncation means only flushing the committed transactions
No, truncating tlogs means marking VLF's in the log files that they can be reused.
..so is it that truncation...
April 9, 2009 at 11:05 pm
vrabhadram (4/9/2009)
hi,suddenly sqlserver become slow, and the application is giving time out error.
what i need to consider regarding this.
thanks,
Do you see any locking/blocking issues on your server? You need to...
April 9, 2009 at 10:36 pm
Do you have anything else written on your application log about registry errors? Either you don't have enough permissions or the installation has changed. Are you logging in as...
April 9, 2009 at 10:23 pm
Are you accessing server through any we application? or are you directly trying to connect to the SSMS?
And also have you got required permissions?
April 9, 2009 at 9:42 pm
Viewing 15 posts - 211 through 225 (of 860 total)