With OSQL -E you log on to SQL with Windows Authentication.

Check OSQL -? for all commands.

What SQLMAg says is that bcp is the fastest way to export data, and Bulk Insert the fastes for import.

The easiest way to change the filegroup of a table is through Enterprise Manager, in the design of the table, change the filegrop by clicking the new filegroup from a...

You will loose in performance if you have to growth the size of the data files frecuently, because SQL must ask for space to the system and allocate all the...

BOL means Books onLine. If you are talking about Error Log file, you won't we able to change it with sp_detach_db. You can change it trough the properties of the...

That will also depend of how amny transactions do you expect, and what type also. If you expect, many inserts, the growth in a period of time, will be different...

The Win user that starts the service, must be a member of the Local Administrators. And also check that the password doesn't expire.

Any locked or long running SPID ?

If SQL 2000 check the recovery model in the database option. Maybe you should reconsider changing to another mode if the Full mode is being used.

I don't think so, all the DBCC commands returns

DBCC execution completed. If DBCC printed error messages, contact your system administrator

Check from Enterprise Man. in the properties of the server, in the Security Tab the Audit Level. If you had checked any other than None, the server is auditing the...

The problem is that when you use Select Into it creates a nwe table with the result of the table you select. So, no other table must exists when you...

No maximum for any version. The limit is the Hard disk size. (OLTP)

To find the server name: Select @@servername

DBName:select db_name() (where you are running it)

DBO,size with sp_helpdb.

The server version with: select @@version

What you can do is put a password for a media set for a given database. And only the user with proper permissions to restore a database must know the...