Hi Anitha

I don't think there is a build-in functionality available.

Greets

Flo

Hi

Did you ensure that TCP/IP and Named Pipes are activated on your SQL Server? Go to "SQL SErver Configuration Manager" -> "SQL Server Network Configuration" -> "Protocols for MSSQLSERVER" and...

SELECT CONVERT(CHAR(2), GETDATE(), 1)

Hi Jeffrey

I'm no SSIS pro but your file looks like a usual CSV (except the trailing spaces). I just took your file, added a "Flat File Source" and specified:

Format: Delimited

Text...

SSE2k is some month away but I think you can use a T-SQL job which checks the sysfiles and raises an error when your determined size was reached.

Hi

I'm also a C# developer.

As first your initial question. If you still trying to use your CLR trigger I would suggest to request the column names again and again whenever...

Not yet in our company. For sure, we have backups! We take them...

RBarryYoung (5/15/2009)

It doesn't seem to be doing that on my system:

--========

declare @s-2 varchar(30)

declare @t varchar(30)

set @s-2 = 'K ...

In this case you have to use SQL Server authentication.

To simplify the server-switch and database naming problems some possibilities:

To handle a possible switch of the database to another server we...

Yep. File management is also a nice approach done by CLR. Another one is all those OLE-Automation things instead of sp_OACreate. Hube binary conversions or network conversations like http-requests.

There are...

Hi

I hope I understood your question... :ermm:

It depends (as always).

If your complete application is very large and you are working with different developer teams (maybe in different locations) the separated...

Hi

If possible I would suggest to use windows authentication.

An encrypted connection string seems to be a good approach. You should not store user/password on client side. Store only server/database information...

CLR is a great feature for things like string splitting. Anyway, there are quiet rare reasons to work with CLR in SQL Server since the integration is not better than...

Sounds like a normalization problem. What about a description table with a foreign key and a sequence instead of concatenated multi-value column? You will run into huge performance issues if...

Hi Tara

Two reasons:

1.) You configured "Minimum server memory" and "Maximum server memory" to same value.

2.) SQL Server needs (or needed once) for some reason. Memory allocation and freeing takes too...