Yes, it does do indexes as well. I guess I was just showing that it is not a simple alter table add column. I found all the steps...

Is there a specific set of parameters that cause the problem? What is the report doing? Are the parameters tied to datasets in the report?

I would try using...

When you add a column in SSMS in a certain position SSMS it does the following:

1. Finds all relationships and drops them.

2. Creates a new table tmp_tablename with...

Glad you like it Barry.

I have been doing a lot of research into Profiler and Tracing which is why many of my answers now include using that information.

The sp_lock stored procedure is a good starting point as would be sys.dm_tran_locks. Or if you like the GUI you can go to SSMS -> Management -> Activity Monitor and...

Chris,

First we need to understand that the DB Setting is basically meaningless as the connection or session setting overrides it and all the major means of connecting to SQL Server...

If the data type is varchar or nvarchar then SQL Server trims trailing blanks (spaces). If there were a tab or carriage return then it wouldn't trim it.

I have...

If you do it in SSMS and insert the column in the position you want it will work, but it DOES drop and re-create the table. To my knowledge,...

I don't think that there is any default way within SQL Server to identify this as the SQL Server itself just knows the User Name not Domain Group that is...

SSRS does not give you control over those properties in parameter lists.

According to Inside SQL Server 2005: T-SQL Querying the order of the items mentioned is:

1. FROM

2. WHERE

3. GROUP BY

4. SELECT

5. ORDER BY

The best way is to go out and get a compare product like RedGate's SQLCompare. Another option is to script the databases and use a text compare product like...

Why do you need to convert to a date? Do you you mean that the 01:30 should be converted to the current date at 1:30 am? Or do you...

You can use the sys.extended_properties view to get the information from extended properties. I believe the idea around extended properties is to give the database designer/developer a place to...

I'm not sure what you are asking. What you get from uniqueidentifiers is what they are. Can you be more specific about your question.