Hello Ryan,

I didn't get you on the requirement but I thought that you need to get the date in yyyymmdd format or the month date, yyyy format.

If so, can you...

Hello John,

The statement given by you is syntactically wrong. It should be as

BULK Insert <database name> . <owner> . <table name> from <data file>

with (FIELDTERMINATOR = '/', DATAFILTYPE = {char...

Hello Suresh,

If you can take a look in the DTS package for the step "DTSStep_DTSTransferObjectsTask_10", you will find that the particular step is looking for the file to be tranfered...

Hello Rog,

You need to specify the alias name for the display_order column also. As it is from the "Comment_Table" it should be

Comment_Table.display_order is not null

Thanks and have a nice day!!!

Hello,

What do you mean by "secondary key"?

Do you mean another column to the table or a column to be added to an existing index?

Thanks

Hello Tim,

You can create the scripts by right clicking on the database and choosing tasks -> generate scripts. here you need to set either true or false based on your...

Hello Tom,

Can you try these lines by replacing them in your code:

SET @SQLStatement = 'SELECT DISTINCT members.ad_id FROM departments'

SET @SQLStatement =  @SQLStatement + ' WHERE departments.mgr_ad_id = ' +

Hello,

Search the forums for 'smtp' and you will get different threads.

Thanks and have a great day!!!

Hello Bill,

Can you try this one

sp_MSforeachtable @command1="select count(*) from ?"

Thanks and have a great day!!!

Hello,

It is a user-defined error number. Check up your code in stored procedures.

Thanks and have a great day!!!

Hello Natalie,

I have checked by executing the code and it is working fine.

Thanks and have a great day!!!

What is the datatype of the year field? if it is either int / smallint then you can default it like this

default datepart(yy,getdate())

Thanks and have a nice day!!!

Hello Alain,

timestamp is a  data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping...

Hello,

You have not mentioned whether you are adding a linked server of a SQL default or named instance.

[ @srvproduct = ] 'product_name'

Is the product name of the OLE DB...

Hello Patrick,

Please go through this link

http://msdn2.microsoft.com/en-us/library/ms189625.aspx

It might give you the work out.

Thanks and have a great day!!!