Connecting by name you are likely using Named Pipes.  The sql server needs to have TCP/IP enabled before you can connect by IP address.

Sounds like you want to script the database and then create an  empty one?  If so, you can use Tools/Generate SQL Script... from Enterprise manager.  Lots of options on what...

if you want those pesky trailing zeros you'd need a format like ###,###.00

puting in the zeros instead of pound signs ensures a digit shows up in that position

Is this an application written in house?  If so you can have it call stored procedures that will create your change records.

I have a VB6 application i use to generate and email PDF attachments for Crystal Reports vsersions 8.5 thru 9.2  - you could bolt on the approperiate dlls for other...

Think of SCOPE_IDENTITY() as local and @@IDENTITY as global.  SCOPE_IDENTITY() is local to your procedure, where @@IDENTITY is the last identity value generated in the processing stream.  So, if you...

Microsoft goes to some lengths to protect the user password from being recoverable with a tool.  You will not be able to recover the users original password by any method I...

your seem to be using named pipes rather than TCP/IP to talk to the server.  Named Pipes are old NETBIOS technology and are usually not forwarded out of the subnet. ...

Have you tried the command line utilities.  ISQL has a -w parameter that is the maximum line width of the output, see what happens if you set it to something...

each instance will need its own port number

I did a little research on a similar issue recently.  If the image is fixed - ie a logo - then the report server needs to be able to find...

http://www.w3schools.com/sql/default.asp

a free on line tutorial. covers the basics and is fairly short.  most users should finish it in a day or two

It looks to me like the hyphen characters are being ignored by the sort routine.  Are you specifying a character set for the sort? A custom comparison function?  Are those leading spaces in...

database mirroring was turned off in the RTM.  There were some issues they didn't have time to resolve before their ship date.  I understand there is a trace flag that...

or make a stored function that returns the value you are interested in.  If the values of the columns Red, Yellow, Green is an Int, this would do what you...