Was this resolved?

When partitioning a clustered index, the clustering key must contain the partitioning column. When partitioning a nonunique clustered index, and the partitioning column is not explicitly specified in the clustering...

Use--> sqlcmd -Sservername

http://syntaxhelp.com/SQLServer/SQLCMD

You can only grant select, insert,update and delete permission on a view. So, don't make use of alter and view...

Please share the resolution.

MJ

Sudhakar,

Its nicely demonstrated(with code) at http://www.dotnetjohn.com/articles.aspx?articleid=157

Sending SQL Server Notifications with CDOSYS...

HTH!

Manu

Thanks for sharing the solution.

Found this on this excellent forum. Try it. Thanks to author.

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim conServer

Dim fso

Dim iFile

Dim oJB

Dim strJob

Dim strFilename

Const ioModeAppend = 8

Set conServer = CreateObject("SQLDMO.SQLServer")

conServer.LoginSecure =...

I am on the same page as Bryan.

Execute drop just after running the kill connections script.

declare @spid smallint

declare @cmd varchar(20)

declare spid_cursor cursor for

select spid from master.dbo.sysprocesses

where dbid=db_id('enter dbname here')

OPEN spid_cursor

FETCH NEXT FROM spid_cursor

INTO @spid

WHILE...

Could you please post the contents of csvtest.txt.

Please post the table definition here(along with constraints info, if any). Also, check for any triggers(especially insert triggers) on that table.

http://ask.sqlservercentral.com/questions/3638/steps-to-move-server-from-one-domain-into-another

BP-503183 (5/14/2010)

---

You can use .NET to read each of the DTS packages and create a summary of the package including connections and code using the Microsoft DTS Com objects. ...

Declare @num int

Set @num = 1 -- force it into loop first time (or could do count of no of records to be deleted ) ...