You can GRANT EXEC on the schema. This would allow the user to execute all stored procedures in the schema, even when you create new ones.

I don't think you can import the diagram from Access to SQL server. Why can't you just create a new diagram in Management Studio?

If your data is very important, why don't you have a backup?

Vishal Singh (11/25/2008)

---

HI Thanx for the reply..I still have one doubt..

when I execute this query how it will populate the data. will it consider all the existing queries on the...

As Tom already said the answer is no. The ldf file only contains the transactions since the last tlog backup, but not the data.

You need to restorew from backup, if...

The easiest way to get this kind of info is to install the SQL Server performance dashboard. You can get it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

As an alternative here are two queries from MS:

...

Mani,

the "problem" is that you're restoring from Enterprise Manager. EM hangs as soon as the server shutsdown after the restore and all you can do is kill the process. It's...

If your looking for info about the actual upgrade\migration you should check out the "Technical upgrade reference guide" from MS.

You should add the user to the database role db_securityadmin.

From BOL: Members of the db_securityadmin fixed database role can modify role membership and manage permissions.

The only way to audit SELECT queries is by running a trace. There is some performance impact, but if you write the trace file to a different disk then your...

Actually, that's exactly how it should be.

After restoring the master database SQL Server will shut down.

You can then remove the -m parameter and start the server in multi-user mode...

Storage might not be an issue on your disk, but it...

Sorry, but there is no such command. While it's possible to remove somethings from SQL Server memory using DBCC commands, that won't release the memory to the OS.

You can use RESTORE HEADERONLY to get the contents of a backup device.

In the result look for a column called Backup_TypeDescription.

RESTORE HEADERONLY

FROM DISK = 'C:\myBackup.bak'

If you configure BackupExec to make incremental backups it will only write the new backup files to tape.

I also wonder why you need to keep 2 weeks of backups...