Viewing 15 posts - 46 through 60 (of 61 total)
Matt Miller (3/13/2008)
"whining" sounds a little like
Msg 3903, Level 16, State 1, Line 1
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
Yes, that is what I see the first time...
March 13, 2008 at 1:43 pm
I also want to mention...
there are NO active processes in the Activity Monitor. So there's nothing to kill. Just my two connections for little old sa - one...
March 13, 2008 at 1:02 pm
Thank you ALL for your help.
It has been very useful!
I took a hybrid of some of your scripts, to get Stored PRocs / Views / Functions, a static...
March 13, 2008 at 12:57 pm
You can use sp_helptext to get quite a bit of stuff. See BOL for details. Investigate things like the sys.objects view.
Thank you for your response.. honestly, this seems...
February 21, 2008 at 1:25 pm
Willem Tilstra (2/21/2008)
Red Gate has a product that will do this very efficiently. It's called SQL Compare.
Thank you Willem.
Can this tool be set up to run AUTOMATICALLY, say at midnight...
February 21, 2008 at 1:22 pm
Timothy Ford (2/20/2008)
February 20, 2008 at 10:45 pm
I want to duplicate the database.. EXCEPT for the data.
The easiest way to do this is to use a comparison tool (SQL Compare from Red-Gate is my preference).
Create a new...
February 20, 2008 at 2:52 pm
Greg Charles (2/14/2008)
I wouldn't mess with scripts anyway if you want to duplicate the database.
Actually, that is exactly it.
I want to duplicate the database.. EXCEPT for the data.
(Also...
February 14, 2008 at 12:17 pm
Greg Charles (2/13/2008)
Fixed database roles are always created when a database is created so you shouldn't have to script them.
I don't get what you mean.. fixed database roles...
February 14, 2008 at 7:15 am
Chirag (2/13/2008)
Or u can use the Generate scripts to script out all the users and logins.
What's what I did.. but the database role memberships did not get scripted.
What I want...
February 14, 2008 at 7:11 am
Snapshots in this way almost sounds like a poor man's Snapshot Replication.
I think the problem is cursors. I scriped every Stored Proc in the database, and yes thare are...
December 28, 2007 at 8:49 am
noeld (12/27/2007)
Aren't you better off using Snapshots instead ?
What are Snapshots? In Oracle, Snapshots were a precursor to materialized views, similar (in theory) to SQL 2000's indexed view...which never...
December 27, 2007 at 12:58 pm
Jeff Moden (12/27/2007)
Why is this being done? What is the purpose for creating 5 to 10 clones per day and then dropping them?
Good question. This client has some...
December 27, 2007 at 9:44 am
Steve Jones - Editor (12/26/2007)
How often does this need to be done and what is the business rule. Maybe we can help you find another way around this.
Thank you for...
December 26, 2007 at 10:12 am
So I'm looking at something like this:
CREATE PROCEDURE spCopyDB (@NewServer varchar(100), @NewDBName varchar(100))
AS
BEGIN
-- Backup existing DB to C:\AdventureWorks.bak
-- Restore bak to \\@NewServer\@NewDBName
-- If @NewServer = ThisServer
---- ...
December 26, 2007 at 9:23 am
Viewing 15 posts - 46 through 60 (of 61 total)