hi,

you need to remotely connect to your SQL server, run "Local Security Policy" and add you SQL Agent Account to

user Rights Assignment in "Replace a process-level token"

hope this...

I forget to mentioned that my query ends with "order by date_publication DESC"

This query is send to SQL as ad hoc query from the client and I don't have access...

same as

select officeid, StateAbbr , LEFT(ascountynames, len(ascountynames)-1) as ascountynames

from

...

hello,

As anyone ever compare C:\Program Files\Microsoft SQL Server\100\COM\tablediff.exe from MP & Red Gate solution ?

Also in this solution comparing two very large tables can be very long, don't you...

What are included columns with respect to SQL Server indexing?

A new type of index was developed in SQL Server 2005 and beyond that assists in situations where a covering index...

Now it is working, I needed to add my AD account used by SQL Agent in Replace a process-level token , user Rights Assignment

sorry I was not clear, the first update is generated by our monitoring system (ORION) and is slow because of the clustered index scan.

I realize that by changing the format...

thank you VERY much it is working 🙂 but now I have the following error :

Executed as user: MPADGLOBAL\EUA_SVC_SQLCMD. Warning: cannot write logfile Y:\Microsoft SQL Server\MSSQL.1\MSSQL\JOBS\EDC test for Non...

thank you for your help it's working

hi

thank you very much for answering,

I have a directory on the server full of pdf file, every day a new pdf file is copy on that directory (FYI pdf...

because I do not have a Subscriber backup, when restoring my Publisher database I first delete replication settings

exec sp_removedbreplication

-- Dropping the registered subscriber

exec sp_dropsubscriber @subscriber = N'SRV'

--...

well I have been using XLS file as a datasource and it is working well.

using SSRS or any other tools is not an option, I am just wondering why an XLS file can be used as a data source but not an XLSX file?...

thank you

thank you