Viewing 15 posts - 1 through 15 (of 34 total)
Why storing the ssis at the File system level instead of the server? Storing packages at the file system is a security problem. A better way will be to store...
April 27, 2010 at 9:46 am
Change [Sch_AuditDdl] to proper schema most of the time (dbo).
or create a new schema with name [Sch_AuditDdl]
February 26, 2010 at 11:37 am
Please ensure than when create object didn't create a separate schema using the user login. The error means or the object doesn't exist or there is a mismatch on the...
February 26, 2010 at 11:28 am
How the data will be store, used and extract that depends on your application, the word nasty is not the word I will used when I don't understand or disagree...
February 26, 2010 at 11:26 am
Its sounds like the file generator ( The app that created the file ) is using unicode instead of ascII, verify that the file format its ascii and not unicode.
November 3, 2009 at 9:50 am
This will be a way to save relations from a table.
--Create Table to store constraint information
IF NOT EXISTS (Select [name] from sys.tables where [name] = 'T_FK_Xref' and type = 'U')
July 30, 2009 at 8:51 am
Here is a better example of how to restore the indexes :
If Exists (select distinct
where IsClustered = 1
and UniqueType 'PRIMARY KEY'
declare @IndexName varchar(255)
July 30, 2009 at 8:46 am
See scripts Truncate all Tables There you will find a script to save and restore the table relationships. Normally you want to keep that kind of data separated from it.
July 30, 2009 at 8:43 am
declare @cmd varchar (max)
Select @cmd= "Create index "+IndexName + "......From tblDBAIdxMetadt
You got the idea 🙂 I will post a better Query tomorrow.
July 29, 2009 at 9:16 pm
April 17, 2009 at 12:56 pm
Hey I post the below code but here it is :
December 17, 2008 at 1:22 pm
Glad to help
December 16, 2008 at 9:07 am
One of the problems that I see a lot is that when trying to restore the relationship there are orphans on the tables. Ensure that all the foreign keys from...
November 24, 2008 at 2:22 pm
What's seems to be the problem
November 20, 2008 at 9:01 am
Very good information on the link. Like the Blog stated there are many ways to aproach and problem..Thanks for the input.
November 17, 2008 at 3:01 pm