Setup a Job that runs every X minutes; have it check the Log File size and if over, then take corrective action.

Depending on your configuration, you should be able to do this with a SQL Agent Job and definitely with Service Broker, if you set it up right.

Of course, you should be aware that the dependency tables and info is not always up-to-date.

The [font="System"]USE db[/font] command only changes the session it was executed in. [font="System"]EXEC(@sql)[/font] does not execute the [font="System"]@sql [/font]text in your current session, but creates a new session and...

SELECT @LockStatus=Count(*)

FROM Lock (nolock)

WHERE TableName=@TableName

AND RowID=@RowID

AND ...

Hey! Wait a minute...

This isn't homework is it?!?

I do not have time right now to do an optimal version, but this should be better than an iterative or recursive solution:

Select A.*, B.*

From TableA A

Left...

Jonathan Beck (4/3/2008)

---

declare @file Nvarchar(max)

set @file = N'D:\BKUP\Demo\Demo_backup_200804022315.bak'

RESTORE DATABASE [Demo] FROM DISK = @file

...

Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\||||||'. Operating system...

Upgrade to SQL Server, then do these two steps:

1) Create a View on SQL Server that emulates your old Access table with everything in it.

2) Change your word ODC from...

From BOL: "...unless TOP is also specified."

Use [font="System"]TOP X[/font] where [font="System"]X[/font] is some number greater than the number of rows you...

Did you mean to contribute this as an Article?

delta dirac (4/1/2008)

---

oh, it's a sad thing for me to hear that there's no way :crying:,

i needed this because , i am an engineer and my tables structor(the columns in...

Maintenance plans delete backup files for me on SQL 2000.

Scripting system stored procedures still works the same.

As for system views, well their text is still in sys.syscomments

Corrected/clarified version of my view:

Create View yourTable2 AS

Select USER_ID

, VAL_1 + VAL_2 + VAL_3 + VAL_4 AS [Total]

From Table1