Follow the ALTER DATABASE with a USE statement in the same batch will usually get the connection.

USE [master]

ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

USE [MyDatabase]

Did you test it to verify that this syntax does not work?

WITH STATE = ON

If having the database in read only mode is OK, you could restore the database into standby mode, and then apply transaction log backups to roll it forward each day.

nmaddox (10/11/2012)

---

They're some pretty savvy SQL users, so I may just give them a table with definitions and let them look up the values whenever they need to. That might...

You can add more detailed descriptions as extended properties via SSMS or with a stored procedure call:

EXEC sys.sp_addextendedproperty

@name=N'ColumnDescription',

@value=N'Credit Card Expiration Date' ,

@level0type=N'SCHEMA',

@level0name=N'dbo',

@level1type=N'TABLE',

@level1name=N'CustomerOrder',

@level2type=N'COLUMN',

@level2name=N'Order_CCExp'

TOP is required when you have an ORDER BY in a derived table or view.

Just wondering, because different types of date/time data types have different display formats in SSMS.

declare @date date,

@datetime...

Resender (10/10/2012)

---

Yes, but I believe that in Oracle you don't have a single rdbms to manage multiple database, I could be wrong in this aspect been at least 18 months...

I don't think that is true either.

Any true RDBMS does not allow...

Danzz (10/10/2012)

---

Using SA account.

All my .bak backup cleanup history works fine, cleanups after 48Hrs.

I doesn't work for my txt file to cleanup. These txt file are created by job...

Resender (10/10/2012)

---

I just had a question of my boss, for one of our clients we have a stored procedure that has to dynamically connect to a database table.

Both the database...

Is the "date/time field" you are updating actually a DATETIME data type?

What is the actual data type?

I am not suggesting that you use NOLOCK in your stored procedure.

You should investigate why your query is being blocked. You...

You could create a unique index or constraint that has all eight columns to guarantee that you cannot have duplicates.

There can be a lot of overhead to such a wide...

Try running the statement below. If it runs much faster, your original query is probably being blocked.

select COUNT(*) from TransactionLog with (nolock)