Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bborissov
  • Content: Threads
  • Order by date
  1. bborissov

    SQL Server 2005 SP3 instalation problems

    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...
  2. bborissov

    Strange DB Statement after RESORE

    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...
  3. bborissov

    Why table scan?

    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...
  4. bborissov

    Is there anu wahy to to that better?

    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...
  5. bborissov

    DELETE during the transaction WAIT forever

    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...
  6. bborissov

    Is there a way to get rid of immediate resultsets?

    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...
  7. bborissov

    How to transfer DB created with SQL Server 2005 to 2000

    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...
  8. bborissov

    Execute a script stored in TEXT field

    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...
  9. bborissov

    Whit ONE select

    '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...
  10. bborissov

    Using a Notification Services

    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

Part and Inventory Search

Back
Top