Viewing 15 posts - 2,536 through 2,550 (of 6,104 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...
K. Brian Kelley
@kbriankelley
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?...
K. Brian Kelley
@kbriankelley
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?
K. Brian Kelley
@kbriankelley
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,...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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,...
K. Brian Kelley
@kbriankelley
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?
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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....
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
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...
K. Brian Kelley
@kbriankelley
December 19, 2005 at 12:07 pm
Viewing 15 posts - 2,536 through 2,550 (of 6,104 total)