Forum Replies Created

Viewing 15 posts - 1 through 15 (of 66 total)

  • RE: trigger help

    Hi that worked but i have to make some more changes

    can i do if testkey exist then ony update the timestamp = getdate() else insert?

    create

  • RE: Immediate need for a good SQL Server 2005 DBA/Developer-type for a db optimization job

    Hi Joe,

    How are you! if you haven't selected the person to help. I am willing to help also.

    my contact info is db_dba2006@hotmail.com

     

    Thanks

  • RE: union problem

    i still get same result

    0.00            1920.96 19

    159761.82     0.00      19

    136151.20     0.00      23

    0.00             2178.57  23

    0.00             15.08       27  <--

    116061.63      0.00        27

    I want is like

    159761.82    1920.96    19

    136151.20     2178.57      23

    116061.63      15.08        27

  • RE: union problem

    hi if i try doing is gruping at last quiery in union i get

    is invalid in the select list because it is not contained in either an aggregate

    data...

  • RE: nested procedure error

    bellow is the code

    ALTER TRIGGER [dbo].[updateOnErrors] ON [dbo].[bandwidth]

    FOR UPDATE

    AS

    SET NOCOUNT ON

    DECLARE @thisAdd VARCHAR(15),

    @thisDIR VARCHAR(50),

    @thisFN VARCHAR(50),

    @thisQ VARCHAR(10),

    @thisSer VARCHAR(10),

    @thistest VARCHAR(50),

    @thisNumber INT,

    @firstIP INT,

    @SecondIP INT,

    @ThirdIP INT

    SELECT @thisAdd = i.ipAddress, @thisNumber = i.errorNumber

    FROM...

  • RE: result

    that way it does not work either. I need to get result in one line fro both view and procedure. Is it possible if i create cursor?

     

    Thanks

  • RE: Transfer USer

    I tried creating script on SQL 200 and then run on 2005 but it gives me error for

    Password validation failed. The password does not meet Windows policy requirements...

  • RE: scheduling SQL server to restart

    but how can i schedule that so it can run automatically. Also Agent is dependent on that.

  • RE: scheduling SQL server to restart

    I have to restart it due to some billing batch and also web app too .

    to schedule it from Windows scheduled task What do i have to do? I...

  • RE: Maintenance Plan Failes

    yes. It is valid with full rights to read and write.

     

    thanks

  • RE: Creating a PDF from a Stored Procedure

    Hi How can i check if "use Windows NT fibers" setting up  in my SQL server 2000 Ent. Edition?

     

  • RE: Log Shipping Problem!! help!!urgent!!!!

    i check the permission but everything looks fine to me and on top of that the copy and restore job works perfectly fine and all the changes also goes through so...

  • RE: Log Shipping Problem!! help!!urgent!!!!

    Can i change to SQL log on now? if so then how!!!?

     

    Thanks

  • RE: Exporting db schema to Visio or something similiar

    use reverse engineering on visio data diagram it will give you all the schema such as FK relation ship and details too.

  • RE: Server wont''''s start? urgetn plz

    I am missing that drive!! so how can i put new temp db file from another db server and also can i re direct it so can server get restarted!!

     

    Thanks

Viewing 15 posts - 1 through 15 (of 66 total)