sharma (6/8/2008)

---

Thanks for ur reply..

I had changed the query as follows

INSERT INTO TEST1[ID,NAME,EMAIL]

SELECT A.ID,'Alex','alex@gmail.com'

FROM TEST2

RIGHT OUTER JOIN TEST2 B ON A.ID=B.ID WHERE A.ID IS NULL

now also it shows bellow error..

While...

quickermind (6/6/2008)

---

AJ,

I have a couple of extra questions in regard to your deployment and programmatic invocation schema.

Are you talking only about server-side applications?

In my case, I need to run...

I prefer filesystem, although I haven't experienced the benefits of putting the package on the SQL Server itself. Yes, since it's filesystem, you can call them via any language that...

Awesome question! Quite scary too... :Whistling:

Great article Grant!

Schema View is a feature in DBPro. You need to install DBPro (VS 2005 Team Edition for DB Professionals) for that.

Data compare is to compare data not structure. To compare structure you could use Red gate's sql compare...but again the main idea of this tool is to give you differences...

You may re-veriry how the front end is obtaining connection to the database. Indeed, the ideal way would be Windows Authentication and the logins you include as a part of...

Another way would be via DBPro's schema view. It's a lot easier to identify which objects in the project become invalid due to any kind of change(s). If you have...

Good question Ron.

There's a function IDENT_CURRENT(table_name) that gives the current identity value of the the table. I am not sure if it can be included in the DBCC statement itself...but...

Vinay,

NORESEED gives the info about identity values in the table. When you issue

DBCC CHECKIDENT('table_name',NORESEED);

You get the result which looks like this:

Checking identity information: current identity value value, current column value...

All,

My bad.

It could be my script...coz I tested a similar scenario on fellow colleagues' machines with successful results and only then did I decide to write the article. While...

DAC is disabled on SQL Express by default !!!

No is the correct answer...1 point should to be awarded to all who answered "No".