If all 300 of those logins are AD, then why do you want 300 matching SQL logins?

Add those logins to a domain group, grant the domain group login rights on...

Just be aware that multi-statement table valued functions tend to perform less then admirably, especially if they'll be returning lots of rows.

Is there an entry in the 'blocked by' column? Is there a last wait type?

Please don't cross post. It just wastes people's time and fragments replies

No replies to this thread please, direct replies to:

http://www.sqlservercentral.com/Forums/Topic568224-146-1.aspx

Run the sp both ways with the execution plan on. See if there's a big difference in the inner proc's exec plan. You could also use Statistics IO and Statistics...

Matt Miller (9/11/2008)

---

a table variable doesn't accumulate statistics like a regular table does. So - the joining back process is likely using an assumed number of rows on...

Two options.

1) Detach the database, move the files, reattach the database.

2) Run an ALTER DATABASE and specify the WITH MOVE clause, take the database offline, move the files, bring the...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic568300-146-1.aspx

Please post SQL 2005 questions in the SQL 2005 forums. If you post in SQL 2000 forums, we're going to assume the question has soemthing to do with SQL 2000.

How...

Define 'doesn't seem to be working' please.

Throws an error?

Gives unexpected results?

Spawns a black hole?

Anything in the error log?

It's not stored anywhere in SQL. It's in the registry.

I can't remember offhand where, easiest way to find where is to run profiler and filter the trace based on your...

Does this work?

-- first, some setup.

CREATE TABLE #Amounts (

SomeDate DATETIME,

SomeAmount INT

)

insert into #Amounts values ('2008/09/01',500)

insert into #Amounts values ('2008/09/02',1500)

insert into #Amounts values ('2008/09/03',3500)

-- Setup finished

CREATE TABLE #WorkTable (

RowID...

I believe it shows the result of the last fetch operation that occurred.

Are you sure nested cursors are required? Want to post the gode here and see if any of...

It's also going to run less than optimally, seeing as there's a cursor in it.

What's supposed to happen?