resource database is small to begin with;

i'd look at whatever is eating up your disk space.

where are the backup files being created?

look for log files from traces you forgot about...

SQL is very restrictive rights wise...users only get what you give them access to. You want to avoid things like just granting a user db_owner status or any other roles...

win your triggers pretty close to mine, it just has few issues:

permissions: MOST users will not have access to that audit table you are inserting into...so the end result is...

i beleive the fix is to change the users default schema...which doesn't necessarily allow them to create tables.

http://msdn.microsoft.com/en-us/library/ms176060.aspx

--from BOL ~ slightly changed

ALTER USER Mary51 WITH DEFAULT_SCHEMA = dbo;

isdn't the core issue that the user is not using the default dbo schema, so , for example, the user "Orange" creates a table Orange.Invoices instead of the expected dbo.Invoices.

compatibility...

ALTER function [dbo].[udf_parseWidth](@strvalue varchar(500)) returns varchar as

in this case, a varchar with no size is a varchar(1)

explcitly change it to returns varchar(500) as or whatever you are expecting.

you might be...

datetimes should be kept in the database as datetimes...otherwise you get this kind of issue, where you have to convert it to datetime,a dn then convert it back out to...

you'll have to explain what the actual error message is...i cannot think of what an "inbound error" might be.

your query doesn't join sep5.V_ALERTS ti sep5,V_SEM_COMPUTER...so that's an ugly cross join...

Madhu-207721 (7/21/2011)

---

Dear,

Is there a database which supports richtext features ?

Scenario: I have a word template document with bookmarks.

I have database which stores the data for the bookmarks and other...

ananda.murugesan (7/21/2011)

---

Mr.Lowell,

thanks for reply..

In SQL server 2008 server machine Not available Ingress ODBC driver 3.0 or 9.2 etc.. I think Ingress odbc driver required in Ingress machine only. Not in...

yes exactly. DTS (well...

Procedures and functions(and triggers, if they exist) will have to be hand edited; there is no process that i've ever heard of that can convert procs and functions form...

from a post by Jeff Moden, where he showed the sneaky way to get rid of multiple repeating chars in a single pass;

this is replacing pound signs, but it should...

allamiro (7/20/2011)

---

OK great thanks for the script it diffidently great

However when you said the default is a so does that mean I will have 2 traces running ...

do you mean the default trace? for that, you can't, it's a black box...but you can script a copy of that same trace definition, modify THAT, and create a new...