None that I am aware of but simple mode is designed to keep the transaction log for all logged transactions until a backup that will truncate the log is performed....

Sorry, I now have an example based on what you are doing. Try this

CREATE PROCEDURE usp_InsertAnswersAboutThem

@TableName varchar(100),

@ColumnName varchar(100),

@MemberID int,

@AnswerID int

AS

DECLARE @FindMember nvarchar (2000)

DECLARE @FindAnswer nvarchar...

That would be correct as if any one of the subqueires where clause is not met no value is returned therefore it gives you null. Do the ISNULL on the...

It will be because of these two lines.

IF (SELECT @Findmember) > 0

IF (SELECT @FindAnswer) > 0

You will need to use sp_executesql with an output variable to get the values of...

Use a case statement in your query

CASE ColEnd WHEN '12/30/5000' THEN '' ELSE CONVERT(VARCHAR,ColEnd,101) END AS ColEnd

Then if the values is 12/30/5000 you will see nothing otherwise the date outputs.

"Don't...

I would try reinstalling just the client utilities instead of whole server first.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

We do this will an Oracle database. What we do is in our our DTS package we define the Oracle side with a query to qurery the last modified date...

The information is stored in syslogins or sysusers (sorry no SQL Server here to double check). You can query the [name] column for the user ot the [id] column if...

I do it but generally for things I don't want people to know are there which are for me maintainence items. I have done for a few sp's that are...

First the teamed NICs should not be the cause as it should just be a total packet processing thing, connection should not open multiple times. Now as for closing I...

The key to output a single quote is put two single quotes in the input such as ' would be submitted as '''' and '' single quotes submitted as ''''''.

"Don't...

It is not based on xtype but instead status column. When you use sp_MSmarksystem to make the table a system table you will find the only column updated is status...

You can also export the data from sysdtspackages and import to the other. Or you can do a backup and restore to another name (like tmpRestore) then insert to the...

To the best of my knowledge, if they used sp_MSmarksystem to make it a system table or altering the status of the table in the sysobjects table will be an...

INSERT is a better option as opposed to SELECT INTO which does have known locking issues. Now as for your answer it would help to see you current code logic...