Viewing 15 posts - 3,481 through 3,495 (of 7,429 total)
Also, with triggers there are no guarantees they will fire on system tables and that they might not cause your server heartburn so to speak within system transactions. Good concepts...
January 27, 2003 at 4:07 am
No it is not a DB option it is a connection option. You can go into Server properties and on the Connections tab set the default connection properties to "No...
January 27, 2003 at 4:00 am
This is the base code I use to determine mode.
SELECT [id] AS MODE FROM tblHA GROUP BY [id] HAVING COUNT(*) = (
SELECT MAX(CNT) AS MaxCNT FROM (
SELECT count(*) AS CNT...
January 26, 2003 at 4:54 pm
As long as it makes sense to you and you are sure the next person coming along will understand convention is always up to you. Personally I prefer to use
tbl_Employees
simply...
January 24, 2003 at 2:59 pm
Zip is still limited to 4GB for any version I have seen for an uncompressed file. However the SQL thrid party backups SQLZip and SQL Litespeed both support compression without...
January 24, 2003 at 2:10 pm
Unfortunately, you hit on the one thing we all have tried to figure out. You can put the data into a varchar(8000) but if it goes over 8000 you cannot...
January 24, 2003 at 1:52 pm
Unfortunately you cannot declare a variable for use of those types for use. You will have to use a char or varchar type if possible for your data.
January 24, 2003 at 9:55 am
Some of the early products are this way. They changed almost everyday depending on who called you and none of the code had documentation or comments so you were left...
January 24, 2003 at 4:15 am
The way you wrote it may not work right and in fact may be setting the value to every value in header or to itself. We have found quarks with...
January 24, 2003 at 4:02 am
Try using TRANSACTIONS.
BEGIN TRANSACTION
make you change
check your change
ROLLBACK TRANSACTION or COMMIT TRANSACTION
They have to all happen on the same connection. Losing the connection will autocommit. I usually test UPDATE statements...
January 23, 2003 at 7:25 pm
46 hours seems long, could have stalled. One thing tha can give you a clue is if your Transaction log is set to grow and happens to do so. But...
January 23, 2003 at 7:21 pm
I originally did backup to tape Full once a week then diff other days. Then it wss moved to full everyday. But the problem was the same I was running...
January 23, 2003 at 3:14 pm
Ok, on the Options table of the Restore database dialog then is an option the exact wording in 2000 and I believe 7 is
"Leave database nonoperational but able to restore...
January 23, 2003 at 2:40 pm
I am pretty sure it is not possible. Trace I don't believe even uses inputbuffer if you read all the sections on it in SQL BOL. In SQL 2000 you...
January 23, 2003 at 2:29 pm
If doing the FULL restore thru QA add WITH NORECOVERY to it then do the Diff. If thru EM then on the second tab of the restore dialog you will...
January 23, 2003 at 5:39 am
Viewing 15 posts - 3,481 through 3,495 (of 7,429 total)