Search results for query: *

A friend of mine has installation problems when she tries to install Service Pack 3 for SQL Server 2005 64x. OS: Windows Server 2003 R2 64 Here the end of the log file: ... 07/03/2012 11:10:14.041 Installing product: Redist9 07/03/2012 11:10:14.041 Installing instance: Setup Support Files...

After restoring a Backup from our Application the BD stays in some strange state. Nothing could be done with it and the error message is "DB is still restoring (or something like this). Even with SSMS I only could drop DB, create a new one and then restore the backup. The strangest thing is that...

I don't get it. Maybe I missing something very obvious or I didn't read this part of BOL, but almost same queries give me different results in execution plan. In one table I have PK clustered, in other I have regular index. When I execute first query execution plan shows INDEX SEEK when I...

A fellow forum man, ask a question about SQL Query. Unfortunately I was not able to give a good him. Here is the data and the query he uses: DECLARE @Temp TABLE (Id int, Date datetime, Rate float) INSERT INTO @Temp VALUES (1,'1/1/2007',1) INSERT INTO @Temp VALUES (2,'1/2/2007',1) INSERT INTO...

I am not sure if this is the right forum to ask, but because I am not an administrator and want to handle this from my program I'll ask here :-) So the question: In simple: I crated two connections to the server bot opened transaction to one table and insert records in it. BEFORE COMMIT (or...

Here's the problem. I have two SP. I use both of them in my frontend, In my second SP I execute first one, but only want its return value, w/o created recorddset to be returned to the fronend. I know that I can redirect output to TEMP TABLE, send parameter to first SP just to calculate, but I...

I know, I know, I look stupid, but... I gracefully created one DB on my computer with SQL Management studio. Put all what I need in it and after I sit back to enjoy my work I realize that instead on SQL Server 2000 I created it on SQL Server 2005 instance. I changed compatibility level of this...

Have a table with one Text field. I used it to store a whole script for creating a DataBase, becuase a Script is very long (more than 120K) how could I execute it w/o using several variables? Is there a way to execute it. I want this because the name of the DB is different each time and I must...

've been asked it is possible to do this with ONE SELECT. First I answered NO, but here is about 2 PM and my mind doesn't works properly, so ask you :-) Here the conditions: The database is a bug tracking database. Table has several columns: bugID, open_date, close_date A bug is considered open...

Did somebody use notification services for Desktop application? I am lost in their documenation :-) Can somebody point me how can I setting up my application to receive events when some tables of my DataBase have changed? Thanks in advance. Borislav Borissov