you can use OPENROWSET to load any files into database, e.g.:

DECLARE @xml xml

SELECT @xml=CAST(BulkColumn as

You can try to set up event notification to monitor

Database_Mirroring_State_Change trace event. When it happens, run your script in the event handler.

Yes, AWE is not required. Just add /3GB switch in windows boot.ini. And make sure in sql memory configuration, the max mem is set to 3GB

Can you check SQL agent properties-->Connection? You can try to change to use a SQL account (member of sysadmin)to connect to SQL server.

From the error message, database ADWorks_dbsnapshot_0930 is a database snapshot. Database snapshot cannot be backed up.

you can filter out database snapshots in your scheduled backup task. For database snapshot, the...

You can package a database (not sql server) into your front end installation.

Either the following will work:

1) Take a backup of your DB into the package: in your setup, you...

I am not sure why you get this error.

But complex nested queries can degrade performance. It's difficult to maintain and easy to get wired errors.

It's better to use temp tables...

There are lots of ways to do this.

1) use INSERT ... SELECT. 

If the two DBs are in the same server:

INSERT NewTable (Field1, Field2,...)

SELECT Field1,Field2,...

FROM CurrentDB.Table

If the two DBs are...

It's a running summary issue.The following code is an sample:

DECLARE @Balance TABLE (RID int identity not null, [description] nvarchar(255) not null, [date] datetime not null, amount in tnot null, balance...

You can also use dynamic tsql to solve the issue:

DECLARE @sql nvarchar(4000)

SET @sql='

SELECT * FROM Users WHERE ID_User

IN ('+(SELECT TOP 1 ID_User_List FROM MyUsers)+')'

EXEC (@SQL)

You can insert into parent table directly if you do not need more processing. Since the TransactionID is an identity in the parent table, you need to get the new...

As the error message says, you need to use the batch delimiter "GO" to seperate your create proc statement into different batch.

you can use OPENXML to shred parent and child data into two temp table. Then you can handle the parent and child relation quickly.

What you need is properly define the PK (or index) of the table. The key should contain dateop,processid, and opid and in this order.

Since you are querying for date range,...

You can use $PARTITION function, take the new range boundary value as the parameter if boundary value belongs to RIGHT, or 1 plus the new boundary value as the parameter...