Forum Replies Created

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

  • RE: SSIS Error Message HELP!

    At first blush, this was my thoughts too. Everything I've checked appears to be up to date. Any ideas on where I could check to make sure everything...

  • RE: Identity_column

    Actually the answer is "NONE OF THE ABOVE". The answer (deemed correct) refers to IDENTITY INSERT set to ON. This query will run if IDENTITY INSERT is set...

  • RE: Collation affects Indexes?

    Thanks John! This sounds like the makings of a good QotD!

    Cheers,

    Brian

  • RE: Collation affects Indexes?

    Thanks for the responses. That is what I thought would happen. I did read some more information after posting. It appears that changing the collation DOES NOT...

  • RE: T-SQL Help

    Here's one way to do this. This is using a CTE (assuming you're using 2005 or higher). If not, it is easy enough to wrap up as a...

  • RE: This should be a simple join

    That's the way a join works. Even though you may only have one batch number record in table 1, if table 2 has three records with that number, then...

  • RE: T-SQL - What is the output of the statement

    Your initial insert statement is incorrect.

    "Assume you have a SQLServer2005 database and that the table "tb_User" contains the user 'Assis Marques'"

    You need to modify the initial insert to be...

  • RE: nvarchar

    Since the abbreviation is "nvarchar" I can see National VARying CHARacter. How did it become National CHARacter VARying? If that was the case shouldn't it be ncharvar? I...

  • RE: T SQL

    I concur. The result set is (should be):

    Vyas Mohan ...

  • RE: Rename objects

    If you create a view and use the sp_rename stored proc you can rename it. This might be an error in BOL.

    Cheers,

    Brian

  • RE: Queries with Aggregate Functions

    The only reason you would need the three part name was if you were referencing a different database [DatabaseName].[SchemaName].[TableName] on the same instance. In this case HumanResource is the schema...

  • RE: Transparent Data Encryption (TDE) SQL Server 2008

    Good article. Nice and concise, with good points. BOL pointed this out in regards to the read-only file groups:

    While TDE operations are not allowed if the database has any...

  • RE: SELECT FUN

    From Microsoft: "The exact results of a UNION operation depend on the collation chosen during installation and the ORDER BY clause."

    http://msdn.microsoft.com/en-us/library/ms191141(SQL.90).aspx

    This is for SQL Server 2005. I'm...

  • RE: Error Severity

    Run this query on 2008 and tell me what you get back:

    SELECT MIN(severity),MAX(severity)

    FROM sys.sysmessages;

    That will give you your answer. Hint: 0 and 24. It's the same for...

  • RE: Read_Only Database

    I tried starting a 2000 SP3 Standard Edition with single user mode with no luck. DAC didn't come along until SQL 2005 so that wouldn't work. Is there...

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