Viewing 15 posts - 781 through 795 (of 1,583 total)
I'll recheck one last time to be sure. I've got to ask: you did create the stored-procedure and are executing it correct?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2013 at 5:43 am
Really appreciate your quick responses. I'll again run that code of yours, onto other servers, and check the response. What about the e-mail part it should mail me, there is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 31, 2013 at 10:06 am
Won't this work (slightly different than what's posted)? - can't say I've ever noticed a count not equaling a select COUNT on a table directlySELECT ps.row_count
FROM sys.indexes AS i...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 31, 2013 at 9:24 am
Do you have any errors to report? I tested the code before I posted it, it does work fine - if there are no failed jobs on the server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 31, 2013 at 9:16 am
It should be quite simple to modify the code to execute against your linked servers...
Example:INSERT INTO #SQLAGENTERRORS
EXECUTE [LINKSERVER].MASTER..SP_EXECUTESQL @sqlSelect
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2013 at 12:36 pm
Thanks for the replies, I'll dig a tad further to see where it goes 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 1:05 pm
I see your point, but this table has nearly 700,000 rows, and in the execution plan it's using the non-clustered index (not the clustered).
If I drop the constraint altogether, it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 9:06 am
I would recommend transactional replication slightly customised so that the deletes don't replicate. This additionally gives you the ability to have different indexes on the reporting replica.
Sorry to hijack...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 9:01 am
Create a simple SSRS report (RDL file) and call the stored-procedure running this code, format the report to your liking. Reporting Services is pretty straightforward...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 7:44 am
This isn't "pretty" code but it works and will email you the results (I have it running hourly). I just set up a simple SQL Agent job on each...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 7:00 am
Try wrapping the string in double-quotes:
insert into [SS-PC1]..SCOTT.TABLE1 values('"This is test command"',100000);
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2013 at 6:55 am
I used to get this all the time due to having Redgate SQL Prompt installed, I uninstalled that software and SQL Server, reinstalled both pieces of software and the issue...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 6:15 pm
Alexander Suprun (1/28/2013)
ugo boy (1/28/2013)
I mean, if there are no searches done on the tablethen you should DROP these indexes.
Keep in mind these statistics are cumulative and only show...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 6:11 pm
Seems to be more of an issue with the precision you are setting with your decimal data type i.e. (9,2) - determine the maximum number of decimal places in the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 1:19 pm
Sounds like a data type conversion issue. Is the data you're selecting of the same type as the table being inserted into?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2013 at 1:09 pm
Viewing 15 posts - 781 through 795 (of 1,583 total)