Hi,

I am in the same situation. I need to modify the size of the tempdb lower than its current size. Can you please post the command how you did...

Hi,

By restoring it that way did not you loose the logins and linked server information stored in your original master database? How did you recover those?

Thanks

Ameena

Check out this post with possible solution to your problem.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/37b67e29-9107-4837-a8fe-734fe83d09f9

Database has log file and data file. When you shrink database you are shrinking both files. When you are doing shrink file, you can define which file you want to...

If you want all table and procedures, why not use the production database backup to restore the database on your laptop? you can automate this through a job also.

If...

After adding the server with 'local' in the query and restarting sql server did the trick.

Thanks to both of you for your replies.

USE [MyDB]

GO

EXEC sp_addrolemember N'db_datareader', N'username'

GO

EXEC sp_addrolemember N'db_datawriter', N'username'

GO

Grant Execute to 'username'

GO

select s.name, j.command from msdb.dbo.sysjobsteps j

inner join msdb.dbo.sysjobs s

on s.job_id=j.job_id

where command like '%sqlbackup%'

What Anum Verma suggested will also work exactly the same for SQL Server 2005. You did not mention what version of 2005 you are using. If you are using express...

As per Microsoft Pricing http://www.microsoft.com/sqlserver/2005/en/us/Pricing.aspx

Developer Edition

May be installed and used by one user to design, develop, test and demonstrate your programs on as many systems as needed.

Includes...

What you are looking for is data masking. In my previous company, we used functions with custom algorithm which would change data in development every time it is refreshed from...