on the other hand,

if you use identity in your column definition, sqlserver will generate the next number for you.

And with sql2005 you could just add

OUTPUT [yourIDcolumn]

to your statement...

I'd first of all suspect the way the proc's parameters are defined in the vb.net app.

( http://www.sqlservercentral.com/scripts/Miscellaneous/31639/ )

Avoid implicit conversions !

Interesting indeed.

Did I mention we change sa-password at all servers at least every month (and most of the time the new one is a guid).

Yes we do.

All dba / sysadmins connect...

Thanks for the feedback.

I'm glad you've found the reason.

That would be nice 😀

Strange indeed.

Can find any traces of fillfactor if you script the db at sql2005 side ?

Which fillfactor did you specify ?

If it was the default value (80), maybe that's the...

maybe you can investigate the 'old' sp_processmail, but keep in mind MS anounced it to be removed in futer versions.

Or maybe write your own vb.net or vbs application to...

Regarding Week ...

Keep in mind MS starts week 1 on january 01.

Maybe that's not the weeknumber your company uses.

In my case week 01 is the week containing january 04 !

We...

If you alter the service account using "SQL Server Configuration Manager" it sets the needed rights for you.

Check "Service Account" in books online.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/7f123fdd-95a6-4455-97a9-74d15f08144c.htm

A db-level security admin ( member of db_securityadmin db-group) can only grant db acces to logins that are allready being granted connect at server level (by server securityadmin or sysadmin).

--...

I've just received this article and thought it might also help you :

http://www.mssqltips.com/tip.asp?tip=1397

just a little remark:

If you post ddl with objects using UDT's, also post the UDT's ddl.

as allready stated, you just join all rows of both tables without a filter....

were they security admins at sql2000 side ?

if yes, add them to the serverlevel security admins group.

I don't have the answer to your question, but maybe you've choosen the wrong object to server your data need.

Why did you choose a clr-object ?

Why did you choose a...