Use Unicode where ever possible.

In ASP / ASP.Net or your webpages, set the page encoding to Unicode (UTF-8). Your web pages and web browser will then talk in Unicode. Check...

To allow SQL Server to access network shares:

1. SQL Server service must login as a windows domain user

2. The Sql Server domain user must have 'Log on as a service'

3. The Sql...

hmm. Remember that the sql is executed on the server, so:

A. the file must exist on the server, and

B. the SYSTEM user (or the user SQL Server logins in as)...

Most likely the problem is to do with the UNC path  '\\work\C Drive\abcd.dbf'

SQL Server by default runs under the SYSTEM account, which does not have network access, so cannot access...

For what reason do you need to determine the origin of the install media?

SELECT @@VERSION

EXEC xp_msver

Return similar information about the editition and build number of SQL Server.

SQL Server itself...

DECLARE @fileexists int

EXEC master..xp_fileexist 'c:\myfile.txt', @fileexists OUT

IF @fileexists = 1          -- The file exists

   PRINT 'File Exists'       -- Do what you want here

1. Fix up your incorrect space usage reporting with:

DBCC UPDATEUSAGE ('MyDatabase')

2. Specify the WITH SORT_IN_TEMPDB option in your CREATE INDEX statement. This tells SQL Server to use your TempDB to while...

First, check "Autostart SQL Server" is ticked in your SQL Server's Properties (In SQL Enterprise Manager, right-click the server and choose properties. The autostart options are in the general tab).

Have...