glad you figured it out.

in our case, it was the same thing...the app testest for read/write of the key, and failed to connect.

we used regedt32(not regedit) to grant permissions to...

it might be like an application my shop had:

the app stored the connection information in an encrypted format in the registry HKEY\LocalMachine\software; by default users typically can't write to...

that error could occur if your database compatibility level is at 80 instead of 90;

the compatibility level determines which syntax version is applied to statements hitting the database, and rownnumber()...

My questions are the same:

what is a serial number to you? is it a random number? can it be '0000' plust the customer number?(0001,0002, etc). Why did your example...

yes, the CLR is actually saved in the database, along with it's source code...so if you were to backup a database, change the CLR and redeploy it, then restore the...

I like Florians script...added it to my snippets.

my only changes are I added the filegroup name and removed the WHERE statement...i want a script that generates all the DBCC and...

the same script that Florian gave you, simply change the file group name and change the line that says DBCC REINDEX to this:

'UPDATE STATISTICS ' + SCHEMA_NAME(st.schema_id) +...

ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume starting with...

here's how i would do it.

I'm assuming that you are using US format for area codes..(800) xxx-yyyy ext.zzzz

some of your area code exampels started with 1, i.e. 109, which does...

here's how i do it:

FormattedDate SQL

20090320-09:33:49:700 SELECT CONVERT(VARCHAR,@date,112) + '-' + CONVERT(VARCHAR,@date,114)

20090320-093349700 ...

Brandi one of the best forum platforms out there for phpBB/MySQL stuff out there is phpBB http://www.phpbb.com/%5B/url%5D

free, open source,

full featured easy to use, huge deployment so you can find...

yeah, for event 12 SQL:BatchCompleted, even when everything is enabled, there is a lot of null columns, i can see that you want to capture just certain data depending on...

you need to add a different trace; a great example from Perry Wittle is found here:

http://www.sqlservercentral.com/Forums/Topic576752-146-1.aspx

AFTER that is in place, you will be able to determine who ran a SQL...

Perry your code example was very helpful for me today, as I wanted to create a DML trace to be a companion to the existing DDL default trace.

so I played...

here's my comparison snippet for SQL 2000:

create table #rowcount (tablename varchar(128), rowcnt int)

exec sp_MSforeachtable

'insert into #rowcount select ''?'', count(*) from ?'

--tablename is [dbo].[TBLNAME] instead of plain...