SeanLange (9/22/2010)

---

Did you notice that in your second query you are looking at a different column in the where clause?

What is the datatype of your OrderDate column? Some table...

Not sure how, but I double posted. Please use this link for the post.

http://www.sqlservercentral.com/Forums/Topic991105-149-1.aspx

Robert, I also have the same question. For us, it isn't just about development. We currently have 3 reporting technologies within our system. Crystal and two home grown...

For what you are looking at, I use perfmon to capture the server stats and i have a job that runs once a month to capture actual MDF/LDF/NDF growth on...

Also note that the log file growth will be truncate during your next full or transaction log backup thereby allowing you to reuse the space for the next rebuild or...

Wow, who would have thought that the Compact Ed would use different sytax for this. Crazy.

Fraggle.

I believe the actual format is something like this:

ALTER TABLE Table1

ADD CONSTRAINT Cont_XYZ DEFAULT('hello') for Column1

Fraggle

This will give you a good start. Include the sp_sendmail if the backups haven't occured in the time frame you wanted and sql server will generate you a very...

Paul,

That works perfect. Thank you very much. That will solve the problem.

Fraggle.

Grant, yes I am sure I am in 2005. The only columns I see are as follows.

SELECT top 10 *

FROM sys.procedures

Returns the following:

Name

Object_id

Principal_id

Schema_id

Parent_Object_id

Type

Type_desc

create_date

modify_date

is_ms_shipped

is_published

is_schema_published

is_auto_executed

is_execution_replicated

is_repl_serializable_only

skips_repl_constraints

Nothing in that list for ANSI_NULLS...

Grant,

Sorry, still not seeing it. Must be going blind or something. Sorry to keep pestering you about it.

Fraggle.

Grant,

I believe I must be blind as I don't see it in that specific system view. Is it being called something else. Note that I am using 2005...

GilaMonster (6/21/2010)

---

What's in the error log is just the short stack dump. Got the .mdmp file? That's the full stack dump that you would open in a debugger (assuming that...

Yea, trying to avoid it as my manager doesn't really want to spend the money and will probably ask why bother if I can still read the error log in...

The final goal is to change the password so I can, but I got a funny feeling there is still stuff out there that is relying on the SA password....