Is the webserver in the same domain? And do you have rights?

The other thing to check is that you are not blocked by a firewall and that you are using...

If you are able to connect using the IP address, but not the instance name, check that the virtual server name has been entered into dns correctly (try pinging it...

Have you tried connecting using the ipaddress\instancename ?

Dont use \\VirtualSvrName\InstanceName through QA just use VirtualSvrName\InstanceName

I have trouble believing in anything HP say right now. It took them several months to get me the answers as to why the Itaniums were not performing.

I guess my...

Thing is that HP are throwing benchmark figures at me that show the AMD as outperforming the Intel.

Trouble is that TPccs are not always a true reflection of a production...

You could build a dos batch file using and activex task and then execute it, you'll just need to set a flag to be sure that it does not prompt...

From experience performance wise. 1HT CPU = 1.3 regular CPU.

1 Dual core CPU =1.7 regular CPU.

Dont listen to the IT folks, get as many physicals as you can, you might...

That's lousy, the Oracle provider is so slow in comparison that it's going to take a lot longer for my linked server queries to execute.

Your best place to start would be to lookup the syntax in Books Online. You could also use DTS to create a format file for the BCP (makes things a...

exec sp_msforeachdb "use ?;exec sp_adduser 'username', 'username';"

exec sp_msforeachdb "use ?;exec sp_addrolemember 'db_datareader', 'username';"

You could use a cursor to loop through the list of users that you want to add.

If you are attempting to connect to the servers you should also include the named instance in the connection.

xxx.xxx.xx.x will not work.

xxx.xxx.xx.x\Instancename will work.

You should make sure to apply all the logs before bringing the log shipped copy of the database live, to make it live is

RESTORE DATABASE DBNAME WITH RECOVERY

As for...

You would have to know which column in the table is associated with the box in the web page.

Assuming that "Notes" is the column...

SELECT * FROM tblReponses where Notes is...

I use a proc to do this, it replaces the carriage return and the linefeed (either or both could be in the string)

CREATE PROCEDURE USP_REMOVE_CRLF @INSTRING VARCHAR(4000)

AS

SELECT @INSTRING = REPLACE(@INSTRING,...