mrTexasFreedom (9/29/2011)

---

Lowell,

I received permission from the organization here to allow the customer user to be dbowner. I thought I'd try the method you suggested in this snippet, but I receive...

does SQL 2000 support logon triggers? i think that's only 2005 and above, rioght?

nineteen-red (9/29/2011)

---

Thanks so much Lowell, replaced the originals with the dlls in the zip and it worked a treat.

Appreciate your help with that one as I had read the thread...

Mike C, the original author, pointed to a different thread where folks talked about not being able to use 64 bit with the originals.

cygnussolutions posted a zip file for...

no...from what we posted above, i think it's now detecitve work...

@ 12 noon, the machine \\BIZ100 was connected using sa

we find that machine, and find Bob sits at the desk...

and another way, since you posted in SQL2208, is to consdier the tIME datatype to get what yo are after as well:

--returned 10:53:47.4970000 and 10:53 for me at that moment

select...

i believe this is the possible CLR types:

select * from sys.objects where type_desc IN

('CLR_STORED_PROCEDURE',

'CLR_SCALAR_FUNCTION',

'CLR_TABLE_VALUED_FUNCTION',

'CLR_TRIGGER',

'AGGREGATE_FUNCTION')

since every CLR has a proc or function object, can't you create a role with DENY EXECUTE ON [each procOrfunction]?

then put all the users in that role to take the...

Error: 17750 is "Could not load the DLL ", you are correct.

the xp_dlls are in the Binn folder of the correct instance, right? i know you can get that error...

that could be more than one program, written in .net, connecting to your database; it might be the same program from multiple machines; that is what a SQLConnection will call...

you have to join master-files to itself.

this will work, but if you have any ndf files, the are not taken into account.

select @@SERVERNAME,

db_name(main.database_id),

main.size AS mdfsize,

logs.size AS logssize,

main.physical_name AS mdfpath,

logs.physical_name AS...

Jim i think it's because you mixed up the order of the parameters.

,dateadd(m,datediff(m,0,dateadd(m,1,getdate())),+3) As Date_3

the "+3" in the above is a DATE...not the number of days to add. it's actually...

any chance you can change the sa password, and then wait for someone to report which apps are failing?

yeah i know you can't do that....

for a similar issue, i used...

it's actually pretty easy; right click on the specific database in Management Studio's Object Explorer.

select Tasks>>Generate Scripts.

a script wizard comes up, where you can simply check a checkbox that says...

well it depends on the function for the exact parameters allowed, but for exampleit would typically be something like this:

SELECT dbo.split_string('A String, To Split',',')

--where the second parameter(the comma)...