When reviewing an issue through the Replication Monitor, the error messaging was leaving me wanting more detail to find out why the replication process was failing. So my question is, is there a way to garner more information from the replication agents running via SQL Server Agent?
2009-02-18
2,346 reads
How to Extract Error Description in SQL Server 2000 based on Error Number
2009-01-13
7,473 reads
Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.
2008-07-07
9,226 reads
A look at how you can implement error handling in your stored procedures.
2008-04-03
4,813 reads
Ok, I missed that MSDE uses its 'mixed mode authentication' which means that administrators on a windows machine automatically get access to the DBMS. But you should be able to turn of this by removing the BUILTIN\Administrators login from the sysadmin group or remove it (I haven't tried this myself, I got it from http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22) […]
2004-10-07
I think it's not a tricky question... it's simply a bad question, again.
2004-08-18
- Wach out for the code used in sub-SPsIF @ReturnVal = NULL SET @ReturnVal = 0use IF @ReturnVal IS NULL SET @ReturnVal = 0 or SET @ReturnVal = ISNULL(@ReturnVal, 0)Also, use output parameter to return value from the SP. RETURN is supposed to be used for status code only. Even better - use function instead.- Create […]
2004-08-04
There are several ways to do this.1. You can just backup/restore the msdb database. This will migrate all jobs and DTS packages to the other server. 2. You can click on each of the DTS packages and save as a Structured File. You can then copy them wherever you want them (SourceSafe for example would be […]
2004-07-17
Hello all,I presently have a SQL Server supplying data using ADO.Net and query strings through a designated SQL port (opened on my Cisco Pix firewall) to an IIS server running my ASP.Net applications and then exposing it all to the web.I want to be able to expose PDF files with the SQL Server that's on this […]
2004-06-11
3 reads
I have a DTS set up which checks the status of a process and sends an alert to a user if a certain condition is met.Each run checks the condition against a global variable, and when complete, updates the global variable with the new value.For example: GV1 was preset to "SUCCESS", after very first run, […]
2004-05-24
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers