Dat? I was trying to explain the permissions...

Any time... if it wasn't for newsgroups, forms, and many many blogs I follow .. I did be a lost too.

People on this form are great, some great people respond...

[font="Courier New"]DECLARE @T AS TABLE (Col1 INT, Col2 DATETIME, Col3 CHAR(1))

DECLARE @P AS TABLE (Col1 CHAR(1), Col2 DATETIME, Col3 INT)

INSERT INTO @T

SELECT 1,'12/1/2008','A' UNION ALL

SELECT 2,'1/10/2009','A' UNION ALL

SELECT 2,'3/15/2009','A' UNION...

FYI ... The permissions SQL Server uses to restore are that of the service account the MSSQLServer service is running under.

Mohit.

In the Maintenance plan if you click on the icon with in Maintenance window design the very last icon before "Servers..." (Reporting and Logging).

You can set the path there, by...

This is the new security model for 2005. Instead of granting the Service account local admin what 2005 does is when you install it; it creates a local group...

Table Size / Avg Index Fragmentation Percentage are two main ones.

The other ones to look at is Fill Factor & Pad Index; you should look at how your indexes are...

General practice is not to mix SQL Server with other applications because it can run into resource contention issues. However that said I have multiple installs where they are...

Another thing I use in addition to page information provided by Grant is .. avg_fragmentation levels. 1-25% re-org, 25% rebuild.

But again rebuild I only consider on very large tables.

Mohit.

Mirroring wasn't supported until SP1. If you have mirroring running on local computer you will not be able to use server.local; it will not work. You have to...

It should, 2008 and 2005 most of the catalogs are same; however I never used the function so I am unsure how well it will work ...

Thanks.

That value indicates how much of the memory is being used by security tokens alone. In SQL Server unless you are part of sysadmin group there is security tokens...

*cheers* :w00t: :w00t:

Now you get to deal with other fun parts of mirroring hehe; make sure you implement T-Log backups with full db backups on both servers. SQL Server...

No problem we can get Steve to relocate the topic, if he wishes. Can you please check if see if you have USER token issue?

Could you please run:

select sum(single_pages_kb+multi_pages_kb)...

Probably then a central server running SQL Server with desktop apps connection to the SQL Server.

Choice of lanugage then comes down to what you are comfortable with :). Thanks.