Usually happens when trying to use Kerberos auth but it fails back to NTLM auth

http://support.microsoft.com/kb/811889

Deny takes precedent over Grant, so if you only want users of the proc to select, then simply deny INSERT/UPDATE/DELETE on the tables the proc uses to stop them from...

TRUNCATE ONLY has been removed in SQL 208 onwards due to the nature of the command and people miss using it and not understanding the consequences.

A log will grow as...

Trying to use Kerberos but failing back to NTLM authentication

Troubleshooting the "Cannot generate SSPI Context" Error Message

Invalid filename, correct the filename and re-try

Powershell will probably be the best bet on that

Get-WmiObject win32_logicaldisk | where-Object {$_.providername -like ''} | select deviceid, size

Just out of curiosity, does the database actually contain the table InventTable?

Not played with AX in over 18 months so cant remember if its a standard table or not.

Also what...

CFT file, that is usually an animation studio file.

How are you backing up the transaction log?

Does it write to the same file everytime a backup is run?

If so this is...

Microsoft can explain it better than me.

http://msdn.microsoft.com/en-us/library/ms152899.aspx

Well if MyXML is already the output you want to pump out to a file, you dont need to exec it, you need to select it as there will be...

Missed one thing, the MyXML variable will need to be varchar too

SO you might as well just do the following

DECLARE @sql varchar(max)

SET @sql= 'bcp "SELECT column_names FROM QMS_QmsBase FOR XML...

change @sql to varchar(max) instead of nvarchar(max)

Also dont use *, you should use the columns names.

Also on that remeber that * is a CMD wildcard like % is in SQL...

what is happening? are you seeing files older than 4 days still there?

A procedure use SQL Agent

A report use subscriptions

Look at custom authentication or forms based authentication.

But you will loose all trackability of who runs what report if you go down this route as it will potentially require an...