Viewing 15 posts - 1,381 through 1,395 (of 1,584 total)
Have you tried using a TRY..CATCH block wrapped around the INSERT statement, this will allow you to do something after trapping/planning for the potential error, Ex:
BEGIN TRY
...
October 5, 2011 at 8:42 am
The problem i am having to create step 2 is that the stored proc is in a different server and the job runs on a different server. Can some...
October 5, 2011 at 8:37 am
Good timing on this article arriving in my inbox this morning, it references what Gianluca was referring to, also easy to set up (and is also free).
http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/
October 5, 2011 at 8:25 am
This is a question for Gail:
p.p.s. Filters belong in the WHERE clause, not the FROM clause. (unless doing outer joins and needing the filter before the join)
I was always instructed...
October 4, 2011 at 10:13 pm
Good points by Greg (esp. the SSIS route), but I would go with Stud's reccomendation. IMHO Transactional replication is the way to go...especially if you have a lot of...
October 4, 2011 at 10:01 pm
Very correct Paul.
And in the case above, they can't find the file specified via the mapped UNC path because of the missing "$" (admin share, which of course should never...
October 4, 2011 at 9:32 pm
SQL Server has a default "black box" trace that's turn on by default and tracks basic things (incredibly low overhead on the server, unlike creating your own traces from the...
October 4, 2011 at 8:25 pm
Unfortunately No, that's why I reccomended the reinstall (starts over brand-new then) - have you googled the error or check BOL???
October 4, 2011 at 3:00 pm
Do you have a profiler trace running?
October 4, 2011 at 2:59 pm
Clarify the database that everything was pointed to is missing? Which DB - ReportServer and ReportServerTempDB? Both? Or something else?
If you reinstall SQL itself, you'll lose everything....
October 4, 2011 at 2:53 pm
Do you have the option of reinstalling the SSRS from the disk?
October 4, 2011 at 2:29 pm
I can provide you with a free alternative to track:
- When
- Server
- Database
- Command issued (i.e. ALTER/DROP/CREATE, etc)
- Which Application was used
- spid
-...
October 4, 2011 at 2:07 pm
Jeff's function is by far the best (as many have already suggested) but if you can't create a scalar/table function you are going to be limited.
Not certain this will be...
October 4, 2011 at 1:18 pm
Yes I read your post thoroughly, and just wanted to make sure "how" you attempted to remove the space by adding the basic TSQL. I sincerely hope it did...
October 4, 2011 at 9:36 am
Is your DB in simple/full/or bulk-logged mode?
If not in simple mode, run a transaction log backup for the database you whacked the data from...you'll need to do this at some...
October 4, 2011 at 9:10 am
Viewing 15 posts - 1,381 through 1,395 (of 1,584 total)