yes you can.

Paul is right..if you take your backup .bak file, you can restore it on any SQL 2005 instance, but behind the scenes it will be upgraded to the...

enterprise? no, that would be illegal. standard and enterprise are all purchases, and often involve thousands of dollars in licensing.

developer edition costs 50 dollars on amazon.com, and allows you to...

ive always used the oracle driver from the client install, but the previous poster is right...you might need to install the driver first:

SET @provider = N'ORAOLEDB.Oracle' --optionally 'MSDAORA' to use...

behind the scenes, the length is set to -1 for the column in syscolumns. can you set the width to -1 instead of 8000?

raw text or RTF? editplus can do that easily to raw text,you just set a macro to search for a term to find the start, then make it select while...

within a trigger, there is a couple of functions you can use you can use to determine if a column has changed:

IF (UPDATE(columnname) ) returns true or false, if you...

are the columns in the spreadsheet in the same order as the columns in the dataset?

what i mean is, if the spreadsheet has 10 columns today, and 14 columns tomorrow,

do...

not on the screens you were setting up; that set up the profile, where it is only one account.

if you want replys to any email to go to multiple persons,...

just checking the basics...the connection string your program is using is connecting to master database and not the database you are trying to restore right? if it connects to teh...

just checking the basics...the connection string your program is using is connecting to master database and not the database you are trying to restore right? if it connects to teh...

doh! that was it! thank you Gail, and thank you Barry for a handy snippet to add to my collection.

RBarryYoung (5/8/2009)

---

Looks like I answered my own question. The following seems to work fine:

Declare @qp as XML

SELECT @qp = query_plan

From sys.dm_exec_requests

Cross Apply sys.dm_exec_query_plan(plan_handle)

Where session_id =...

if the trigger does not exist, you can't ALTER it..change to CREATE TRIGGER.....

my WAG on the column name was perfect!

change that last line to this:

WHERE tblPerson.PersonID = INSERTED.PersonID

you pasted your current trigger...i modified it.

however, i made a WAG(Wild *** Guess) as to whether your table tblPerson had a PersonId in it.

you'd have to modify it to be...