Using fn_trace_gettable you'll need to supply the file and path and the number of files to read. As below

Load 10 files

select * into my_trace

from fn_trace_gettable('c:\mypath\mytrace.trc', 10)

Load all...

martin.kerr 34088 (1/11/2012)

---

Hi,

I found this from googleing my problem and it worked!

Create database with same name as MDF file you have.

Stop SQL Server and swap MDF files. Make sure you...

ok simple test, on the principal server go into administrative tools and open data source administrator. Create a new system DSN pointing to...

correct! Same for IP addresses too 😉

Dhirju (1/11/2012)

---

there r two server

1st one is primary server and

2nd server are two instances (Mirror and Witness)

both are running on two different ports, and both server in one...

what do you mean by this?

Are both instances on the same server?

peter Vramby (1/11/2012)

---

Hello,

I have a clustered (active-passive) SQL Server cluster running under version 10.0.4000.0 (SQL 2008 SP2 64-bit Enterprise Edition) where the syspolicy_purge_history job is failing.

When I try to run...

do you have any firewalls between the nodes (Windows or otherwise)

Try a telnet to the port from the partner node

Fully Qualified Domain Name, example below

my domain name is UKTrading.co.uk

my server name is SQLServer1

The FQDN for the server is SQLServer1.UKTrading.co.uk

To connect to this server in a mirror session using port...

even when you specify the FQDNs of the servers?

laddu4700 (1/10/2012)

---

Hi ,

Here is the weird scenario

One of our client prod database functioning in client place (as per agreement). We don't have access to our own application database.

Now for bussines...

Specify the FQDNs of the servers in the mirror GUI and try again

have you successfully created the endpoints?

Dhirju (1/11/2012)

---

The server network address "TCP://192.168.147.24:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are...

What gave you that impression!

Evil Kraig F (1/10/2012)

---

Microsoft isn't perfect, they know it. Debugging 30 trillion lines of code across all their software is difficult. Their partners being even less than they...