I normally prefer to script the creation of all constraints and use something like this procedure to drop them when needed

😎

CREATE PROCEDURE [dbo].[DROP_SCHEMA_CONSTRAINTS]

(

@TABLE_SCHEMANVARCHAR(128)

)

AS

/*

DECLARE @TABLE_SCHEMANVARCHAR(128) = N'myschema'

EXEC dbo.DROP_SCHEMA_CONSTRAINTS @TABLE_SCHEMA

*/

DECLARE @SQL_STRNVARCHAR(MAX) =...

marcelo.negrisoli (5/7/2014)

---

Hi,

I wrote a script task that´s build a SSIS Package dynamically with a Script Task.

When I open this dynamically created package, the Script Task shows with error and "the...

NOLOCK turns the database into a...

Sean Lange (5/7/2014)

---

Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

river1 (5/7/2014)

---

Hi,

I would like to know in with date did a SQL Server 2005 instance was installed on a server.

Can I know This using...

computer24hr (5/7/2014)

---

Password, it should be unique to each user name.

The password is stored as nvarchar(10) it's text.

I thought the SP, what do you think?

Relatively low amount of...

computer24hr (5/7/2014)

---

hey,

I have a table of users including: UserName, Password (comuted col), FirstName, LastName, Address and other details....

I have to keep 10 Recent passwords , so I created another table...

What about dropping and recreating the constraints?

😎

BOL even slower than my memory when...

Good stuff!

😎

My memory playing tricks on me:-P

Thanks Sean!

😎

Thinking back, I cannot remember ever using 0 as seed value for a CHECKIDENT if the initial seed value was <> 0, regardless of which method was used of emptying...

george sibbald (5/7/2014)

---

from glenn Berrys diagnostic...

Quick thought, what rights has the user (running the package) in the file system, I've seen this where users can list but not open directory content.

😎

Shaun2012 (5/7/2014)

---

The path is correct as it goes through Foreachloop container and through sequence container, also it goes check the the audit table and delete the rows but fail...

Can you run the DBCC statement from Visual Studio?

😎