Viewing 15 posts - 27,601 through 27,615 (of 39,803 total)
It sounds like it could be a communication error. Are you use that one server can connect to the other? Also, which version is this?
August 2, 2008 at 8:10 am
Please do no cross post.
Discussed here: http://www.sqlservercentral.com/Forums/Topic545595-146-1.aspx
August 2, 2008 at 8:09 am
You can look at sp_who2 and check the CPU time for xx length of queries.
August 1, 2008 at 12:38 pm
Up to you. I think you could script an FTP send, or add an SSIS package with the FTP task to send files, but it could easily flake out. If...
August 1, 2008 at 12:37 pm
You can attach these to a SQL Server instance (dev, express) and then look at them. It will rebuild the log files.
August 1, 2008 at 12:32 pm
Don't see a way to do it. I'll forward along.
Steve
August 1, 2008 at 12:31 pm
No that I know of. You can set auto-close on databases you suspect are not being used and they'll close and log a message in the error log if they...
August 1, 2008 at 12:23 pm
I've worked with data in both ways and I'd argue you've created a maintenance headache. Separating out data, restoring a customer, moving data if a customer needs their own server...
August 1, 2008 at 12:22 pm
If Table1 and Sproc1 are owned by the same person, you only grant EXECUTE and it will work. The permissions transfer.
Once you cross databases, the ownership doesn't necessarily transfer. You...
August 1, 2008 at 12:16 pm
Very interesting responses and quite a variety of opinions.
I have to say I think Andy Leonard has put it better than I did, Thanks Andy!
I think it comes down to...
August 1, 2008 at 10:13 am
We re-run older, popular articles at times. With nearly 200,000 people joining the site in the last year, it's not "old" to them, it's likely the first time they saw...
August 1, 2008 at 8:55 am
It depends, which isn't a great answer, but here's what I've done.
If I can afford the space, a weeks' worth of backups (full, diff, and logs).
Often space is an issue,...
July 31, 2008 at 12:57 pm
Viewing 15 posts - 27,601 through 27,615 (of 39,803 total)