Viewing 15 posts - 1,981 through 1,995 (of 2,636 total)
None that I know of. When I was trying to recreate your situation on my test instance, I ended up having to do RESTORE WITH RECOVERY in Query Analyzer just...
June 14, 2006 at 11:00 am
Depends on what permissions have been granted to Public, which is a database role. If Public has 'Execute' permission for a stored procedure, the stored procedure does not contain dynamic...
June 14, 2006 at 10:22 am
Ahh yeah, that's right. The only way to leave the database operational after restoring log backups in Enterprise Manager is to the check the first option under Recovery Completion State...
June 14, 2006 at 10:13 am
In Enterprise Manager, right-click on the database, select properties, and select the options tab. Under Access, there is a check box for Read-only. Uncheck that, and the database should be taken...
June 13, 2006 at 5:16 pm
Do the tables and stored procedures have the same owner? If not, make it so and see if the role members are able to execute stored procedures.
Greg
June 13, 2006 at 5:09 pm
See this KnowledgBase article: http://support.microsoft.com/kb/326485/en-us
Greg
June 12, 2006 at 9:43 am
I'm not clear about what you want. Do you want the database to be in read-only mode after restoring with Enterprise Manager?
Greg
June 12, 2006 at 9:37 am
That's the only option unless you happen to have saved the package to a file. Packages that are saved in SQL Server are stored in msdb. If you can't restore that,...
June 10, 2006 at 12:33 pm
The package runs in whichever instance you're connected to when you open the package and execute it. The same is true for SQL Agent. The package will run on whichever...
June 10, 2006 at 12:30 pm
Is there a task in the package that truncates or deletes from the SQL Server tables? Perhaps the workflow was accidently changed so the delete runs after the import step.
Greg
June 9, 2006 at 9:53 am
The location is Seattle. It's in the last sentence.
Greg
June 9, 2006 at 9:36 am
Do you want to copy the databases to another server and then keep the data in sync with the original databases? Or is this a one time move, like to...
June 8, 2006 at 2:26 pm
Are the source databases (A,B,C) on a different server than the destination databases (1,2,3)? What exactly do you mean by "refresh"? Does that mean you want to replace all the...
June 8, 2006 at 2:07 pm
Is dbo.NCI_ATTR_VALUE_NUM a view or a user-defined function, by any chance? It could be that dependent objects aren't being created in the destination database in the correct order. I've had...
June 7, 2006 at 9:52 am
Viewing 15 posts - 1,981 through 1,995 (of 2,636 total)