You should find them in the LOG directory: X:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Drive letter and full path may vary depending on how you installed your instance.

You can use this query to...

Well the filename usually follows "Log_XX.trc". With "XX" being a sequential number as the trace file roles over to a new file.

If you are wanting to look through older trace...

If you keep the trace files from your default trace then yes it should be. The downside is if you want to query it, you will have to load in...

Well I played around with the local instance I have running on my desktop and by just running the copy database wizard, choosing detach/attach method I copied a database. Then...

Dan.Humphries (4/25/2011)

I am curious about this part. ...

If you just...

Well have you tried to search for the error?

If not I would suggest enabling remote access to the SQL Server instance you are trying to connect to.

exec sp_helpsrvrolemember 'sysadmin'

exec sp_helpsrvrolemember 'serveradmin'

32-bit architecture address space is limited to no more than 4GB. If you have a server with 8GB, it will never use more than 4GB of it. That is the...

Unless I'm mistaken when you purchase the license for Window Server and SQL Server they are not dependent upon 32-bit or 64-bit. You are allowed to use either architecture. You...

SQL Server PowerShell (sqlps) only comes with SQL Server 2008+

How are the other objects you are transfering added?

Can you provide the full code...

Not to sure what you mean by anonymous user. For anyone to connect to your SQL instance they first have to have a login active, then a user account to...

If you are in a domain yes. I believe you still can if you are not in a domain. I'm not to sure on that one, it has been a...

To add on to that if at all possible I would use a Windows authenticated account, versus a SQL Login (what the sa account is). It adds a little bit...