I've never seen this before. As far as I know % is just the wild card character in SQL Server. Are you sure this is SQL Server code?

Based on the limited information you have provided (no ddl or code), it is hard to answer this question. I would venture to say that you have something in...

Glad I could be of help. Sometimes it just takes another perspective.

You'd probably be better off posting this on web development forum instead of SQL Server as this really applies to asp or asp.net.

In asp, I'd recommend using vbscript and ado.

Is g a local drive or a mapped drive? I have had problems backing up larger db's across a network and this not recommended anyway.

From BOL entry on sp_addlinkedserver:

Grant ALTER ANY LINKED SERVER to login_name

What process is doing the insert? If you control the code doing the insert I would recommend creating the XML document within the application code, not in SQL Server.

It...

Are you saying you want to actually store the video's within the database or just the path?

I'd suggest 2005, or if you really want to store the video in the...

My goal wasn't to steer you away from using Identity, just from trying to fill in gaps.

Anyway I'd use SSMS to make the change. Just open the...

Based on what I have learned you don't appear to be doing anything wrong in your connection string.

Have you tried putting the connection code in a Try Catch...

There is no way around this that I am aware of. It is the way Identity works

Maybe some code...

If you attempt an insert into a table with an identity column and the insert fails the identity value is incremented. That's because the identity value is incremented BEFORE...

Start with the query, but if the query returns all rows from a join of several tables you will probably have to bump out hte timeout value. Returning all...

I like tabs and I use 6 and I like to set it to 6 even if I change set it to use spaces. One of those personal things.

I think it is reads and writes, but like...