This is easy to test!

update

MyTable

set

MyChar = '

'

where MyID = 123

select

ascii(MyChar) from MyTable -- This will...

I does return Disabled for my servers, but I was under impression that this is because we have a corporate agreement and they send us special CDs I don't have...

select

serverproperty('LicenseType')

Per BOL:

Mode of this instance of SQL Server.

PER_SEAT = Per Seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.

Base data...

I think it would be Microsoft's SQL Server Development Team, see this article on this site:

http://www.sqlservercentral.com/columnists/sjones/spotlightonsqlserver.asp

only looking up this article I realized that it is the same Jim Gray ...

I got access to one too!

As for the usage, there are some third-party apps that use MySQL and if we want to use this third-party app we will need to use...

Yes, that is correct. But if port 1434 is closed, even if Browser service is running, it would not do much.

Good!

This is exactly what I was going to suggest. To use the function. Maybe I would input a string into the function, and check for each character using IsNumeric() function.

Yes, we did have this problem. For the instances to be accessed, SQL Browser servie has to be running and UDP port 1434 has to be open. Since we have...

Did you put a path in double quotes " if the path contains spaces?

We used the syntax from BOL:

start /wait setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

and...

The application should allow user to save data locally which means, the initial data entry screen should be available for saving, copying etc, I mean, being up and clickable.

Examples: Web...

Whisper, not sure about context switching, but other statistics is OK.

Did somebody try to login using Query Analyzer being on the server computer, not over the network?

I would try to open...

This is a very good script, Mohammed!

I tested it on SQL Server 2005, it works.

Rick,

you should run this script on the server where you did a backup and in the...

When you did a backup, there probably were files in the list of "Backup To.." on the General tab. These file names are there by default from the  pervious backup. You...

Nikki,

I have a lot on the list because we have things to be installed on the server separetely. We did have to install Oracle client (or connectivity tools) for us to...

Wisper,

Add counters to the performance log and present results as a chart and see if something stands out:

SQLServer:Locks(_Total)\Lock Wait Time (ms)

SQLServer:Locks(_Total)\Number of Deadlocks/sec

SQLServeratabases(_Total)\Transactions/sec

Process(sqlservr)\Page...