Just a quick question; would using asp/html, sql-server stored procedures and the sql-server be considered as a 3-layer structure?? -- Frettmaestro...
Do I really have to make this into a dynamic sql to get it to work?? ->declare @search varchar(30) -- Method 1: doesn't work set @search = '%up%'...
In my database I have a table called "users" with a varchar-field that holds categori-id's commaseparated, collected from my other table "category"....
I have an app that uses exchangerates for different currencies that get updated once every day at 3pm from the european central bank. The...
I thaught I would ease my lazy self off the "hassle" of going through the job history every day and try to get sql-server to send me an email if a...
I have an asp-page that calls an sp with a select, and dumps it out on a webpage. Plain and simple. The weird thing is that when I run the asp-page...
I have recently had some deadlocking-problems in my database and I have come to belive that it is because of a cursor that is open a bit long. I...
I have never used trace flags before so I have a few questions:<br /><br />1. Do I need to restart the sql-server service to have them work? I just...
I have a somewhat intense webapplication that needs a very rapid refresh of data, imagine a stock market where data changes constantly and I need to...
Hello, my company will in the near future launch an advertising campaign for our website that hopefully will increase our traffic 6-10 times from...
Hello people, I have a simple messaging system on my website where users can send support-messages and such to the site administrators. Messages...
In IIS there is a possibility to save the webserver traffic-logs directly to an odbc datasource such as SQL server 2000. Do any of you guys have...
Is it possible to find out when a stored procedure was last updated? I'm struggeling again and again to deploy my sp's from test to production after...
Last night I had the unpleasant experience of doing a point in time restore of a production database for the first time in my life. Unprepared as I...
I've been having the classic problem of not beeing structured enaugh in my work to document the changes I do in the test-database so when the time...
Is it possible/will it cause any problems to change recovery model on the fly for a production database? -- Frettmaestro "Real programmers don't...
I need to generate 370 million rows in a table. Are there any special tricks I should know about to do this or can I just create a while-loop and...
I have a somewhat deep select with 9 joins total and one of them beeing a table-variable. It works just fine but when I try to add WITH (NOLOCK) I...
Geniouses; I need to run a stored procedure with some parameters at a specific time and it only needs to run once. All parameters and the time is...
Is there a function in T-sql that works in the same manner as the SUM() but multiplies the values in the statement instead of adding them together?...
Separate names with a comma.
