Remove the comma which is just before Primary Key Keyword.

Hi Karthi,

set

datefirst 1

Select

getdate() - (datepart(

Hi,

You can declare a global variable, and can assign some values if the process succfully done. While restarting you can compare the value.

The following simple query might solve your problem,

Select Name

From sysObjects

Where xtype = 'U'

and ObjectProperty(id,'isIndexed') = 0

and ObjectProperty(id,'TableHasPrimaryKey') = 0

Try it out using DTS.

If you need to use cursor, then go for static cursor, that will not open the table anyway. It uses tempdb for its process.

select convert(varchar(11),'27/09/2005 12:42:32 ',103)

Select convert(varchar(10),convert(datetime,'27/09/2005 12:42:32 ',103),108)

No, it is not linked server.

Have you refreshed?

Instead of bcp why dont you try Bulk Insert

Hi,

I think so this is not possible, because of the user who created the procedure becomes the owner of the object. As SQL server says, by default the owner will...

First you match the user login in both the servers.

CREATE FUNCTION udf_manufacturerName (@partNum varchar(50), @num INT) 

RETURNS varchar(50) AS 

BEGIN

DECLARE @manname varchar(50)

DECLARE names_cursor CURSOR static FOR

   SELECT  Manufacturer

   FROM    PartNumManufacturerNum

   WHERE  [Part Number] =...

Thanks for your reply.

Yes we can use sysusers. But User_id() will return always 1 if the currently logged in  user is dbo. Then the user name will be dbo,...

For some security reasons, i need to avoid the user who is the owner of the object once he created, that should not be dropped by any user in sql...