Viewing 15 posts - 1,501 through 1,515 (of 2,636 total)
It's easy if the packages are stored in SQL Server. Right-click on the package listed under Local Packages, select Versions..., choose the versions you want to delete and click the...
June 1, 2007 at 9:11 am
You'll need to stop SQL Server Agent before restoring msdb. Otherwise, it's like restoring a user database. See "restoring msdb" in BooksOnLine.
If you have another instance, like a test or...
May 31, 2007 at 12:21 pm
TJP8,
I think you're referring to the login being a member of the sysadmin server role? If so, it only has administrative privilages in the instance where it's a member of...
May 31, 2007 at 12:15 pm
Tim,
Check this article and see if any of the situations and workarounds fit your circumstances. http://support.microsoft.com/kb/288910/en-us
Greg
May 31, 2007 at 11:57 am
Deleting and updating with a WHERE clause requires that the data be readable so the correct rows can be removed or modified. It seems odd, but db_datawriter does not grant...
May 30, 2007 at 9:45 am
Despite what is implied about db_securityadmin in BOL, only members of sysadmin and db_owner can add members to fixed database roles. db_securityadmin can only add members to user-defined database roles. ...
May 30, 2007 at 9:37 am
I think you could use sp_helptrigger to determine the name of the trigger for a given parent table, then use sp_depends to see the dependencies of the trigger.
Greg
May 29, 2007 at 9:54 am
A Data Driven Query task will do what you want, but it's slow because it processes the source data row by row. I prefer the staging table/stored procedure approach mentioned...
May 29, 2007 at 9:44 am
I've seen it. It's normal ouput when DBCC CHECKDB is executed for a small database. No errors were found (good!) and it took less than a second to run in...
May 25, 2007 at 11:02 am
I'd say either Administering or General Discussion. I've seen posts about Maint plans in both forums.
Greg
May 25, 2007 at 10:54 am
I do this all the time to get production data into dev tables. Follow Lynn's advice and you won't be sorry.
Greg
May 24, 2007 at 1:02 pm
It depends on what the packages do. I have packages saved as legacy DTS packages in an instance where all the databases have been changed to comp. level 9.0 and...
May 24, 2007 at 10:38 am
The first thing you'll need if you want to make changes to DTS packages in SSMS is the DTS Designer components. Here's the download location:
May 22, 2007 at 3:30 pm
anoel,
I'm not sure what you mean. Do you mean that you have some primary key values in the old database tables that are identical to values in the secondary database...
May 21, 2007 at 11:48 am
What's your deal? You seem to post the same question multiple times in this forum. Why don't you just ask your instructor for help? People don't monitor these forums to...
May 18, 2007 at 9:35 am
Viewing 15 posts - 1,501 through 1,515 (of 2,636 total)