tusharbedekar (9/30/2009)

---

I want to display status of SQL server jobs with last run date and time, in one of my application. But I am not having administrative privileges for database....

Fred Zimmerman (9/30/2009)

---

My environment (coming in with it set) for SQL Server 2005 dictates that I have the multiple back-end SharePoint databases set to FULL recovery mode (not Simple).

This being...

What rights do you have?

I have heard that UDF's; while not technically stored procedures will get traced with the statement level events, such as SP:StmtStarting

http://www.databasejournal.com/features/mssql/article.php/3720361/Microsoft-SQL-Server-2008----Change-Data-Capture--Part-I.htm

This is one of the new features in sql 2008, you also have more advanced auditing functionality as well.

naveenreddy.84 (9/30/2009)

---

Hi,

I am using a xp_cmdshell method of running command and i used the following tsql statement

exec xp_cmdshell 'bop_cmd'

but it gives following error

'bop_cmd' is not recognized as...

pitso.maceke (9/30/2009)

---

The problem with my query is that the AND on the case statement seems not to be working as supposed, most of the example that I saw does not...

The solutions mentioned will help in most scenarios, it is totally different and a lot easier in sql 2008, as changes can be tracked.

smthembu (9/30/2009)

---

Hi All

I have a package with the flat file destination set to c:\ drive now i need to change the file destination to another drive but after i have...

This link will help you around the issues

http://forums.asp.net/p/1135437/1940011.aspx#1940011

Steve Jones - Editor (9/29/2009)

---

Open Source != free. It means that someone is allowing you to see how the code works.

Lots of these little utilities are written by someone that...

TheSQLGuru (9/29/2009)

---

Silverfox (9/29/2009)

---

TheSQLGuru (9/29/2009)

---

Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because...

RTaylor2208 (9/29/2009)

---

Hi,

I have been asked to define my own objectives for my yearly appraisal and to be honest I am not entirely sure where to start as I have never...

TheSQLGuru (9/29/2009)

---

Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers would...

TheSQLGuru (9/29/2009)

---

Buy FolderInfo and use it to quickly spot space consumers on the drive of concern. Very useful utility I have been using for a LONG time.

Also, instead of...