And since this is a SQL 2008 thread if you are running a SQL Audit on the audit group "SERVER_OBJECT_CHANGE_GROUP".

SQL 2008 BOL Oct 2009: http://msdn.microsoft.com/en-us/library/cc280663.aspx

BTW SQL Audit is cool..

CEWII

I fully understand the need to support SQL 2000, but as SQL 2000 is nearly 10 years old, now would be a good time to let those holdouts know that...

Although you can run DTS packages on SQL 2005/2008 you cannot create new ones. SSIS is a quantum leap over DTS in what it can do. Basically everything...

I'm a little fuzzy why you would implement it this way.. Your root directory path should be IN your config file. So you should need one environment variable...

Often times...

I have to agree, I view it as sloppy, there are...

Save the package out then you can edit the destination so that it handles identities.

Sprocs are a different matter, you have to use a transfer objects object is SSIS to...

Look at:

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/a3282ebc-1030-47d8-9ff7-8c6f7d2a5725

It is easier through SQL 2008 which is what I tested on earlier..

CEWII

prathyushaa (11/4/2009)

---

Thanks CEWII but the thing is that i'm a beginner in SQL .

I work as a Systems Tester and dont have much knowledge...

Take the field GSTExclusiveAmt and if it is NULL replace NULL with 0, then sum it with all the other rows.....

You can use SQL Server Management Studio (SSMS) usually, but I'm not sure about with express..

Just tried it.. Yep you can use SSMS..

CEWII

Lynn Pettis (11/4/2009)

---

Indexed Views aren't necessarily the...

SNIP

Not sure how this post ended up in this thread..

Christian Bahnsen (11/4/2009)

---

First, how would our acting DBA grant me permissions to see SQL Agent? I have SSMS 2008 but I don't see the SQL Agent node, so I...

Permissions is a bit trickier.. In general users do not have access to a stored procedure unless you grant EXEC rights to their user or a database role they...