also, take a look at this, where you should change the WarningsReturnAsErrors flag in php.ini:

http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx

gotcha, so it works correctly most of the time, but not correctly when accessing via PHP.

When using the PHP application and DBBUser the trigger fails to even run and the...

fixed the link for the screenshot, so you can see an example of how other errors occur in the trigger, but only the generic error gets sent to the user

again, no matter what the REAL ERROR is inside the trigger (ie Invalid object name 'DatabaseLogonAudit.dbo.AuditDatabase '. or user does not have access,

the generic error message is all they get.

pretty...

this error:

The check for encryption trigger fails with the infamous ‘login fails due to trigger execution’ error when using any .Net app (SSIS, SSRS, VB program, etc.).

is normal for a...

johnnyrmtl (3/20/2013)

---

Since the trace will never be closed and it will be started via command line , how would I go upon this if at all possible in validating which...

johnnyrmtl (3/20/2013)

---

K thanks !

I've launched a profiler trace and piped it towards a directory and a file...

I see 2 ID's within sys.traces but with the one I launched has a...

johnnyrmtl (3/20/2013)

---

Just to clarify ... if I am starting a custom trace ( not server default ) from profiler and would like to confirm the events that I am tracing...

i cannot imagine any way to automate this;

this really requires someone to go thru the data, and familiar with a lot more than just the names/users;

you don't have any other...

akberali67 (3/20/2013)

---

CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

davidandrews13 (3/20/2013)

---

are you doing something that...

there's far more information out there than we can provide in a simple forum post; forum posts are great for specific questions, but not so much for general research.

i...

most foreign key constraints are placed in a column that allows NULL, which is undefined;

if you are storing 'empty' or an empty string or anything else that's not in the...

kapil_kk (3/20/2013)

---

Hi,

I have a scenario according I have to create a table struture. As I have never designed any table structure based on a scenario of SRS. Plz guide in...

have the developer change the application connection string.

both SQLOLEDB and SQLNCLI providers have a default timeout of 30 seconds unless otherwise overridden in the connection string created by the application.

if...

peter.griffin 45527 (3/19/2013)

---

Hi,

I hope this is the correct location for my question.

I have written a simple piece of VBA to convert some data and save as a csv file which...