The question was about configuration OPTIONS and the answer was about configuration TYPES. Configuration Options is what config items are configured. Configuration types is where all of the config options...

did you try to pass it as an output parameter from SP?

Hi,

had the same problem myself with the same description. I had no problems on Windows 2000 server but had on 2003 server. I had to download XMLSQL. Here are my...

Hi SQL Junkie,

You may want to read SQL Server 2000 Administrator's companion, it has a whole chapter, a very good one on the RAID levels as applicable to the databases...

Gimli,

I did not say dynamic sql statements if used with sp_executesql or Execute statement are not compiled. I did not say anything at all. I just wanted to point out...

I think it is perfectly clear!

- The amount of time per tick is computer-dependent

- Each tick on the operating system is 31.25 milliseconds, or one thirty-second of a second.

- This...

Randy,

1. Stored procedures are pre-compiled (performance)  and easier to use due to less room for the errors and typos when writing application code.

2. Make use of Table-valued functions that combine...

Syspermissions table. From BOL: "Contains information about permissions granted and denied to users, groups, and roles in the database. This table is stored in each database"

Sysprotects table. From BOL: "Contains...

Papillon and Rudy,

1. There may be a virus similar to described in

http://windowsxp.mvps.org/toolsquit.htm

"Why does Task Manager, MSCONFIG, or REGEDIT disappear while opening?"

This virus also affects MMC, I had the...

MJ,

I did realise you have no control over application code, but I though you may have control over the stored procedures that app is using. But now I realise that...

Hi,

The BOL topic "Char and Varchar" says:

".....Remarks

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified...

Hi,

I had (have and will have) the similar case. With the same DBCC Auditevent error messages. I had (have and will have) to change sp_adduser that a third-party industry leader...

MJ,

Why are your creating a cursor ? This is a stored procedure, it is executed on the server anyway, would not just a regular select statement do?

I think maybe I...

They should report different names in some cases. See Books Online @@Servername topic:

"......

Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the...

Hi,

To get a single value from a database table field with VBscript see below. Replace MyServerName, MyDatabaseName, MyUser, MyPassword, MyTable and MyField with your values.

Code creates a recordset with values...