Viewing 15 posts - 2,536 through 2,550 (of 6,105 total)
Sounds like you all need to coordinate your backups. Basically, there should be one backup strategy coming out of SQL Server, regardless of writing to disk or tape. Seems like...
December 20, 2005 at 8:36 am
When you check the application and system event log for the server, do you see any error messages about not being able to contact a domain controller, just in general?...
December 20, 2005 at 8:32 am
Is the certificate installed for SQL Server now expired? How about the certificate for the CA that issued that certificate?
December 20, 2005 at 8:30 am
Yes. In the case of an INSERT, just look to use the inserted tablespace. In the case of a DELETE, use deleted. When you're firing a trigger on an UPDATE,...
December 20, 2005 at 8:24 am
1) If your user account which is running xp_cmdshell is a member of the sysadmin fixed server role, has the SQL Server service account changed recently?
2) If it isn't, is...
December 20, 2005 at 8:22 am
I'll check out both Sharpreader and RSSBandit. As for Sage within Firefox, tried it and wasn't all that satisfied. I'm using Wizz RSS right now and while I like it...
December 20, 2005 at 7:51 am
Yes, it is possible. Here is a KB article which describes how to use replication with MSDE:
How to use replication with SQL Server 2000 Desktop Engine...
December 20, 2005 at 7:47 am
You can take one of two approaches.
One, you can put triggers on key tables where you want to monitor data changes. This is the most intrusive, but the cheapest, option.
Two,...
December 20, 2005 at 7:40 am
When you're logged on through Enterprise Manager or Query Analyzer, do you see the same behavior with respect to your connection in SQL Profiler?
December 20, 2005 at 7:38 am
Look at creating a server side trace using the SQL Server stored procedures and functions. This will run and can write to a trace file on the server without ever...
December 20, 2005 at 7:35 am
I haven't seen a hotfix announcement for this. It would probably take someone within Microsoft or privy to development within Microsoft to comment on whether or not one is planned....
December 20, 2005 at 7:32 am
It depends. MSDB also contains SQL Server Agent job information as well as any DTS packages not stored n the file system. So you may need to restore msdb if...
December 20, 2005 at 7:26 am
Shas3,
A long time ago, in a galaxy not so far away, Robert Marda experimented with triggers on system tables and posted the results in these very forums. His results showed...
December 20, 2005 at 7:22 am
GRANT = User or role has been explicitly given access.
DENY = User or role has been explicitly denied access. This trumps any GRANT.
REVOKE = This is the "undo." It will...
December 20, 2005 at 7:15 am
Basically it's all about a manual process to move log backups and get them applied. Here's one such article from back in the SQL Server 7 days (the core concepts...
December 19, 2005 at 12:07 pm
Viewing 15 posts - 2,536 through 2,550 (of 6,105 total)