Viewing 15 posts - 496 through 510 (of 1,655 total)
rajganesh.dba (1/27/2009)
Is there any way to grant alter trace permission for SQL server 2000 box rather than giving sysadmin permission ?
No, the only option in SQL 2000 is sysadmin.
January 28, 2009 at 12:55 am
RBarryYoung (1/23/2009)
MarkusB (1/23/2009)
In SQL 2005 SP2 or higher you can also create a Login trigger to log the logon event into a table.
Why SP2? I thought that Login Triggers...
January 24, 2009 at 7:40 am
K. Brian Kelley (1/23/2009)
MarkusB (1/23/2009)
In SQL 2005 SP2 or higher you can also create a Login trigger to log the logon event into a table.
You can, but if something were...
January 23, 2009 at 7:40 am
If you use the STATS option in your restore script it will print out messages about how many percent have been restored. But you have to keep in mind that...
January 23, 2009 at 6:51 am
Did you try google "configure sql mail" ?
http://www.google.nl/search?hl=nl&q=configure+sql+mail&meta=
January 23, 2009 at 3:08 am
In SQL 2005 SP2 or higher you can also create a Login trigger to log the logon event into a table.
January 23, 2009 at 2:47 am
okiftequar (1/23/2009)
yes yes, i want to schedule SQL Server Native Backups.
There is no separate backup client if you want to use native SQL Server backup. It's part of SQL Server....
January 23, 2009 at 2:40 am
MANU (1/22/2009)
I think restoring back the system databases will do.Experts please comment.
MJ
That depends on what and when exactly the SP installation failed. Installing a SP will change the mssqlresource...
January 23, 2009 at 12:55 am
Obviously you have a corrupted msdb database. The best option is to restore msdb from a backup which was taken before the corruption occured.
If you don't have a good...
January 23, 2009 at 12:52 am
Gail, is right you should always post the error message in order for us to help.
But I also noticed that this is a MYSQL procedure, not SQL Server. So...
January 23, 2009 at 12:45 am
When it comes to replicating a mirrored database I don't think there is a lot of difference between 2005 and 2008. Transactional replication hasn't changed at all and mirroring too...
January 22, 2009 at 5:55 am
You can have SQLExpress 2005 and SSQL 2008 next to each other, in fact I have both of them on my own notebook.
The warning you got is about the...
January 22, 2009 at 5:12 am
First of all I think you will get better response if you post a 2005 question in the appropriate forum.
Now to your question. There are a couple od roles which...
January 21, 2009 at 3:32 am
jabba (1/20/2009)
Do you need a witness server in order to have an automatic failover process?
What sort...
January 20, 2009 at 8:43 am
Viewing 15 posts - 496 through 510 (of 1,655 total)