Display language/date settings for your SQL Server.
2001-08-22
714 reads
Robert-Vallee,
2001-09-04
Display language/date settings for your SQL Server.
drop procedure hx_ServerLangReference go create procedure hx_ServerLangReference as /* Robert Vallee 09/03/2001 rvallee@hybridx.com input: none output: table format description: Simple display of language/date settings for your SQL Server */ select L.name, L.alias, L.months, L.shortmonths, L.days, L.dateformat, 'First day of the week' = case when L.datefirst = 1 then 'Monday' when L.datefirst = 2 then 'Tuesday' when L.datefirst = 3 then 'Wedsenday' when L.datefirst = 4 then 'Thursday' when L.datefirst = 5 then 'Friday' when L.datefirst = 6 then 'Saturday' when L.datefirst = 7 then 'Sunday' end from master.dbo.syslanguages L where 1 = 1
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads