Viewing 6 posts - 151 through 156 (of 156 total)
So did you work out if your SQL Agent service account has rights?
To find the agent account, start services.MSC, go find the SQL Agent service, open it and check the...
December 16, 2009 at 11:12 pm
'there is no any listing of 'backup' command or 'restore' command and its parameters.so how can i get all the available commands in sqlcmd.'
BACKUP and RESTORE commands are T-SQL commands....
November 25, 2009 at 4:49 pm
To get the list of command line switchs for sqlcmd, do what you do for every other command line tool - type this at a command prompt:
SQLCMD /?
As for the...
November 25, 2009 at 1:42 am
That would indicate that the server A and B are not on the same domain.
October 27, 2009 at 4:23 am
Perhaps something in your requirements precluded this method but how about this:
DECLARE @var varchar(8000)
SET @var = ''
SELECT @var = @var + FieldName + '/'
FROM Table
SELECT @Var
October 13, 2009 at 10:38 pm
There's always this old chestnut:
September 2, 2009 at 7:13 pm
Viewing 6 posts - 151 through 156 (of 156 total)