Viewing 15 posts - 6,241 through 6,255 (of 9,725 total)
I've just opened up a new connect issue with the details of the SQLAgent.Out.
EDIT: OS is Vista Business 32 bit.
Here's what I've posted:
"2011-03-18 13:34:41 - ! [298] SQLServer Error: 65535,...
March 23, 2011 at 7:56 am
Gah. This is seriously annoying. Neither Repair nor an uninstall / reinstall fixed the issue.
Any more thoughts?
March 23, 2011 at 7:38 am
Kokila, thanks for the advice, but as stated above, the service account is running under full Sysadmin permissions (which would be a complete no-no if I were running this on...
March 23, 2011 at 5:25 am
I've never even heard of anyone executing a query plan before. Just a query.
Are you trying to execute a query with a specific query execution plan instead of letting...
March 23, 2011 at 5:24 am
Add your data type sizes (per row) and multiple by the number of rows in each table. This will get you the uncompressed size.
Don't forget to add the overhead...
March 23, 2011 at 5:21 am
Self-study has always worked best for me as I tend to forget class-taught items a week after the class unless I actually practice them.
Getting books and working through the exercises...
March 23, 2011 at 5:20 am
GilaMonster (3/23/2011)
Brandie Tarvin (3/23/2011)
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.Hee. I am so evil. @=)
I want cookies too, and I love that analogy.
Still bad info...
March 23, 2011 at 5:18 am
What Gail said.
Re-read the cookie analogy.
March 23, 2011 at 5:15 am
Can you believe I still have my SQL 2000 System Tables Map? @=)
You can get user / login information from the following tables:
sysremotelogins (to verify linked servers, etc.)
syslogins (gets login...
March 23, 2011 at 5:13 am
Well, progress didn't help me much. There's still not a whole lot out there. But I'm attempting to repair the install to see if that works.
If not, I guess I'm...
March 23, 2011 at 5:04 am
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.
Hee. I am so evil. @=)
March 23, 2011 at 5:00 am
You're welcome. I hope the analogy made things easier to understand for you.
March 22, 2011 at 12:43 pm
Sachin Nandanwar (3/22/2011)
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction...
March 22, 2011 at 12:34 pm
Sachin Nandanwar (3/22/2011)
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
So when a checkpoint...
March 22, 2011 at 12:17 pm
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
Hence the reason, Sachin, why I...
March 22, 2011 at 11:54 am
Viewing 15 posts - 6,241 through 6,255 (of 9,725 total)