Viewing 15 posts - 3,766 through 3,780 (of 6,105 total)
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...
December 21, 2003 at 5:11 pm
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?...
December 21, 2003 at 5:07 pm
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....
December 21, 2003 at 5:02 pm
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...
December 19, 2003 at 9:08 pm
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,...
December 19, 2003 at 6:29 pm
Was an application dump file created?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
December 19, 2003 at 6:27 pm
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
December 19, 2003 at 2:46 pm
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
December 19, 2003 at 12:38 pm
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,...
December 19, 2003 at 12:36 pm
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...
December 19, 2003 at 12:34 pm
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...
December 19, 2003 at 12:08 pm
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...
December 19, 2003 at 12:06 pm
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...
December 19, 2003 at 12:01 pm
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...
December 19, 2003 at 11:45 am
quote:
Certification lets me identify and improve on my weaknesses. It helps me answer those tough questions in the next job interview about...
December 19, 2003 at 8:44 am
Viewing 15 posts - 3,766 through 3,780 (of 6,105 total)