I have several ASP.NET applications deployed in a farm of 4 Windows 2003 machines. Each application uses a separate App Pool and Virtual Directory in IIS. They rely heavily on sessions which are persisted out of process on a single SQL Server 2000 (<sessionstate mode="sqlserver" ... />). Applications are compiled against .NET 3.0 but .NET 3.5 SP1 is installed on servers.
You make a gaming website where the user can buy gaming credits and the funds are deposited/credited into the user’s virtual account to play some game etc…etc..
I am building an asp.net application, using II6 on windows server 2003 (vps hosting).
I am confronted with an error I didn’t receive on my development machine (windows 7, iis 7.5, 64 bit).
I have a query from a web site that takes 15-30 seconds while the same query runs in .5 seconds from SQL Server Management studio. I cannot see any locking issues using SQL Profiler, nor can I reproduce the delay manually from SSMS. A week ago, I detached and reattached the database which seemed to miraculously fix the problem. Today when the problem reared its ugly head again, I tried merely rebuilding the indexes. This also fixed the problem. However, I don’t think it’s necessarily an index problem since the indexes wouldn’t be automatically rebuilt on a simple detach/attach, to my knowledge.
I’m writing a stored procedure that currently contains only a SELECT query. It will be expanded to do a number of other things, which is why it has to be a stored procedure, but for now, it is a simple query.
I know that using LocalDb is very good and easy for developement, I wonder if it’s good idea to use it in production when I host websites on IIS server?
I’m using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records.
Previously for all our asp.net applications we have been using a sysadmin user within SQL Server to connect and add/update/delete/get data. Our SQL Admin wants to delete that account and create a Domain Account so we can use that account within our .net applications.
I have an entity Report whose values I want to insert into a database table. The following attributes of Report have to be inserted:
Hi I’m getting the error