Viewing 15 posts - 2,011 through 2,025 (of 3,232 total)
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
November 12, 2007 at 4:20 pm
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...
November 12, 2007 at 3:59 pm
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...
November 12, 2007 at 3:44 pm
Karim,
By explicit transaction, Jeff is asking if in you used the keywords BEGIN TRANSACTION prior to your update.
Please continue this thread here:
November 9, 2007 at 3:21 pm
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...
November 8, 2007 at 4:47 pm
sp_who2 will show all current connections to a SQL Server instance. Is this what you are looking for?
November 7, 2007 at 11:54 am
Austin_123 (11/6/2007)
Thanks John,So according to you I'll not able to recover last 25 min data
Regards,
Austin
Not unless you can to what Happycat59 is suggesting, but from the sounds of your initial...
November 7, 2007 at 7:42 am
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...
November 6, 2007 at 4:20 pm
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...
November 6, 2007 at 4:02 pm
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...
October 31, 2007 at 10:08 pm
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...
October 18, 2007 at 9:13 am
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...
October 18, 2007 at 9:05 am
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...
October 17, 2007 at 8:20 am
INSERT INTO TableA
SELECT * FROM TableB
October 12, 2007 at 4:22 pm
Viewing 15 posts - 2,011 through 2,025 (of 3,232 total)