Viewing 15 posts - 46 through 60 (of 80 total)
Steve Jones - Editor (7/16/2008)
If you changed the name of the DR server to the original, I'm really stumped as to how the plans are running on the original server.
We...
July 16, 2008 at 2:23 pm
1) We do not have SSIS installed, therefore we cannot export a package.
2) When a maintenance plan is created with the SMS wizard, the connection is created as 'local server...
July 16, 2008 at 9:01 am
yes, but addserver does not affect the connect set up in the maintenance plans.
July 15, 2008 at 2:50 pm
We are moving maintenance plans to a DR server with a restore and I need to change the (local) connection to the new server. The maintenance plan screens in...
July 15, 2008 at 2:39 pm
In BOL it says:
Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE...
February 28, 2008 at 9:19 am
This is true, however, I thought that some people here might have had the same requirements as we do and could give us some suggestions for software.
January 29, 2008 at 8:49 am
I have seen this blog entry. Even though we do execute some jobs from a scheduling package using sqlcmd, I am seeing this problem even when I execute the...
January 3, 2008 at 12:42 pm
Does anyone have an answer to this? This server is not production yet, but is scheduled to go live next month. I really need to get the replication...
October 12, 2007 at 8:10 am
That worked. Thanks.
Steve Jones - Editor (10/8/2007)
Save as a VB file (.bas). You should...
October 8, 2007 at 3:30 pm
We do not have Visual Studio available. When I open the Structured Storage file in Notepad, I only see garbage. I have tried saving the file as both...
October 8, 2007 at 2:43 pm
How do I read a Structured Storage file?
The third package only fails if it is run as a batch job.
Since we have the same packages on test and prod, we...
October 8, 2007 at 8:08 am
As I said, there are three packages executing as a group. Each package contains a connection task, one or more stored procedure tasks to update data in a SQL...
October 8, 2007 at 7:55 am
I am trying to put a trace on the server to capture the sql execution.
I have been checking the SQL Server logs, the event viewer and the SQL backup...
August 24, 2007 at 8:06 am
We tested the sproc on out test and development servers before we placed it into production. This sproc is running on several production servers with no problems. We have also...
August 23, 2007 at 7:17 am
I have four SQL Server 2005 SP2 installs which show 9.00.3033.00 as the Product Version. I do not find this in your list. Can anyone tell me what this build...
May 29, 2007 at 10:15 am
Viewing 15 posts - 46 through 60 (of 80 total)