Thanks, but unfortunately we have over 800 DTS, they include data source/connections and most of them ActiveX VBScripts which use sa account and password (some DTS have up to 20...

I have a weird situation. On a network with 4 SQL servers, I was asked to prevent 3rd party from connecting to 3 of the SQL servers, they may only...

--Any chance of seeing that fine query... I'm getting ready to do something similar. Thanks.

--Jeff Moden.

Hi Jeff

I implemented smtp mail (SQL 2000) and dbmail (SQL 2005) a few months...

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

SQL 2000:

Go to Management, SQL Server Agent, Jobs, next to your job it will display Maintenance Plan name,

i.e. Transaction Log Backup Job...

CREATE TABLE Phone (

Phone_ID int IDENTITY(1,1) NOT NULL,

Contract_No int NOT NULL,

Make varchar(20) NULL,

Model_No int NULL,

Year smalldatetime NULL,

Warranty varchar(20) NULL,

User_ID varchar(10) NULL,

City varchar(20) NULL,

Status varchar(10) NULL

)

Query1:

SELECT Contract_No, Make, Model_No, Year

FROM Phone

WHERE...

Below are 2 reasons to truncate SQL Server log file/s (transaction log):

1.

Truncate log file/s if you have very little disk space left due to the SQL Server log file...

Hi Jeff, thanks for the thorough explanation.

I usually use execution plans to check for table scans, if I find a table scan relating to a table, the table normally does...

I normally use this method:

1. backup log Pubs with no_log

2. dbcc shrinkfile(Pubs_log, 100) -- shrink log file

3. dbcc updateusage(Pubs) ...

Hi Jeff, thanks for the excellent explanation, much appreciated. I prefer replies like these compared to the - ya perhaps, maybe, try this, depends.

Regards

Kevin

sonyt65@yahoo.com

What is the preferred option, with(nolock) or with(readpast).

What is the preferred option, if exists or if @@rowcount.

What is the preferred option, temporary table or derived table.

What is the preferred option,...

STEP1.

Create a local account (Local Users and Groups, Users). The right-click account, properties, select Member of tab, click Add, type in Administrators, click OK.

STEP2.

Start, Control Panel, Administrative Tools, Services, right-click...

Hi David

I had a similar issue. One connection was pointing to local server (using local server's sa logon account), the other connection was pointing to another server (using that server's...

If using 2 different accounts on 2 different servers, use Windows authentication in your SSIS Task connection manager for both connections.

Regards

Kevin