Viewing 15 posts - 301 through 315 (of 347 total)
We rename the NT server not SQL Server... sorry no sql command for that.
mom
November 18, 2003 at 9:24 am
yvr4,
I know this is old but I am wondering how are you are your database doing? were you able to get your stuff done?
mom
November 17, 2003 at 3:47 pm
At where I am we replace lots of sql servers every year.
.old server name -- myserver--> keep it this way.
.backup myserver and restore it to myserverNew.
.take old server name...
November 17, 2003 at 3:43 pm
I am just wondering...
can you get into dos prompt and type
isql -E -SAllana --> this to check if it will allow you to loging using trusted connection
or
isql -Usa -Ppassword...
November 14, 2003 at 3:48 pm
If you set it this way it will work.
declare @command varchar(1000), @folder varchar(20), @str varchar(100)
SET @folder = 'New Folder'
SET @str = ' del "s:\sysadmin\'+ @folder + '\test.txt"'
SET @command = 'master..xp_cmdshell...
November 14, 2003 at 3:38 pm
I wrote sql script to query all my servers and give me the status of what I need and then load it to my server via bcp and put it...
November 14, 2003 at 2:57 pm
I don't see any reason why you would want to login as domain admin to access SQL server to do admin work on sql server. We generally remove domain...
November 13, 2003 at 1:29 pm
Let me add to this, that if all else failed restarting the server itself is always helpfull and 99% of the time works.
mom
November 13, 2003 at 12:01 pm
It does sounds like permission problem. Have you tried to just schedule your job in sql agent so that it runs from the agent context of permission? I...
November 7, 2003 at 9:57 am
What exactly are you trying to get out from those web pages? Are you looking for pricing of the sort so that you can find price compare? You know...
November 5, 2003 at 10:43 am
sxg6023,
I am really not sure what DTS does behind the back door. Here is what I found on BOL:
BULK INSERT [ [ 'database_name'.] [ 'owner' ].] { 'table_name' FROM...
November 5, 2003 at 9:57 am
DTS would show you that it finish 1000 chunk at a time but if it failed it would roll back everything leaving you to keep 0 rows of data. ...
November 4, 2003 at 5:09 pm
shouldn't we be converting @A to a varchar or nvarchar first before we try to add the string? When it ready for final execution then it will need to...
November 3, 2003 at 4:54 pm
how about write a sql script to devide the chunk into smaller piece by date time or by whatever you are using as your Primary key as long as they...
November 3, 2003 at 4:43 pm
Viewing 15 posts - 301 through 315 (of 347 total)