Check out this link http://www.connectionstrings.com/sql-server-2005

It's possible that the username keyword in your connection string is invalid, and SQL Server is therefore defaulting to a trusted connection.

I couldn't give you the exact string, but using a Regular Expression in the find and replace should get you over the issues of white space/CRLF characters etc. Still not...

The error message would indicate that you are connecting using a trusted connection, not a SQL logon. Can you post the connection string the application is using?

Can you login with...

This sounds very much like the issue SQL Server 2000 had with not reclaiming space for tables with text/image columns.

The only solution I found to that problem was to add...

First of all, why are you writing a dynamic procedure for this?

The standard INSERT statement allows for nulls anyway, so the procedure could just be a single line:-

INSERT AccountAO_Receive...

You are correct in your assumption that SQL Server is doing what it should.

Have a look at this link http://msdn.microsoft.com/en-us/library/ms175464.aspx

Just under the first diagram, you will find the explanation you...

There is a way to do this without downtime for SQL Server.

1. Backup the master database

2. Restore the backup file as a differently named database

3. Detach this database

You now have...

A bit less risky, but could still suffer from similar problems to @@NESTLEVEL if the trigger is ultimately fired as a result of...

I think Steve was trying to tell you that the BEGIN TRANSACTION is not necessary at all. Once you are inside the trigger, you are automatically inside a transaction anyway.

I'm...

I assume the integer should represent the number of seconds since midnight. There may be more elegant ways, but this should do it:-

SELECT DATEDIFF(S, CONVERT(DATETIME,CONVERT(CHAR(11),GETDATE())), GETDATE())

All the Is_For_Replication setting does is to tell SQL Server that, if the update to the table has come via replication, then it should carry out the constraint checking just...

Sounds a bit risky to me... what if another row...

What is your definition of a working day? Does this exclude public holidays as well as weekends?

If so, a date table will be the simplest solution, keyed on date, specifying...

What makes you say this?

Having an identity...

It returns 70 because of this... declare @txt_value nvarchar(100)

You have declared your variable as nvarchar, which is unicode, and uses up 2 bytes of storage for every character in the...