Forum Replies Created

Viewing 15 posts - 46 through 60 (of 131 total)

  • RE: Back up of selected dbs

    Thanks Pradeep and Atul.

    I am checking this options. It's very interesting to study these materials. I am lot of points.

    I didn't get answer for my second question.

    To restore...

    March 23, 2009 at 6:28 am

    #964355

  • RE: Problem with trigger

    Mike John (3/19/2009)

    I think you may have spotted it. The trigger will indeed fire when zero rows are retrived in the example you post. Triggers always fire once per statement...

    March 19, 2009 at 6:12 am

    #962611

  • RE: Problem with trigger

    christine.dsouza (3/18/2009)

    Looking at the insert statement the empId comes from t_EmpID on your holding table and not the identity column empID.

    Then deal with the NULL value in whatever way is...

    March 19, 2009 at 12:03 am

    #962494

  • RE: SQL Server Express addition

    Florian Reischl (3/18/2009)

    Hi Venki

    No silly question 😉

    Just execute following line in SQL Server Management Studio (or Query Analyzer):

    PRINT @@VERSION

    Greets

    Flo

    Thanks a lot Flo.

    March 18, 2009 at 11:48 pm

    #962492

  • RE: Problem with trigger

    Mike John (3/18/2009)

    The trigger as you have it (ie FOR INSERTED) is an after trigger and logically happens AFTER the update has been done, (but before the transaction has been...

    March 18, 2009 at 9:10 am

    #961996

  • RE: Problem with trigger

    Mike John (3/18/2009)

    Two things I think you need to do

    a) Get the trigger changed to properly handle multiple rows in one statement. Lots of examples are around..

    b) Your code is...

    March 18, 2009 at 7:51 am

    #961885

  • RE: Problem with trigger

    Florian Reischl (3/18/2009)

    Hello Venki

    Seems that the trigger tries to write incorrect data into table "Dept.dbo.department". Can you post the trigger source?

    Greets

    Flo

    Nothing, trigger simply takes the data into a variable from...

    March 18, 2009 at 7:12 am

    #961813

  • RE: SQL Server Express addition

    Florian Reischl (3/18/2009)

    Here you can see a comparsion of SQL Server 2005 versions:

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

    I would advice to ask your manager for the Developer Edition. Here is the pricing:

    http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

    ... it contains all...

    March 18, 2009 at 5:38 am

    #961726

  • RE: Create database using Backup file

    Krishna (3/17/2009)

    No, not through backup and restore method, instead you can script out your 2005 database and then run it against your 2000 server.

    Thanks a lot Krishna.

    I am thinking...

    March 17, 2009 at 8:17 am

    #961064

  • RE: Create database using Backup file

    Sorry,

    I haven't seen the next page.

    Yes, you are right, it is my mistake, not to tell the back up file is from 2005. But I thought this versioning won't...

    March 17, 2009 at 8:14 am

    #961058

  • RE: Create database using Backup file

    Adiga (3/17/2009)

    You cannot restore a SQL Server 2005 database backup to SQL Server 2000.

    Pradeep Thanks again for your clarifications.

    Is it possible to transfer the database directly from 2005 server to...

    March 17, 2009 at 8:07 am

    #961049

  • RE: memory problem while sending mail

    Adiga (3/17/2009)

    It had also mentioned about checking the "Database growth" settings. Please check the same on the Database in question and the tempdb.

    Thanks Pradeep. Will check and update on this.

    March 17, 2009 at 8:00 am

    #961040

  • RE: memory problem while sending mail

    Adiga (3/17/2009)

    You may find this article on SSC useful.

    Thanks for your reply pradeep. I checked that link of Hot fixes before posting this question to you. But mine is not...

    March 17, 2009 at 2:49 am

    #960866

  • RE: Create database using Backup file

    I am getting the following error while doing restore operation through SSMS.

    Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADER ONLY is terminating abnormally...

    March 16, 2009 at 7:16 am

    #960187

  • RE: run SSIS from SP?

    Thanks for your reply.

    It seems I am getting info after lookng into Books online.

    March 6, 2009 at 5:33 am

    #954777

Viewing 15 posts - 46 through 60 (of 131 total)