quote:Originally posted by Adriaan In that case either the FQDN, or the IP address for the server, plus the instance name, should work - by the way,...
quote:Originally posted by Adriaan <server_name><instance_name> should do the trick. I belong to some other network in that case your trick...
How to connect sql server with instance name, if we don't know the port number. E.G:- If on one NT box we have 3 instance and i want to connect to...
--Here is syntax to take multiple stripe backup:- --This is an example for 3 stripe:- Backup Database ABC to disk='c:1.bak', disk='c:2.bak',...
SQL Server 2000 provides the ability to stripe backups across multiple tapes or disk devices. Does any one know the syntax for the same? Rajeev...
No, this is not possible because on that disk we had around more that 50GB free space. And one more thing my SQLAgentCmdExec account got locked when...
How to restart replication from SQL analyzer. Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
I have SQL server 7.0 transaction replication . Following error i was getting on distribution agent log:- The agent is suspect. No response within...
I got below error in sql server 7.0 error log:- Automatic checkpointing is disabled in database 'master' because the log is out of space. It will...
Hi Satya, Through SP_HELP_JOB sp I can see it is enabled=0 I think it is disable. So how to correct it, Is it not possible to do it from Enterprise...
Use this: alter table <Table Name> alter column <column Name> <datatype> null Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
I am using SQL Server 7.0 with sp3. One strange thing is happening when I see one of the job which is showing as enable as "Yes", But when I right...
In SQL Error Log this error is coming and source is "ods". And no fix time is there. Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
Argyle, As you said that you had faced same problem, this should had come every time when you use that driver. But here I rarely get this error....
I have tried the backup in QA and it do the backup properly,But while taking backup from maintenance it hangs and no error comes in maint history or...
Few days back my Maintenance plan was getting hang when it take#%92s backup for one database, so we removed that database from maintenance plan and...
Thanks Satya, Can we get which driver is causing this error? Because we don't use Sybase client as it is said in Microsoft link. Or is their any way...
I am using SQL Server 7.0 with SP3. Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
Error: 17832, Severity: 18, State: 8 "ods Connection opened but invalid login packet(s) sent. Connection closed." Microsoft KB Link :-...
Satya I agree with you that is why I wanted to know is there any other way to achieve same task such as copy, delete and moving of files by normal...
Separate names with a comma.
