Viewing 15 posts - 36,406 through 36,420 (of 39,810 total)
Did you restore a db? EM has some issues here, I often have to refresh a few times or resynch the logins with sp_change_users_login.
Steve Jones
May 5, 2003 at 4:59 pm
Just Say No. Control when the shrinking takes place if you need to worry about it. Though I'd say if you are tight on disk space, you've got other issues.
Steve...
May 5, 2003 at 4:58 pm
Sounds like an exam question. Curious as to why you need this information, but I'll bite (a little).
DBMS - Database management system
RDBMS - Relational DBMS. Subset.
Single User v multiuser- what...
May 5, 2003 at 4:57 pm
A nice suggestion and one that I know people try to follow, but it can get difficult. I know as an author I often am trying to solve a particular...
May 2, 2003 at 1:34 pm
If you open a command prompt from the source to the destination and do a dir, do you have enought space?
Steve Jones
April 30, 2003 at 11:35 am
Actually it should import in row order if there is no clustered index. Are you expecting to "select" the data and get it back in this order? There is no...
April 30, 2003 at 9:35 am
Not a bad idea, though I suspect only a few of you (Antares) would be likely to spend the time to solve it. Course I could be wrong, but it's...
April 30, 2003 at 9:29 am
I hate this. IMHO, it's more of a pain, especially when you are on vacation or need some remote hands. Just my experience, but I tend to allow local admins...
April 29, 2003 at 9:46 am
Is the data a big deal? If not, use backup/restore. This is the simplest, cleanest and easiest.
Alternatively, you can script this with SQL-DMO and access the generate script for the...
April 28, 2003 at 1:01 pm
Hmmm, that's an interesting one. I suspect the only way is to block 1433 at the NIC level using the Windows networking setup. Use the IP config for the nIC,...
April 28, 2003 at 12:59 pm
Are you running the application terminal services or the remote admin? We run remote admin here and it doesn't impact very much. Running app mode will impact more as the...
April 28, 2003 at 10:08 am
You can also move on a backup and restore, but I would follow Allen's advice if you just want to move an existing db.
Steve Jones
April 25, 2003 at 10:18 am
Is there a reason you can't schedule it to run every minute?
You could do an xp_cmdsheel and "dtsrun" it, but I wouldn't recommend it. If you schedule it, then you...
April 24, 2003 at 11:48 am
Sorry, you're right. For some reason I misread your post.
But the last posts isn't right. Your W2K std will use all 4 CPUs, but the first virtual or logical processor...
April 24, 2003 at 8:44 am
you can set showplan_text on and post that. I'd be intersted to see as well. Pls include table DDL, insert trigger, indexes.
Steve Jones
April 23, 2003 at 9:23 am
Viewing 15 posts - 36,406 through 36,420 (of 39,810 total)