Viewing 15 posts - 496 through 510 (of 1,654 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.
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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=
[font="Verdana"]Markus Bohse[/font]
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.
[font="Verdana"]Markus Bohse[/font]
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....
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
January 22, 2009 at 5:55 am
Check out this article:
[font="Verdana"]Markus Bohse[/font]
January 22, 2009 at 5:18 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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
January 20, 2009 at 8:43 am
Viewing 15 posts - 496 through 510 (of 1,654 total)