I am very thankful to Microsoft for making SQL Server so simple to use. This allowed me to move from installing Windows NT software to being a SQL programmer/DBA....

We have many DTS packages that used to have known failures in them. Some of them still have on failure sections because we still want certain tasks to be...

I would copy all your database files to a separate folder (the ones with .mdf and .ldf) and make backups of all your databases and then complete the install as...

A solution we have used to reduce dead locks is to use the join hint WITH (NOLOCK). We place this after each table name in a SELECT statement. ...

That is how I see it. The hash join took longer to run than the inner join. I ran both queries in the same query window and both...

I think the only way to do this is to build it dynamically in a variable and then execute the SQL in the variable. Something like this:

DECLARE @p int,...

There are a lot of things to consider before attempting replication between these servers. First is the number of changes that occur each day. With that slow of...

I created the following tables:

CREATE TABLE [dbo].[test] (

[col1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,

[col2] [int] NULL ,

[col3] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,

[col4] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AI NULL

) ON...

I created a table called ContSupp with the column accountno and recttype and filled in some data and then executed your code as is and it worked. Something else...

Another way is to schedule the DTS package and then execute the following system stored procedure in your stored procedure:

sp_start_job

Robert Marda

As far as I can tell you can't declare a variable in a view.

Also you can't execute a query like this:

Select * from @TableName

To do something like the above you...

And of course, right after I replied our Systems Engineer resoved the problem.

When the terminal server is running in application mode there are certain foldres/files that must be made available...

Thanks to everyone who gave me advice on how to resolve this problem. We have either discovered why the problem occured or simply avoided the problem.

We set up another...

A simple type of auditing using triggers is described in the following article:

http://www.sqlservercentral.com/columnists/rmarda/auditingtriggers.asp

This should at least give you an idea of how to create the triggers you want.

Robert Marda

I guess I'm among the group that does this the wrong way. I almost always code first. I seldom write psuedo-code. I always have a list of...