Is there anything Special that I need to do within my .NET code to force the issue of keeping the tags in place? Or by default, will they be there?...

I would suggest that you install SQL Server, and use the SQL Books Online. There are so many great examples and tutorials. Then create yourself a project and start working...

I tried that, but still the same. I found some other colors come from the OS. But I cannot seem to find the place to modify this color.

Andrew SQLDBA

Thanks Everyone

I am using the ALTER DATABASE code. Much more simple, and NO cursors:w00t:

I wish we could dis-invent the cursor:-D

Andrew SQLDBA

Thank You

I was trying to go about that the long way around of taking each part and concatenating it back together and then cast it to the correct data type.

Thanks...

I did find that changing the Windows tooltip color, that is changes the background color of any NULL value in SSMS. A long way around, but I am using 2008R2...

I knew that as soon as I posted this question, I would find the answer in the BOL

read about "sys.dm_sql_referenced_entities" in the BOL

Thanks

Andrew SQLDBA

Thanks Gail

Greatly appreciate it. Just needed to make certain before executing

Andrew SQLDBA

Thanks Gail and Steve

So I can shrink that logs without messing up the LSNs? How can I shrink the logs without putting the database into simple recovery mode?

Or am I...

Thank You to Everyone for all the great advice. Always learn something when I post here.

Have a good one

Andrew SQLDBA

I think what is really making this more difficult for me is that the second delimiter is a blank space. I am not wrapping my head around that easily. There...

You mean that I cannot have both? 😀

Fast of course. I take it if I want fast I should follow what was first sent.

Andrew SQLDBA

Do what?

I was hoping for something a little more simple that what is shown on that page.

Thanks

Andrew SQLDBA

Thank You everyone. I appreciate the input. I have not had an issue before myself either. But I always like to get another opinion before beginning.

I just noticed that I...

That is what I have been reading, but I am not sure how to code things like that. I can use C#, but then it is not in SQL, and...