Viewing 15 posts - 3,121 through 3,135 (of 4,272 total)
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
November 9, 2009 at 3:06 pm
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...
November 6, 2009 at 7:44 am
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...
November 5, 2009 at 9:09 pm
jts_2003 (11/5/2009)
Certainly an interesting idea, but as some others have said I woul dhope the DBA would have the authority to vet any code gpiong into the live environment.
Often times...
November 5, 2009 at 9:59 am
Kit G (11/5/2009)
To many professionals, the use of "*" is a sign of sloppy programming and a lack of understanding.
I have to agree, I view it as sloppy, there are...
November 5, 2009 at 8:51 am
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...
November 5, 2009 at 12:14 am
Look at:
It is easier through SQL 2008 which is what I tested on earlier..
CEWII
November 5, 2009 at 12:12 am
prathyushaa (11/4/2009)
I work as a Systems Tester and dont have much knowledge...
November 5, 2009 at 12:04 am
prathyushaa (11/4/2009)
Can any one explain me what this means đŸ™‚Sum(ISNULL(GSTExclusiveAmt,0))
Regards,
Prathyusha
Take the field GSTExclusiveAmt and if it is NULL replace NULL with 0, then sum it with all the other rows.....
November 4, 2009 at 11:21 pm
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
November 4, 2009 at 11:18 pm
Lynn Pettis (11/4/2009)
PiMané (11/4/2009)
If you're just starting with views take a look at this link from MS where it explains the use of INDEXED VIEWS. (http://msdn.microsoft.com/en-us/library/dd171921.aspx)Pedro
Indexed Views aren't necessarily the...
November 4, 2009 at 10:56 pm
SNIP
Not sure how this post ended up in this thread..
November 4, 2009 at 10:49 pm
Christian Bahnsen (11/4/2009)
November 4, 2009 at 10:47 pm
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...
November 4, 2009 at 10:35 pm
Viewing 15 posts - 3,121 through 3,135 (of 4,272 total)