This is a quote from the isolation link I sent about Read-Committed Isolation:

In SQL Server 2005, you can also minimize locking contention while protecting transactions from dirty reads of uncommitted...

If you mdf is growing large, it is because there is lots of data being inserted. You have confirmed that the growth is set to 1mb unrestricted. This...

The developers have to make the change. You do not, unless you are also developing the application. Have them change the config file to connect using the login...

What programming language is the web developed in ASP.NET? The developers have to connect to the database via a connection string. For .NET applications the connection information is...

Andras,

Cool solution, I did not even know about this feature. It seems like managing objects with synonyms can become confusing and messy, if you do not know that the...

No, problem. I am glad everything worked out.

Happy holidays.

To the best of my knowledge this cannot be done without dynamic T-SQL. I would love for someone to prove me wrong though 😉

tthomas,

sorry about that I left some extra ")" in the last few case statements. Change

CASE WHEN visit_type = 1 THEN

visitor_id

END))

TO

CASE WHEN visit_type = 1...

Go the SQL configuration manager. Confirm that SQL Server and SQL Server Browser are running. From here you can also click on the Network configuration tab and enable...

SELECT

LEFT(

RIGHT(PK,Len(PK) - charindex('=',PK)),

LEN(RIGHT(PK,Len(PK) - charindex('=',PK)))

-1)

hmm. Jeff it looks like you beat me to the punch.

It's based off the same principal but is much more simplistic. 😉

This should do the trick.

SELECT

SUBSTRING(

CONVERT(varchar,

CAST(COUNT(DISTINCT

CASE WHEN visit_type = 0 THEN

visitor_id

END) AS money),1

...

It is difficult to determine the exact cause for the dead lock without knowing the data that is being passed in.

I have created a small scale sample with...

I have not had any luck with the varbinary bcp, so the way I see it you have two options:

1) If you choose to use file paths in the database,...

I have created a sample image and recieved the same error as you. I did notice that the binary is different between the bcp output image and the original. ...