Viewing 15 posts - 3,061 through 3,075 (of 3,543 total)
exec sp_MSforeachtable @command1 = "print '?'",@command2 = "sp_helpindex '?'"
September 17, 2003 at 6:33 am
quote:
yes, everyone should be treated the same. Make them all sysadmin, for they know what they do!!
September 16, 2003 at 9:58 am
I'm all for empowering the user. As long as it is in a controlled environment.
September 16, 2003 at 9:50 am
Since corrections have been made in the past I always check the answer I give in the newsletter is the same in the forum, maybe I missed this one
September 16, 2003 at 8:41 am
quote:
I suggest a big points bonus for answering on the day. Any comments?
Would be...
September 16, 2003 at 6:38 am
I could see this generating some interesting comments.
I cannot say which I prefer.
A previous employee built a database to hold info about our dealer network. This database has a...
September 16, 2003 at 6:25 am
I agree.
quote:
At what memory point must you set the /PAE ...
The important word...
September 16, 2003 at 2:18 am
See if this works using a temp table.
CREATE TABLE #A(ID1 int,ID2 INT,
RowID nvarchar(15),
Created Datetime,CreatedBy nvarchar(25),
Field nvarchar(25),
OldValue nvarchar(25),NewValue nvarchar(25))
INSERT INTO #A...
September 15, 2003 at 11:34 am
Managers who think I am a f*****g fireman. You tell them 'disk nearly full', 'disk is really nearly full', 'disk is full', 'disk is f*****g full'. Then a user tells...
September 15, 2003 at 8:20 am
Try this, it may do it.
SELECTa.RowID,
a.Created,
a.CreatedBy,
a.Field,
a.OldValue,
a.NewValue
FROMAuditTbl a
ORDER BY a.RowID,
a.Created,
a.Field,
(CASE WHEN (SELECT TOP 1 NewValue
FROM...
September 15, 2003 at 4:59 am
I think your problems occur from the structure of the event data and it being on multiple lines. The following script which you can use to preprocess the comma separated...
September 15, 2003 at 4:04 am
If that is the windows event log then I see your problem. The only thing I can suggest is to preprocess the file with an application or ActiveX script and...
September 12, 2003 at 10:42 am
Not sure what your question is but presume the problem is with identical datetime's. If you want to guarantee sequence of events in AuditTbl and BaseTbl then add an IDENTITY...
September 12, 2003 at 8:28 am
I cannot reproduce the error and without the table definition,dts and data it is difficult to see what the problem is. If the data may contains extra columns you could...
September 12, 2003 at 8:11 am
Are you transferring the data as fixed or delimited?
September 12, 2003 at 7:33 am
Viewing 15 posts - 3,061 through 3,075 (of 3,543 total)