I have an ASP.NET web app running on a remote server drawing data from a remote SQL Server 2000. I have a local server on which I want to intstall...
Hi Experts! I have a question about triggers. I have a stored procedure that I call from an ASP page that can take a longer amount of time than...
OK, I have some questions about licensing of SQL Server 2000. I'm currently with a web host and want drop the monthly expense for having SQL Server...
Hi All, I've discovered that my server has been compromised and I believe it came through SQL server. I see in my application event log that the...
Hi All, I need to do an update on a large number of records in a table. The records to update are determined by the value of a 'groupID' column in...
Why will this query not find any indexs? select (select Points from scoring s1 WHERE s1.userID=s.userid AND s1.weekNum=1),...
I'm trying to use DTS to copy all data/objects/SPs/views to a different server, basically copying the production data to my development box to update...
Hi Experts!<br /><br />Here is my situation:<br /><br />Earlier today, I had an issue where a particular stored procedure was timing out when called...
Hi All! I have a situation where I have a page that is filled with data from my database using a stored procedure. Once the page is generated, it...
Hi All! I have a web site with seasonal traffic currently in the 'off-season' right now so my traffic has died down significantly, almost to...
Hi All! I'm having some blocking issues I think. During the course of today, I started getting this error: Server: Msg 1204, Level 19, State 1,...
Hi All, In my SQL Server Logs, I'm getting periods of time where this messages appears: Login failed for user 'sa' multiplie times within minutes....
Hi All, My site has been running on a dedicated PIII 1.1GHz 512MB RAM 40GB IDE Win2K server connecting to a shared MS SQL 2000 server. My IIS...
Separate names with a comma.
