Your NAT router hopefully has the capability to map ports directly to systems and ports behind it. If that's the case, you'd open a port on the NAT router and...

The SQL Query itself shouldn't cause this problem, nor technically should the ASP code you've given. Have you tried to turn buffering on to see if that makes a difference?...

If you're using SQL Server 7, then you don't have built-in cascading deletes. In that case you have a couple of options.

1) You build stored procedures to handle the deletes....

Microsoft PSS = Product Support Services. If you have a Premier agreement, you could start a ticket through the Premier Web Site but you should also contact your TAM. Otherwise:

http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a&sd=GN

If...

That's the nice thing about the Red Hat certifications. Much like the CCIE, there is a lab exam, meaning you have to demonstrate compentency with the actual product.

K. Brian Kelley,...

Was an application dump file created?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Try this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;814113

MS03-031 contains a fix that must be applied on each client computer.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Are you using transaction log backups or are sticking strictly to full/differential?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Do you want these as separate recordsets? Is that what you're looking to do? Or are you looking for them in a particular order as a single recordset?

K. Brian Kelley,...

Is there any indication as to why SQL Server Agent is stopping in the first place? What you may have to resort to is running a Task Scheduler job every...

Have you tried establishing a "permanent" linked server connection and referring to the Access DB by the four part naming convention in that manner?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish...

Temporary stored procedures with # are local and are visible only to the connection. Therefore, when you create the temp sproc, the connection can access it, even though you're using...

This only changes the names internally. It does not rename the instance so far as the Listener service is concerned (or so far as the OS is concerned). While it's...

Even though it may be in the cache, there may be reasons it incurs a recompile. If the execution plan looks to differ drastically from what's necessary for the new...

quote:

---

Certification lets me identify and improve on my weaknesses. It helps me answer those tough questions in the next job interview about...