Silverfox

Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,136 total)

RE: Rebuilding of indexes

Trooper (9/9/2009)
I have a maintenance plan which takes the db in to simple recovery model , rebuild the indexes , and then get it back to full recovery model.
The step...
--------------------------------------------------------------------------------------
[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 9, 2009 at 8:27 am

#1051155
RE: test

Wayne (9/9/2009)
test for the first post
This is the test reply 😛
--------------------------------------------------------------------------------------
[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 9, 2009 at 8:11 am

#1051141
RE: Table listing for SSIS Package

jfn (9/9/2009)
I am looking for the means to list out the tables in the SSIS packages I have. I can find the tables on the system but do not know...
--------------------------------------------------------------------------------------
[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 9, 2009 at 8:11 am

#1051139
RE: decomissioning of servers

ramyours2003 (9/9/2009)
as a dba's job r they decomissioning the server , if yes explain the steps for decomission the server and what are the preventive steps need to be...
--------------------------------------------------------------------------------------
[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 9, 2009 at 8:08 am

#1051137
RE: Am I the only DBA

Jeff Moden (9/8/2009)
Silverfox (9/8/2009)
Roy Ernest (9/8/2009)
Hey Fox, That was a low blow...:hehe:
😛 Go jeff 😛
It's ok... you can stand up now. 😉
Do I have to, I was very comfy lying...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:59 am

#1051127
RE: Install sqlserver-2008 Enterprise Evaluation

sounds like you dont have full permissions to do the install.
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:49 am

#1051116
RE: Permisison for taking DB on and offline

J.D. Gonzalez (9/9/2009)
Thanks for the query. Exactly what I needed.
Turns out the login in question was set at the owner of the DB. It seems that by giving...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:42 am

#1051107
RE: jobs

ramyours2003 (9/9/2009)
what are the different jobs created by sql server and explain its importance ?
that is too generalised a question, if you can be more specific...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:40 am

#1051103
RE: ODBC Connectivity problem

mattaustin (9/9/2009)
Hi All,
We're having a problem with an upgrade from SQL Server 200 to 2005 that hopefully someone can offer some advice with?
Our 3rd party software connects to the database...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:32 am

#1051093
RE: Security from front end

Tara (9/9/2009)
I have a script which i want to run from the same stored procedure which locks some tables in the database which contians sensitive data.
Can you let me know...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:26 am

#1051083
RE: Connection error - see message in description

paucann (9/8/2009)
Hi,
I'm writing a web service to be consumed by a Silverlight proj.
I'm getting the error above even though I can connect to the server and database through SQL Server...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:24 am

#1051077
RE: Not Installing BOL

Amit Singh (9/9/2009)
Has anybody seen or practices the concept of NOT installing Books Online on production servers ? I have always installed books online on production servers and have found...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:22 am

#1051071
RE: not connecting to sql server from application server

runaldo (9/9/2009)
1) When installing named instances a random portnumber is applied (Dynamic port).
2) When accessing try with creating an odbc. On large networks telnet is often denied.
3) If you...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:12 am

#1051057
RE: Missing data file

Indianrock (9/9/2009)
Systems reactivated the LUN and the drive letter to it. But since the ndf file was in the root of that instead of in the correct subfolder, the...
--------------------------------------------------------------------------------------
[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 9, 2009 at 7:05 am

#1051048
RE: Create Sql Job

on another note, if you want it to work only on a working week.
change it to weekly and just select the days that you want it to run on.
--------------------------------------------------------------------------------------
[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 9, 2009 at 5:37 am

#1050998

Viewing 15 posts - 856 through 870 (of 1,136 total)