Viewing 15 posts - 2,101 through 2,115 (of 7,429 total)
I know of no other ways to do this as you are asking.
March 25, 2004 at 12:20 pm
Read "Transaction Log Backups" in SQL BOL for TL.
March 25, 2004 at 11:57 am
Sorry just occurred to me that if the structure of the tables are roughly the same you could potentially use a UDF like in the following example to pull it...
March 25, 2004 at 11:31 am
Blackbox Trace will be your only hope to catch to the moment it occcurrs but still no guarantee. See "Reporting Errors to Your Primary Support Provider" in BOL (index Blackbox.trc).
March 25, 2004 at 11:04 am
Afraid not at least not that way. You could create a linked server to itself and try
SELECT INTO #tblWho FROM OPENQUERY(MYSELF,'EXEC sp_who')
But I don't like that method because of how...
March 25, 2004 at 11:01 am
Up to you but here is a simple example to demonstrate how it works.
SET NOCOUNT ON
CREATE TABLE #tblWho (
spid int primary key,
ecid int,
status varchar(30),
loginame varchar(128),
hostname varchar(128),
blk int,
dbname varchar(128),
cmd varchar(16)
)
INSERT...
March 25, 2004 at 9:33 am
Oops, sorry about that I was thinking TL backups when I was typing.
March 25, 2004 at 8:13 am
Can you post your TABLE DDL and TRIGGER for us to get an idea of what you are doing fully please?
March 25, 2004 at 8:10 am
Nope makes a lot more sense now. The only question left is how will you know ethicitytype in the families table has not been set? Will it be NULL or...
March 25, 2004 at 5:27 am
What is the outcome of this TRIGGER, looks like either you are getting the sequence id or setting it my Oracle Kung FU ain't the best and I don't have...
March 25, 2004 at 5:17 am
WHen you add in CADD and CSCORE you will get duplicate names if you have multiple different entries in either of those fields. If you want all the CADD and...
March 25, 2004 at 4:48 am
Don't have time right now to validate it but if you know the limit of how many inputs you will need add 10 and create a UDF (user defined function) something...
March 25, 2004 at 4:39 am
As far as "state" is concerned, this has potential for international use, so I was advised to go with varchar 5 there (and also replace "state" with "pstate" or the like...
March 24, 2004 at 8:14 pm
They are stored in the order they were entered with some exceptions but they are considered in heap as no deciding factor determines sort. The index actualy sroes the page...
March 24, 2004 at 7:51 pm
Viewing 15 posts - 2,101 through 2,115 (of 7,429 total)