Yes, this configuration is supported. See:

http://msdn.microsoft.com/en-us/library/ms143694.aspx

Add brackets whenever the name contains special characters:

select * from [WINSER2003-I].secls.dbo.employee

I'm not sure what you mean by removing all partitions. Do you want to drop the tables, or just rebuild them to make them non-partitioned?

In either case, you can use...

You cannot have a nvarchar(n) type where n exceeds 4000. the only way to store more than 8000 bytes is to use nvarchar(max). It is also not true that it...

The procedure will insert only one row every time it's called, and @@ROWCOUNT will be 1. If you want to insert multiple rows, you need to execute the procedure multiple...

You can query sys.table_types to get a list of all such types in a given database, and use column type_table_object_id in joins with other views (e.g. sys.columns) to get more...

If your parameters are varchar(max), you should have no problems passing values longer than 8000 bytes. Can you provide some information on how you call the procedure, and how it...

I'm not sure what you are trying to do. If you want to combine date and time into one value, there is no need to convert to string; you can...