that's always a good call. Otherwise they won't be able to log in 🙂

~bot

iqtedar (11/4/2008)

---

i was told to grant select,update,delete and insert permissions to a user xyz..now there is a defined role brf.tool....and then there is db brf_9...this is wat i did..i would...

I'll throw my hat in too.

The main thing I would do would be to determine the transactions that are growing the tempdb to that size. You can use DMV's...

Matt Miller (10/29/2008)

---

A few thoughts:

- The point of being in FULL recovery is to do point in time restores. If you DON'T want to do point in time...

Andy Warren (10/29/2008)

---

Looking forward to trying it as well. I've always used the example of updating a uniqueidentier column with all new values from newid() to generate fragmentation and show...

I'll bet you auto checkpointed because of your recovery interval setting.

I'm assuming you have 'truncate log on checkpoint' turned on?

You can run a trace to verify this theory.

I believe DENY VIEW DEFINITION will do the trick for most things.

Here's the MSDN article that will explain what you can and can't do with it.

http://msdn.microsoft.com/en-us/library/ms187113(SQL.90).aspx

Michael Earl (10/27/2008)

---

When a user disconnects, all SQL Server locks are released. You cannot have a resource locked without the associated spid. So, if you have users that...

That makes sense.

32 bit SQL Server is running in 32 bit emulation mode on the X64 platform.

Everything in its execution space would then run in 32 bit emulation mode, so...

IT's all there. Did you see the scroll bar in the code section?

That's pretty tight, thanks Ryan.

I don't use tally but I might investigate it. Something about adding a table to avoid loops smells a tad like hackery to this robot...

The ANSI settings in agent are different than in an interactive session, that's another thing I can think of.

It would have to be the perfect storm, but things like returning...

I have bad news for you: that just won't work.

Try one of these:

Find a different 64 bit driver, get a 32 bit server, or pray that someone has written a...

Try using The DMV's to tell you what indexes need to be built (or dropped)

The output of this query can be interpreted according to Microsoft best practices:

Index Advantage above 5k...

I think this is a kerberos delegation problem.

You'll need to set a SPN for the SQL Server in order to pass-through your credentials.

~BOT