quote:

---

DECLARE @sql varchar(200)

CREATE TABLE #t(db sysname, own sysname, tab sysname, Col sysname, Seq tinyint, PKName sysname)

SET @sql = PARSENAME(@table,3) + '.'...

I would run the lon running process as a JOB then when call returns from start_job the query to that progress table can be done periodically.

How about:

 

exec master..xp_logininfo N'DomainName\Group', N'members'

Note: The Group Have to Have Access To SQL Server though

have a look at IS_MEMBER

This may help you:

http://www.sqlservercentral.com/faq/viewfaqanswer.asp?faqid=202

case CAN be used in:

- SELECT List

- Join Conditions

- ORDER BY

- GROUP BY

- WHERE

- Some String Handling expressions

Clauses but

not on the FROM part

any time you get EXCEPTION_ACCESS_VIOLATION it is either because the OS is in an unstable condition or a bug on SQL Server.

I would suggest a reboot and try to figure...

I would use the First option with a "Numbers" table if you join that with your history the non row moth will came as Null and as you can see...

Thanks,

I have learned from this one too 😉

Happy thanks giving to you too!!