Comments
Sort by recent activity
Well, my database is 150 GB. I guess I could create an empty copy of it...
As for checking for quotes in the DB, I've checked the original DB and it does have brackets. Not sure why the snapshot thinks it's supposed to be quotes.
In MSSMS I click "Script Stored Procedure" and script it to a file, I get a create statement that looks like:
USE [warehouse]
GO
/****** Object: StoredProcedure [dbo].[BillingReport] Script Date: 08/15/2007 09:36:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[BillingReport] (@OrgObjectId INT, @beginDateTime DATETIME, @endDateTime DATETIME)
...
But when I compare it with SQL Compare, It shows quotes: CREATE PROC "dbo"."BillingReport" (@OrgObjectId INT, @beginDateTime DATETIME, @endDateTime DATETIME)
...
/ comments
Well, my database is 150 GB. I guess I could create an empty copy of it...
As for checking for quotes in the DB, I've checked the original DB and it does have brackets. Not sure why the snapshot ...