Viewing 15 posts - 36,301 through 36,315 (of 39,717 total)
Not sure why'd you'd want program files. Easily installed on any servers. The important data is in the data backups.
Steve Jones
May 7, 2003 at 4:53 pm
EM looks through the table and scripts out all object changes that need to be done.
and you're welcome.
Steve Jones
May 7, 2003 at 4:11 pm
Sorry to hear that Chris, hate days like that.
I can't believe MS left you hanging. I've had a few calls that ran over 24 hours and I was transferred from...
May 7, 2003 at 9:34 am
It can be through a script, but you need to know what you want. Which tables/views/procs need which rights, select, insert, update, delete, execute?
Also, I'd use Roles for this, not...
May 7, 2003 at 9:32 am
In Enterprise Manager, Expand the Management folder, then right click SQL Agent and select start. Should start. If not, post back with the error (check SQL log and Event logs)
Steve...
May 7, 2003 at 9:24 am
sp_rename [ @objname = ] 'object_name' ,
[ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]
Steve Jones
May 6, 2003 at 10:38 am
I do not think so. You can export the logins and detach the databases, uninstall and the attach the databases.
Steve Jones
May 6, 2003 at 10:08 am
Haven't seen this one. Is this with NT Auth or SQL Auth?
Steve Jones
May 5, 2003 at 5:04 pm
Andy recently did some studying and wrote an aritlce on the VB.NET exam.
http://www.sqlservercentral.com/columnists/awarren/westudiedwepassedwasitworthit.asp
Steve Jones
May 5, 2003 at 5:02 pm
I do not believe you can do this. you;d have to rebuild the table, which is what EM does if I remember right. Basically, rename your table, create a new...
May 5, 2003 at 5:01 pm
Works on views as stated above, not stored procedures.
Steve Jones
May 5, 2003 at 5:00 pm
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
Viewing 15 posts - 36,301 through 36,315 (of 39,717 total)