Forum Replies Created

Viewing 15 posts - 23,011 through 23,025 (of 39,936 total)

  • RE: text field in insert trigger

    I don't believe there is a workaround. The CREATE TRIGGER documentation says not text/ntext types.

    What are you trying to accomplish?

  • RE: Sql Server installation

    SQL server only runs on Windows. You cannot install it on any other OS. It can be Windows Mobile/CE to Data Center server and everything in between, but it will...

  • RE: break down into hours, minutes and seconds

    You'll need to use a CASE with LEN to determine what the places mean. Then the SUBSTRING to split out the items.

    The issue is that if you have

    1101

    is that 1:10:01...

  • RE: text field in insert trigger

    Move to varchar(max) as a data type.

  • RE: Take a Seat

    That's a great idea for recruitment at growing companies, but not so good at larger ones. However larger ones could make a deal with a used furniture company to swap...

  • RE: Virtualization Hints

    One thing I'd mention that came up with a friend yesterday. Be sure that your help desk, sys admins, etc. know where the VM exists on a physical host. Someone...

  • RE: SIMPLE Full Backup Fails

    No it definitely sounds strange.

    If you can make the test, what if you delete your 7GB backup and then run the job? Does it work?

    I'm reaching here, testing different things.

  • RE: Take a Seat

    I'm with Gus. Go test them out, take a book, spend 15 minutes (at least) in each one you like. Maybe bring a laptop, type a little, get a feel...

  • RE: dts

    http://www.sqldts.com

    There are also many articles on this site.

  • RE: Not able to install SQL Server 2000 Boks Online

    It should install. It runs on the Microsoft help platform, but there might be components from the client tools it is expecting. Do you have the 2000 client tools installed?

  • RE: Over-Engineering

    Jack has it pretty close. Developers also focus or worry about things that may or may not be what is needed by the client. That's natural, we have a different...

  • RE: SIMPLE Full Backup Fails

    It's a simple OS error reported to SQL. Either the account has a quota limitation or there truly is not enough space. If you manually run the backup yourself, does...

  • RE: Dynamically adding columns

    I agree. It doesn't appear that you understand how SQL Server is optimized.

    coding for:

    ID Make Model Color

    --- ------ -------...

  • RE: transaction test!

    I think this is great behavior. Allows you to easily log things that might happen in a transaction that needs to roll back. If you used a permanent table, your...

  • RE: Clustering

    You can mirror the databases between sites.

Viewing 15 posts - 23,011 through 23,025 (of 39,936 total)