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)...

colleen i know that via TSQL you can get the serverproperty:

would that help?

SELECT 'IsClustered', SERVERPROPERTY('IsClustered')

there's a post here on SSC that might help, as well as the wiki on icalendar:

http://en.wikipedia.org/wiki/ICalendar

http://www.sqlservercentral.com/Forums/Topic403478-149-1.aspx

i know you send a file as an attachment of *.ics, but i cannot find...

that's what i had tested, kind of...

my scenario was:

my default database was "PERFECT1000",

my connection string was "SandBox",

the failed login returned master for the db_name() finction that i logged.

just to confirm: database name does not seem to be available at login.

i created a login trigger to prevent all logins,and then changed my connection string to explicitly have the...

I believe the users default database is only used after a successful connection, and only if they user did not explicitly specify the database in the connection string.

so i don't...

simple CONNECT permissions give the user the ability to query sys.databases, which is where the user gets the ability to see all teh databases, even though they have no rights...

when you do math on numerics and decimals, SQL server is free to use the maximum precision unless you declare it ootherwise.

DECLARE @numerator numeric(8,3)

DECLARE @denominator numeric(8,3)

SET @numerator = 3

SET @denominator...

here's what i use, just retested the syntax:

--http://www.7-zip.org/download.html

--http://downloads.sourceforge.net/sevenzip/7za920.zip

DECLARE @results TABLE(results varchar(255))

declare @command varchar(2000)

--zip one file

SET @command =

'"C:\DataFiles\7zip_CommandLine_7za465\' --path to 7za command line utility note the...