Viewing 15 posts - 36,361 through 36,375 (of 39,771 total)
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
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
Viewing 15 posts - 36,361 through 36,375 (of 39,771 total)