Thanks derrickleggett... I run EXEC sp_changeobjectowner 'xyz.employee','dbo' It works fine now.. Reagrds..
Hi there I have one table "employee" owned by 'xyz', and this xyz is member of sysadmin, db_securityadmin and db_owner. I login to a database...
Thank u Satya.. it works fine now.. Essam
Thanks Satya.. I tried the scripts, but it gave permissions to DB roles NOT the server roles ( like if there are login users and members of System...
I'm hoping some of you can help me out.<br /><br />When I restore one DB, I used the procedure sp_help_revlogin to create logins with the original...
I am implementing merge replication between 2 Databases running on SQL2000, when I try to modify a structure of one table in the publisher database,...
Bambola: the figures after I ran DBCC SHRINKFILE(data_file, 10) are: CurrentSize: 831080 MinimumSize: 128 UsedPages: 831072 EstimatedPages:...
DB Backup size = 3.9 GB size of Tlog = 10 MB ( I truncate Tlog on daily basis ) the result of SP_SPACEUSED : reserved : 8.3 GB data : 1.5 GB...
Dear Gaurav, OK if there is no way I can decrease the MDF data file beyond 8.3 GB, i want to know why after transfering the same dta( all tables,...
I used sp_spaceused and I found the same figures..(data size ~8.3 GB).. today, I did a small experiment: i transfered All tables, views, proc., etc...
Enterprise manager, right click on DB, choose properties, then on Data File tab, in space allocated (MB), I find 8.3 GB as MDF size..! Any...
Thanks Bambola.... Actually, I rebuilt indexes as you advise me and I ran SHRINKDATABASE, but it reduced by 200 MB only..! is there any alternate...
Dear All; I have a huge primary MDF - ~8.3GB. I've tried all the actions I know of to reduce the physical size of it... Backup up the DB, Backed up...
Separate names with a comma.
