Viewing 15 posts - 3,181 through 3,195 (of 7,429 total)
Based on the fact it states
1 transactions rolled forward in database 'ARDB' (9). 0
then I assume you are getting to the point where it reads the transaction log. Copy the...
April 7, 2003 at 4:48 am
Also, even though is an issue in 7 and 2000 it is not near as bad as what happened in 6.5.
April 7, 2003 at 4:43 am
quote:
I hate to re-open a seemingly completed issue but I just wanted to get a clarification on this simple script:SELECT
*
FROM
tableName tN
LEFT JOIN
tempTable...
April 7, 2003 at 4:39 am
Satech, look at David's answer
ISNULL(REPLICATE('0',5-LEN(PALLET_NUMBER)),'')+PALLET_NUMBER
it takes into account replicate with a negative length returns null. If PALLET_NUMBER can also be null then change to
ISNULL(ISNULL(REPLICATE('0',5-LEN(PALLET_NUMBER)),'') + PALLET_NUMBER,'00000')
to ensure you get 00000...
April 7, 2003 at 4:25 am
What are you wanting to know specifically and what programming language? There are lots of examples on the web of all types of connection and execution methods. I prefer to...
April 7, 2003 at 4:17 am
Just keep in mind that the JDBC is still a work in progress and does act flaky, mostly slow.
April 7, 2003 at 4:15 am
This will handle it for all tables in the database.
DECLARE TableCursor CURSOR FOR SELECT '' + TABLE_SCHEMA + '.' + table_name FROM information_schema.tables WHERE table_type...
April 7, 2003 at 4:00 am
Could also be that you are suffering from a Memory bottleneck. Look at task manager and see how much memory is in use/paged and if there is a high number...
April 7, 2003 at 3:55 am
Of all the queries I have tried both on I have not seen in the situation on the a=b or b=a for the on to make a difference. The query...
April 7, 2003 at 3:52 am
The only two I have used is NetMon (MS Product in Windows Server but I believe there is a way to get for workstation). And Etherpeek (I believe we still...
April 3, 2003 at 3:49 am
No master should always be a full backup to get the changes. You cannot restore the Master DB and TLs. Master only stores changs to server and databases physical location....
April 1, 2003 at 4:33 am
quote:
1) IDENTITY is proprietary to MSSQL.
Not exactly correct and not a valid reasoning against IDENTITY...
April 1, 2003 at 4:24 am
Can you post the trigger code so we can get a better idea of what it is doing. It should have no issues keeping up but depending on the way...
March 27, 2003 at 4:34 am
Actually you can create a table with multiple variable length columns that will cause a potentil width greater than 8060, but the data in the row will only go to...
March 27, 2003 at 4:32 am
Viewing 15 posts - 3,181 through 3,195 (of 7,429 total)