Write a vbScript or power shell script to create a FTP script file and invoke http://FTP.exe on the file. You will need to set up the FTP site...

Although it is deprecated, the DBCC DBREINDEX should work.

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=474589

Robin HC

maybe ...

[font="Courier New"]set @strSQL='SELECT POL_NO AS ''Policy''

,Name

,AGY_NO AS ''Agency''

,Initials

,cast(Code as varchar(' + cast(@CodeLen as varchar) + ')) AS ''Code'' --ERROR

,Method

,createdOn AS ''Received Date''

FROM History_temp'[/font]

Will you script out your trigger code so I can have a look at it? Also, you could put something simple in the top of the trigger too eliminate...

How does the application authenticate to the database?  Perhaps you are authenticating as some other users that does not have execute rights to the xp_sendmail stored procedure.

I want the developer of the package to be able to connect to the integration server from his desktop and monitor the processing of the...

Brian

Who is the owner when you use ".." like the example?

CREATE VIEW dbo.agencytest

SELECT

account_id,

language_cd,

last_update_ts

FROM dbtest..table(NOLOCK)

If the base tables and view have the same owner, it should work.

I was able to get close to what I wanted by sorting on the number of relpys in ascending order. It will do.

Log onto your database server using the same account that you use for the SQL Server service. Now run the DTS and see if you get any errors.  Also, check...

Not enough reports. It has great online screens and graphs.  But to get the reports I needed - I would have to do screen shots and paste into Word....

I also looked at this product. It was one of my favorites, but the reporting was very weak. I need more printable reports to calm the anxieties of everyone...

ok,

this is it.

I need to get the user inputs for the post code formats and phone no format. depending on that I need to create scripts for the...

Could you use a trigger and pull the valid values from a lookup table.

We run a 3rd party app that will guarantee support to there product if we upgrade to SQL Server 2000.  We run other apps on the same server that...