How is the stored procedure being called? Is there another outer transaction?

Have you run DBCC OPENTRAN() to see what the open transaction is?

I don't think there is a way to do this without doing some CLR programming.

There is no way to control this in my experience.

You can write a custom web page that then calls the report passing the parameters.

I'm not a .NET Nuke expert, but PASS uses .NET nuke for the chapter sites and I hate it.

I'm pretty sure that you can do VB.net in a...

You can't really do that with one query because the database permissions are stored in each database.

You can use sys.server_principals for logins and then loop through the databases to find...

That error should only happen when connecting and if the developer is loading the 7000 rows at once it should be in across one connection. Sounds like the VB...

You'd have to test to find out. I've used both and not had problems.

You misspelled QUIET you have QUITE. Try this

setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myaccount /SAPWD=sapwd /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

Also, unless you are in MIXED MODE AUTHENTICATION you do not need to supply the...

doug 40899 (4/18/2011)

---

Here's two lines of data from the moncalladd table:

17055055426893BITTAR&ESKEW03849010200YIUM 8400384901293TG 8199

27055155427287ZZOB02 ...

They might be better off if they used permanent tables instead of temporary tables.

You are referencing those columns in the where clause of the not exists subquery and you have removed them from the derived table in your from clause. If you...

There are a couple of potential things here.

1. You aren't displaying the TimeStamp column so it is likely working just as expected. The TimeStamp may not be the...

Since blocking is a transient operation you can't be guaranteed the blocking will still be in place when a process runs. You might want to look into using event...

As long as the SQL Server service account had write permissions on the directory you should get a proper backup. A user logs into SQL Server and then any...

You should use TRY CATCH, but error messages are stored in sys.messages so you can get the description from there. You also need the language to limit the results....