In addition to what is posted above, SQL 2005 has new data types, functions, greater xml support, new availablity options, online index operations, online piecemeal restores, CLR support for custom...

NP, glad I could help.

and sqlserver is getting equipped with such a broad scale toolset,

it's getting hard to just know...

touche :smooooth:

I agree. Not much you can do in this situation. Anyway you look at it there is a potential risk of data loss....

In the itermin, you need to manually remove any transaction logs you do not need.

I am not quite sure I understand. Are you saying that you ran a transaction log backup and expected it to delete old transaction log files from disk? ...

I do not think there is a direct method via the standard viewer. You can use xp_errorlogreader to display the error log and filter out what you do not...

The easiest method would be to make a variable that evaulates as an expression. Your variable expression should look like this

"/out/export/" + RIGHT("0" + (DT_WSTR,2) datepart("d",Dateadd("dd", -1, GETDATE())),2)

Then in the...

NP, I am glad we got everything cleared up 🙂

I dont know about you, but I would want as much information as possible. I would display a few more columns.

SELECT

c.Table_Name,

c.Column_Name,

c.Data_Type,

c.character_maximum_length,

c.Numeric_Precision,

c.Numeric_scale,

c.Is_Nullable,

c.Column_Default,

c.Collation_Name

FROM INFORMATION_SCHEMA.COLUMNS c

INNER JOIN SYS.TABLES so

ON c.Table_Name = so.Name...

One on the biggest reasons to store the packages in the msdb database is you can leverage the new security roles. The roles grant security access to packages, without...

Why does it have to be not equal too? This goes against the purpose of the case statement. Case statements should evaluate to one option, not a multitude...

Okay. I have modified the query. It should produce the results you are looking for.

DECLARE @Attribute_Value TABLE(

Attribute_ID INT IDENTITY(1,1),

Attribute_name VARCHAR(25)

)

INSERT INTO @Attribute_Value (Attribute_name)

SELECT 'Allergy' UNION ALL

SELECT 'Internal...

I took this as a function to check if a table already exists....

There is no built in function but you could make one. You should use the infomation_schema view to validate.

if exists(

select 1

from information_schema.tables

where table_name = 'TableName')