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

thomasemp (9/26/2011)

---

I have created a trigger for a particular table.While i insert a record the trigger is working perfectly but while i use SqlBulkCopy to upload records from excel to...

that is by design. all bulk copying, whether using bcp.exe , BULK INSERT or via a SQLBulkCopy, triggers are not executed by default.

there is a flag you can set...

does this do what you are asking?

it seems a little round about, but it works with the sample data given.

/*

--Results

transaction_idtype

1A

1B

5A

5B

5B

*/

With mySampleData (transaction_id,type)

AS

(

SELECT 1,'A' UNION ALL

SELECT 1,'B' UNION ALL

SELECT 2,'A' UNION...

none of the above.

go to this page:

sql 2005 sp4

and download either the 32bit or 64 bit of Service pack 4.

that service pack is designed to upgrade any type of instance...

try something like this to track down the non numeric values:

SELECT DISTINCT '>' + [test] + '<' FROM K

WHERE ISNUMERIC([test]) = 0

maybe it's a value like 'NA" or 'N...

In programming languages, a function can do everything a Subroutine can do, plus return a value.

in SQL it is...

nothing is ever equal to or not equal to null; since null is undefined, nothing can match it, even another null.

you have to us the IS function instead:

SELECT

...