Viewing 15 posts - 4,291 through 4,305 (of 9,643 total)
I'm not getting that error for those snippets. Are there any other statements in the batch?
August 28, 2009 at 7:27 am
Okay, the main issues with triggers, in my opinion are:
1. Trigger code is "hidden". Unless you are the designer/developer you may forget to look for triggers.
2. Triggers...
August 28, 2009 at 7:21 am
Normally I'd recommend batching, but it depends on amount of data and other activity on the database(s). 20-30k rows are really not that many.
August 28, 2009 at 7:10 am
August 28, 2009 at 7:06 am
I believe, and it has been awhile, that printing directly from the report (wasn't supported in the original 2000 release at all) requires a printing control to be installed/added to...
August 27, 2009 at 8:34 am
How did you grant rights to the reports, via specific user or by AD group? If by group the best you can get without going out to AD is...
August 27, 2009 at 8:30 am
From BOL about Global Temp Tables:
Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the...
August 27, 2009 at 8:27 am
I think I understand what the trigger is supposed to do (not an ORACLE guy) so I think this is how I would do it in SQL Server. Definitely...
August 27, 2009 at 8:22 am
Okay, I'm looking at it, but while I'm looking at it I suggest you read this article[/url] as triggers perform differently in SQL Server than in Oracle.
August 27, 2009 at 7:53 am
Apparently you aren't the only one looking for this information. Here is a connect item about it being missing from documentation. I'd encourage you to vote on it...
August 27, 2009 at 7:40 am
Can you post what the solution was? It's great that it's solved, but I know I'd like to be able to help someone else if they have the same...
August 27, 2009 at 7:31 am
Wow, SQL Server not responding many times. Sounds like some major application issues. I'd start by setting up a PerfMon log, starting with the counters mentioned in...
August 27, 2009 at 7:29 am
What OS?
Do you have any third-party SQL Server tools installed like RedGate SQLToolbelt or addins to SSMS? These are just some guesses.
August 27, 2009 at 6:32 am
Thanks for posting the link Dan. May come in handy.
August 26, 2009 at 2:46 pm
Alvin Ramard (8/26/2009)
What's worse than OP too lazy to search how to do something simple and asking in the thread?OP that send you a PM asking the question.
I typically copy...
August 26, 2009 at 12:05 pm
Viewing 15 posts - 4,291 through 4,305 (of 9,643 total)