Grant Fritchey (1/14/2008)

---

I knew of the OUTPUT clause, but I'd only really thought of it for stuff like auditing. This is really useful. So, if you had a multi-row insert,...

you could use :

In your proc just set the dateranges (could use an available index (sargeble))

select ...

from yourobject

where mydatetimecol between @dateBegin

and @dateEnd

or

use the less performant ...

A user(id) can connect multiple times.

So indeed a user can block himself (if he has more than one connection)

There have been issues with parallelism where one SPID ( a single...

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