Set BreakPoints in your C# Script Editor, and verify the values in your variables. Step thru the code this way to troubleshoot issues like this. You can hover the mouse...

That is exactly what I am experiencing. I have stopped the full backup of the Primary. We back that Db up to keep a copy.

I was just reading about Copy_Only...

HI George

Yes, in a way. My LSN numbers are getting out of sync when the restore process tries to restore a log file that was just deleted.

I cannot figure out...

Hey George

I have had to code the restore process by hand. It is sitting behind a DMZ. I did leave the backup process in the Log Shipping statement.

The primary database...

Yes, but it only works with SQL 2008.

There is good info in the SQL Books Online as well. Read the BOL to figure out how to setup the respective environments.

Just...

I am only saying that :

Very few people on here would know MySQL. Hence the name of this site. "SQLServer"

The syntax is totally different.

I could just as easily go online...

I suggest that you read the MySQL documentation. Because if you do not know what the code is doing, how would you expect someone here to know, or to be...

What are you actually wanting the alter statement to do? Change the name of the column? Change the default value? what????

Andrew SQLDBA

LOL

It takes effect immediately after leaving the page.

That is funny though.

The picture shows how I really feel at times 🙂

Andrew SQLDBA

Thanks Lowell

I now have one.

Andrew SQLDBA

Thank You, but Sorry

The Upper Management said no using PS. They only want t-sql, so that anyone can come in behind me and be able to modify the code.

Thanks anyway

Andrew...

Use a stored procedure that will Delete certain rows, depending on the criteria. You give the group execute only to the sproc.

Why not do that with a SSIS package? That...

This does not even make sense

We need to allow users to CREATE tables within this schema, and allow them to delete database from within tables, but not allow them to...

Yes, currently the delete task is now the only task in the package.

I have scheduled the package, and it is still give the same error.

I am going to move the...

No, I am the only one using this box. I just copied the files there. The FileInfo class does not lock the files in any way.

I am using a File...