Love Mr. Ben-Gan's books!! One of the authors I look for when purchasing a new SQL Server book.

select ROW_NUMBER() over (partition by TABLE_SCHEMA, TABLE_NAME

order by TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_TYPE),* from...

Odd that it works with all tables selected. Are you using schemas or is everything under dbo? (was wondering if owner property set -- check sp_helpdb databasename because I...

Did you try using the Microsoft JDBC driver (if possible in your situation) for connecting to SQL 2012?

Is this what you are looking for:

GRANT SELECT,UPDATE,INSERT,DELETE,EXECUTE ON SCHEMA::DM TO User;

GRANT SELECT ON SCHEMA::NY TO User;

GRANT SELECT ON SCHEMA::CA TO User;

Depending on the size of the company you could always have a list of standards for them to use when they install (hopefully developer edition unless they need the other...

would this article help be close to your situation:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/61241fc8-9451-4abd-915d-e704f10d7a57/problem-pulling-characterstring-values-from-an-informix-database-using-ssis-2008

Encountering some of the same issues. The problem maybe running the SSIS packages using dtexec.exe(64-bit mode). Try going to your project properties --> configuration properties --> Debugging -->...

Not that I am aware of

The piece from the link that talks about it:

Deleting a data or transaction log file removes the file from the database. You cannot remove a...

I'm wondering if NextResult takes you to the next Result Set from the Reader. You probably only have one Result Set.

maybe you need to look at something like this or...

Old thread, but still got the email.

I would agree that it would not carry over to the inactive cluster. Although, I have not tried it on a cluster, but...

The enterprise license was a partnership license. Management does not want to run a different edition on test/dev/production. It would be pointed at if anything goes wrong. ...

I guess you could assume that. I didn't feel this stored procedure would choke on a cursor. I didn't make it a priority when looking at the problem....

There are some definite logic problems.:w00t:

I think this part is not making sense to me:

AND NOT EXISTS

(

SELECT 1

FROM master..syslogins sl

WHERE su.sid = sl.sid)'

I worked with what you...

I agree totally on getting the SQL 2005 service pack 3 out. I do hope it is tested properly, but I would be surprised. I have several new...

Index Stats.....

ObjectId FragPercent RecordCount ...