Why did you choose to stop Mirroring? Were you trying to backup the Mirrored database?

When you stop mirroring, the databases can get out of sync. The...

You need to use the function Exec master..xp_readerrorlog and store the data into a table where you can filter it.

Declare @ErrorLog Table (LogID int identity(1, 1) not null primary...

I have a few questions that need further clarification:

1) Why does historical data change?

2) Can you use a timestamp column in the data feed to only grab the needed rows?

...

Alorenzini ,

This site does not take to XML docs very well, trying posting your XML doc with brackets instead.

The following example shows how to insert via using the...

Can you provide any sample data? It would make things easier for the both of us and would provide a more timely solution to your problem.

Thanks.

Adam

Are you connecting to a linked server? If so, you may have problems with the remote query timeout setting. By default this setting is at 600 seconds or...

Jeff,

Ritesh still should have to make sure the column header query option is set wheter it be for text or grid. Ritesh will only have to configure this on...

Click Query (Located on the main toolbar) --> Query Options --> Results --> Grid --> Include Column headers....(This should be checked)

Then select all the rows from your result set and...

MSDE 2000 is different that SQL Server 2005 Express edition. MSDE DID have the agent present, but SQL 2005 Express does not. If you are using the express edition,...

Have you tried to reinstall sharepoint services to an existing database?

http://office.microsoft.com/en-us/projservadmin/HA011653991033.aspx

Thanks for the feedback! 🙂

In future posts, mention that you need the code to work in Oracle too and you will get more vaild responses, as we had no knowledge...

This should help:

DECLARE @tbl TABLE(

Emp INT,

Supervisor INT,

Dept INT

)

--Emp | Supervisor | Dept

INSERT INTO @tbl

SELECT 1, 1, 1000 UNION ALL

SELECT 2, 1, 2000 UNION ALL

SELECT 3, 2, 3000 UNION ALL

SELECT 4,...

Do you have read/write permission on this directory? Try loggin into SSMS with an admin account to attach.

Great solution Gila 🙂

Bart,

Do not forget to remove column headers in the results to text; otherwise, you will have the word "text" before each stored procedure.

You will have to start the restore process again from the full backup onward. Were users connecting to the database and performing transactions after you brought the database online?...