Mark Eytcheson (6/29/2009)

---

I usually create two datasets:

1. StartDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-9, 101)) AS DATETIME) AS StartDate

2. EndDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-2, 101) + ' 23:59:59') AS DATETIME) AS EndDate

Then set the parameters @StartDate...

You already have a thread for this here.

Please post any responses on thread linked above.

Rod at work (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

Why not just restore the latest backup as a new database? It may not be current, ie up to the minute, but it would...

You can't modify the structure or content of the system tables.

1. Yes

2. Read Books Online (the SQL Server Help System). You can access it from SSMS (SQL Server Management Studio) by pressing the {F1} function key.

Curious, but shouldn't this:

DECLARE noteID_curs CURSOR FOR

Select NoteID from BugNotes where BugID=@IncidentID and ProjectID=@ProjectID

come after this:

Select @ProjectID = (Select ProjectID from Inserted)

Select @IncidentID = (Select BugID from Inserted)

??

And Absolute Power corrupts Absolutely! 😉

I am assuming you are attempting to connect from a separate system. What version of SQL Server was installed?

Why not just restore the latest backup as a new database? It may not be current, ie up to the minute, but it would be close.

You can't.

AARRRGGGG!!!

When will people learn to read???

exec sp_password @new = 'password', @loginname = 'username'

Krasavita (6/29/2009)

---

It means that you aren't properly managing the size of your database files more or less. Your database files are set to autogrow to prevent the database from running...

How about a single XML...

No,...