I am a bit confused here. What do you mean EndDate = '1/1/2003' - startdate + Days? ...

Look at DBCC SHRINKFILE in BOL.

I'm not sure how that is similar, but here's this should be continued in your other post here:

http://www.sqlservercentral.com/Forums/Topic421242-338-1.aspx

Well Jeff, it looks like you've got another comparison between the new 2005 T-SQL options and good 'ol fashioned set based operations. Here's another great reason not to jump...

There may be some fancier way to do this in 2005 (or just some fancier way in general) but this should get you going in the right direction.

DECLARE @table TABLE...

Karim,

By explicit transaction, Jeff is asking if in you used the keywords BEGIN TRANSACTION prior to your update.

Please continue this thread here:

http://www.sqlservercentral.com/Forums/Topic419893-8-2.aspx

You've already set up the linked server right? From the error message, it looks like you have but I thought I'd check. If so, then this looks like...

sp_who2 will show all current connections to a SQL Server instance. Is this what you are looking for?

Not unless you can to what Happycat59 is suggesting, but from the sounds of your initial...

Using the strategy that you've posted, you can only recover up to every half hour. This means that if your database crashes at :29 past the hour (or :25...

I agree with Matt. I think the delete works well as designed and that there is already enough security measures built in. They could add a dialog that...

No, arrays are not supported. He is using a table variable and he just happened to use the word array in the table variable name. I would recommend...

If the stored procedure deletes all data from the table, why does it matter? Let's say that the first call is complete, 15 seconds go by, and then the...

Write a stored procedure that queries the table and aggregates requests for each user and generates one e-mail. Schedule the stored procedure to run at a set interval or...

But Books Build Character??? Maybe in a movie, but in real life. My opinion, it is a combination of our innate traits and environment. All the people we have...