Viewing 15 posts - 376 through 390 (of 629 total)
I am not sure how you are going to do this in VB; but make sure the VB script sets the property using the SQL Server Configuration Manager (SSCM) and...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 8:47 am
You can use linked servers to poll information from all the servers.
Create you new CentralJobHistory table on server of your choice. (S1)
Create a new login on each of the instances...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 8:34 am
I haven't used MySQL for so long I can't even remeber that ... thanks! I'll have to tell them next time LOL ... the biggest reason everyone gives me...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 7:45 am
I don't think you are going to find a easy answer...
Look at following:
http://www.microsoft.com/sqlserver/2005/en/us/overview.aspx
http://www.microsoft.com/sqlserver/2005/en/us/features.aspx
http://www.microsoft.com/sqlserver/2005/en/us/technologies.aspx
and write something up .. but I don't think you can buy 2005 any more.. (I might be...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 12:16 am
Here are a list of issues fixed in 2000 SP4...
http://support.microsoft.com/kb/888799
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 12:10 am
I am taking a guess it is an Active Directory group... So in Active Directory remove that person from the group and they will not be able to access it...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 17, 2009 at 12:09 am
What are you trying to do Raj? See what is in the Inserted table in for the trigger?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 11:55 pm
Urg .. Not a long rant but why do people have in their mind SQL Server backup is not online?
Everyone at my work seems to think that to, I have...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 11:30 pm
Actually I am at 80 databases LOL; urg.. I forgot stuff heh. And we are running high-avaliablity mode. If you like log shipping you should love mirroring too,...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 5:05 pm
george sibbald (3/16/2009)
thats rather a lot for mirroring. Doable with log shipping though.
I have over 30-40 databases running on my SQL Server 2005 server with no issues; have you seen...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 3:32 pm
homebrew01 (3/16/2009)
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 2:10 pm
Yeap :). SQL Server uses local groups to grant permissions so most of them are there. If you change the service account the tool adds the new service...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 8:43 am
Hey ..
Your query is correct for selecting text but that text must be parsed properly to mean anything please look at the query below:
[font="Courier New"] SELECT deqs.last_execution_time AS [Time],
SUBSTRING(dest.TEXT,
(deqs.statement_start_offset/2)+1,((CASE deqs.statement_end_offset...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 1:00 am
Could you list the output of the DMV here please for the given table?
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 15, 2009 at 10:28 pm
I recommend to learn this you play with clustering over virtual environment 🙂
Have a read: http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 15, 2009 at 3:02 pm
Viewing 15 posts - 376 through 390 (of 629 total)