Viewing 15 posts - 11,131 through 11,145 (of 13,469 total)
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...
May 9, 2009 at 4:38 pm
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...
May 9, 2009 at 4:30 pm
doh! that was it! thank you Gail, and thank you Barry for a handy snippet to add to my collection.
May 8, 2009 at 9:56 am
RBarryYoung (5/8/2009)
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 =...
May 8, 2009 at 9:43 am
if the trigger does not exist, you can't ALTER it..change to CREATE TRIGGER.....
May 8, 2009 at 8:47 am
my WAG on the column name was perfect!
change that last line to this:
WHERE tblPerson.PersonID = INSERTED.PersonID
May 8, 2009 at 8:31 am
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...
May 8, 2009 at 8:06 am
you probably want to change it to test for OR instead of AND...so it builds like this
SELECT * from MyTable WHERE 1 = 2 --never happens
OR ServiceNumber001Volume...
May 8, 2009 at 7:50 am
your current trigger would update everything, where you really want to restrict it to the rows that were updated.
inside a trigger, there are two virtual tables called INSERTED and DELETLED,...
May 8, 2009 at 7:39 am
you'd have to use dynamic sql to build the sql; here's a working example:
Create Table MyTable(
Id int,
Name varchar,
Address varchar,
ServiceNumber001Volume int,
ServiceNumber002Volume int,
ServiceNumber003Volume int )
declare @sql ...
May 8, 2009 at 7:33 am
your welcome pav; settings like that are not always intuitive.
for others reading this, pav was referring to how to export from Query Analyzer with a custom pipe character; the thread...
May 7, 2009 at 7:26 pm
the format has nothing to do with the server you are connecting to...it's a setting for Query Analyzer.
just change your export format here:

May 7, 2009 at 6:54 pm
you could still add a default constraint later...but that's beside the point.
you are right, you might need to do something in a trigger that is not quite doable in a...
May 7, 2009 at 4:51 pm
I think you are a bit confused on default and timestamps.
the "timestamp" datatype is poorly named, and should be referenced by it's synonym called rowversion is a special datatype...
May 7, 2009 at 4:02 pm
Customer_Tags
------------------------------------------------------------------------
CustomerID (int AutoNumber FK), TagId (int AutoNumber FK), Count (int)
------------------------------------------------------------------------
i read his requirement as being that the Customer_Tags table was a many-to-many table with CustomerId , with FK's to other...
May 7, 2009 at 10:17 am
Viewing 15 posts - 11,131 through 11,145 (of 13,469 total)