Viewing 15 posts - 4,216 through 4,230 (of 6,216 total)
You're better off using text columns since they only consist of a 16 byte pointer in the record, the actual data is stored in another table. For the few times...
May 23, 2002 at 4:03 pm
I agreee, Crystal and/or Access are good options. There are other 3rd party products for reporting. Don't forget HTML/ASP either, its pretty easy to dump a query into HTML, either...
May 23, 2002 at 2:37 pm
The answer is it depends. Depending on how you set the recovery mode determines how much work you have to put into logs. I recommend full recovery mode, which means...
May 23, 2002 at 2:36 pm
Pages are fixed at 8k. Steve Jones has a great article about row size and pages you might find helpful:
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp
Why do you need to change the page size?
Andy
May 23, 2002 at 2:34 pm
The service needs to run under an NT account. Either local system or more commonly, a domain service account.
Andy
May 23, 2002 at 2:32 pm
Inserted is populated for an insert or an update, deleted is populated for a delete or an update. For updates you're getting the before (deleted) and after (inserted) images of...
May 23, 2002 at 10:31 am
I dont use them either. I had heard (but not tested for myself) that some controls open a second connection and have problems with application roles. In this case it...
May 23, 2002 at 6:13 am
If its the result of a restore, you can change the state by running RESTORE DATABASE MyNwind WITH RECOVERY. If you're waiting database recovery such as occurs after a bad...
May 22, 2002 at 8:38 pm
I imagine you'll get a variety of answers on this one! If you have an app already running in Access I'd recommend moving the data to SQL and linking to...
May 22, 2002 at 6:27 pm
I think you'd have to convince them that its wrong to start with.
Andy
May 22, 2002 at 4:38 pm
You'll have to restart the service - and possibly the server, so if you can just reboot. I've seen this happens a couple times, never got to the root of...
May 22, 2002 at 4:38 pm
Nothing in the SQL error log? Any chance ran out of disk space?
Andy
May 22, 2002 at 4:36 pm
You're right, that returns 11. What was I doing? Ah well. Best you can do is add one. When you use 5/31 you're really using 5/31/02 midnight. It wont return...
May 22, 2002 at 11:47 am
I get 13 when I run either of these:
select DATEDIFF(m, '5/31/2001', '6/01/2002' )
select DATEDIFF(m, '6/01/2002', '5/31/2001' )
Andy
May 22, 2002 at 11:23 am
Viewing 15 posts - 4,216 through 4,230 (of 6,216 total)