Silverfox

Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,136 total)

RE: need to restart after installing SQL Server SP3..............

Steve Jones - Editor (9/4/2009)
You can shutdown SQL Server from within SSMS using SHUTDOWN as a T-SQL command. (http://msdn.microsoft.com/en-us/library/ms188767.aspx)
I almost never restart my servers from the command prompt. The GUI...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 9:27 am

#1049464
RE: Database Design & Professional Responsibility

I hope you are right, let us know. I would be interested to know if noone else.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 9:25 am

#1049463
RE: Are the posted questions getting worse?

GilaMonster (9/4/2009)
Jeff Moden (9/3/2009)
He was probably using sp_Space used or some code that looks at sysIndexes and DBCC UPDATEUSAGE fixes some sins that occur there.
The code he initially posted (before...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 8:45 am

#1049438
RE: Application user

prsnn_shetty (9/3/2009)
Hi,
Is there any way through which the user created for application
or SSIS package to be restricted login through query analyser.
Regards
Prasanna.
tell me...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 8:30 am

#1049424
RE: db_datareader role

your question does not make sense, probably the reason noone has replied to you. can you explain again what you need help with?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 8:26 am

#1049420
RE: Password Vulnerability in SQL 2005 and 2000

The thing is, it is not only the dba's that can have sysadmin access on a box, that is something that has not been mentioned. Windows administrators and even management,...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 8:18 am

#1049409
RE: Problems in installing SSIS in cluster environment

This might help as well.
Take a look at the SQL Server 2008 Failover Clustering whitepaper.
http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:50 am

#1049375
RE: Problems in installing SSIS in cluster environment

Sumanta Roy (9/4/2009)
Hi,
I am facing the below problem in installing integration services in sql server 2008.
I have a 2-node Windows 2003/SQL 2008 cluster with multiple instances, and I
want...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:46 am

#1049371
RE: need to restart after installing SQL Server SP3..............

espanolanthony (9/4/2009)
Hello friends, I have windows server 2003, and I have installed SP3 for SQL Server 2005. Now since i did not stop some of the services i need to...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:43 am

#1049366
RE: Creating Logins

Mohan Kumar (9/4/2009)
Hi
I'm trying to create a sql server login with limited permissions as follows:
1. Database1 - tables read only.
2. Database2 - GRANT Select / Insert / Delete data
3....
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:35 am

#1049356
RE: MSDB suspect... cant do anything

Chances are that it is a disk issue and that you were unlucky.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:27 am

#1049351
RE: query analizer issue

sivark1 (9/4/2009)
Thanks for replying
pls clarify this dought
is it possible to UN install only client components
if possible what r the precautions to take care before uninstalling
If i install client...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 7:25 am

#1049349
RE: Password Vulnerability in SQL 2005 and 2000

I think that you have to think about how this can be exploited and what people tend to forget.
Yes, it can only be exploited by administrators and people tend to...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 5:34 am

#1049305
RE: query analizer issue

sivark1 (9/4/2009)
Thank u verymuch for quick reply
if .exe file corrupts then my doughts is can we repair/install only query analyzer components
if you try and run query analyser through windows...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 5:05 am

#1049299
RE: Do you consider yourself a Senior DBA

GSquared (8/26/2009)
Titles are like certs and degrees. Some people have them because they reflect a degree of skill, knowledge, experience and wisdom. Some people have them because they...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 4, 2009 at 5:02 am

#1049297

Viewing 15 posts - 961 through 975 (of 1,136 total)