message posted to http://www.sqlservercentral.com/forums/post.aspx?forumid=8&messageid=141298

how about WHERE CONVERT(VARCHAR(10), Removed, 101) >= DATEADD(DAY, CONVERT(VARCHAR(10), GETDATE(), 101)

as an example??

Mike,

I know now what you are talking about and I dont use the debugger in QA.  It just feels wrong (don't ask).  I generally write stored-procedures as TSQL code...

I just ran it like this:

EXEC testdate '2004-10-11'

Messages have been posted to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=140996

You can get the constraint name FROM sysobjects WHERE xtype = 'C' AND WHERE parent_obj =  the [id] FROM sysobjects WHERE [name] = 'WebRsLog'.

With this information you receive the different CONSTRAINT...

Research sp_addlogin in BOL

If you know the userid why not SELECT UserID, COUNT(*) FROM tableX GROUP BY UserID ??

You cant without using an ActiveX or Dynamic Properties object.  You would then have to use the above information for the parameter for the stored-procedure.

Without using the DTS objects I...

IF limiting the memory SQL can use to 1GB and CPU usage dropped is that a bad thing?

Research using parameters with Stored-Procedures in DTS.  You create the global variable and then in the Execute SQL task add parameter(s) as ?

Then add the parameter(s) in order on the...

What you can try (may not be the BEST idea) is:

DETACH the database, RENAME the log file, ATTACH the database and then try and shrink the LOG file (or try it...

Great solution David!  Never would have thought about stuff

Have you verified that you don't have garbage dates? they are actually dates?

You could reference sysobjects table (for table objects) and incorporate that with the ForEachDB (I have seen this posted here before don't remember exact syntax)  and build dynamic SQL to...