- please provide the full statement exactly as you execute it !

(maybe even post the db create ddl)

- keep in mind, you cannot empty the primary file ! (it contains...

I bet it would go very much faster the other way around :w00t: :hehe:

Did you check these Database Mirroring Best Practices and Performance Considerations ? http://technet.microsoft.com/en-us/library/cc917681.aspx

- It is a very bad habit to use a domain admin account for sqlserver service account.

Always aim for minimal rights for any service account to keep doors as...

IMO easyest is to script it all and execute the scripts at the target instance.

Keep in mind to also script the granted usage rights.

What do you need to script ?

have...

Search SSC for "64-bit"

http://www.sqlservercentral.com/articles/News/abitabout64bit/1360/

http://www.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/

and off course at MS.

You should also be more specific as to what you are trying to ship to your client.

Content of a single table vs content of multiple tables, a filegroup, a full...

This should really be handled by your user interface.

Since you state that is not an option, I guess you will be exporting sql data using query analyser or bcp.

In that...

Lutz pointed you to Lynns great article .

One thing to keep in mind, especially with datetime, but it also goes for other datatypes:

Keep your data in the original datatype as...

just my 2ct

IMO you are trying to persist some kind of state of your "client" session.

An option can be to add a session identifier to your row a key component.

Another...

What Windows version and edition are you on ?

(x86 / x64 / ia64)

repent_kog_is_near (10/27/2009)

---

just want to make sure I got it:

so if I reset the errorlog, then I should be able to see the setting/option for LPIM in the erorrlog right after...

I know it is on x64, I haven't enabled it on 32bit.

This info is written at sqlserver startup time.

To prevent ending up with xMB of errorlog file size, many choose to recycle the errorlog file using the commands I posted.

If the...

http://technet.microsoft.com/en-us/library/ms190730%28SQL.90%29.aspx

states:

The Windows policy Lock Pages in Memory option is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). This policy determines which accounts can use...

You will not find this info is the errorlog has been rolled over.

e.g. using "EXEC sp_cycle_errorlog" or "DBCC errorlog"

You should find it after a fresh start of the sqlserver instance.

Else...