Viewing 15 posts - 39,181 through 39,195 (of 49,571 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic714850-150-1.aspx
May 12, 2009 at 6:38 am
All the rows in TableA that satisfy the join condition (ie have matching rows in TableB) will be deleted.
Basically, iy you replace DELETE FROM TableA with SELECT TableA.*, you'll see...
May 12, 2009 at 6:34 am
When you say 'failing', what do you mean? Is it not returning any rows? Is it giving a syntax error, and if so, what error?
What's the code supposed to do?
May 12, 2009 at 6:32 am
manolomalaga (5/12/2009)
Or make a job like this:
That's a very bad piece of advice (for anyone interested, the OP in the referenced thread wanted to delete the LDF daily)
Proper maintenance of...
May 12, 2009 at 6:26 am
Please run the following and post all the results here.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
May 12, 2009 at 1:36 am
RPSql (5/11/2009)
BackupIoRequest::WaitForIoCompletion: read failure on backup device 'E:\Data\abc.mdf'. Operating system error 23(Data error (cyclic...
May 12, 2009 at 1:36 am
Please read through this - Managing Transaction Logs[/url]
If you are backing it up and it's still growing too much, back it up more often.
May 12, 2009 at 1:32 am
Paul Randal (5/10/2009)
[Edit: thought I deleted this post right after I posted it]
Delete doesn't do anything anymore. Couple issues with people posting insults and then deleting the posts after others...
May 11, 2009 at 3:46 pm
Is the setting of the status succeeding? It may fail without throwing an error. Check the return code, is it 0?
May 11, 2009 at 2:28 pm
Table could have been created in a parent procedure. This, for eg, will work
CREATE PROCEDURE OuterProc
AS
CREATE TABLE #Temp (id INT)
INSERT INTO #Temp values (1)
EXEC InnerProc
GO
CREATE PROC...
May 11, 2009 at 2:27 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic714417-391-1.aspx
May 11, 2009 at 2:25 pm
Please post table definitions, sample data and desired output. I'm not 100% sure I follow what you want. Read this to see the best way to post this to get...
May 11, 2009 at 2:23 pm
Take a look at this article. http://www.sqlservercentral.com/articles/65804/ The fixes, if any, depends on the results of that command. I prefer not to speculate ahead of time.
It may not be...
May 11, 2009 at 2:12 pm
If you want a rant - http://sqlinthewild.co.za/index.php/2009/04/17/developers-vs-dbas/
May 11, 2009 at 2:09 pm
Gaby Abed (5/11/2009)
Ahhh...those were the days, I actually had an Enterprise technical manual and briefly had in my posession the Klingon/English dictionary.
But not anymore... (<-- he adds hastily) 😀
I...
May 11, 2009 at 2:08 pm
Viewing 15 posts - 39,181 through 39,195 (of 49,571 total)