Viewing 15 posts - 27,346 through 27,360 (of 39,769 total)
You want to be sure the SQL Server is running OK, not sure if the Resource database causes issues with Sharepoint, but there is some integration with Sharepoint.
Worst case, put...
August 18, 2008 at 11:12 am
That's a good list and gets you most of the way there. I'd add some good T-SQL knowledge for writing reports. Seems like those come up constantly and there are...
August 18, 2008 at 10:22 am
Nope, SQL monitors SQL.
There are some file system solutions, but there really isn't a good way to do this and make it available to the security folks. Maybe set permissions...
August 18, 2008 at 10:01 am
Troy, that sounds great, but now you get the great view of the Rockies! Not sure which one I prefer.
August 18, 2008 at 9:45 am
The kids do get loud. Last summer, when we had them home part of the summer, it was hard to work. Ended up working at night a lot when they...
August 18, 2008 at 9:15 am
Why would you worry about productivity at home v the office? Plenty of people gab, goof off, walk around at the office and don't get things done.
You measure results. I...
August 18, 2008 at 8:02 am
I'd run profiler at this time and figure out exactly what is being run. Then you can make a plan to work with it.
August 18, 2008 at 7:43 am
No, the file itself has a timestamp, but that changes regularly. Changes to tables aren't tracked.
You could set up a datetime mark in each table and have it updated with...
August 18, 2008 at 7:42 am
Virtual PC is free, I'd recommend running it in a VM to be safe. The RTM is probably fine, but you don't want to create issues with your current environment.
August 18, 2008 at 7:41 am
Did you check the names of the files in sysfiles? Or in the database properties?
August 18, 2008 at 7:38 am
Not sure what you got here, but questions of the day are built 3-4 weeks ahead of time. Perhaps you saw the question early or it's a coincidence.
In any case,...
August 18, 2008 at 7:37 am
Please don't cross post.
Answer here: http://www.sqlservercentral.com/Forums/Topic554245-147-1.aspx
August 18, 2008 at 7:33 am
I don't like the idea of CLR code, but there have been a few people that have found it quite handy. I tend to side with those above and I'd...
August 18, 2008 at 7:31 am
Corruption errors are almost always hardware related, so I'd get the hardware checked.
You can try dropping and rebuilding the affected index, however that doesn't necessarily address the underlying cause.
REPAIR_DATA_LOSS should...
August 18, 2008 at 7:30 am
Viewing 15 posts - 27,346 through 27,360 (of 39,769 total)