Viewing 13 posts - 1 through 13 (of 13 total)
Error :
Restore failed for Server '' (Microsoft.SqlServer.SmoExtended)
Additional Information
System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.00.1600.
That version is incompatible with this server, which is running...
April 19, 2009 at 7:43 am
I think in default trace only few events are logged in
By using the below sql statement we can view the trace details
SELECT * FROM fn_trace_gettable((select path from sys.traces), default);
But it...
April 17, 2008 at 6:06 am
Thank you for your response.
If 3rd parties can do this one then why Microsoft is not creating a tool for this?? :cool::cool::cool:
Any way which one is recommended tool??:D:D
April 17, 2008 at 5:27 am
Dear Sanuj,
Try This....
First execute below listed 2 queries and store the results
Query1
SELECT 'ALTER TABLE [' + o2.NAME + '] NOCHECK CONSTRAINT ' + o1.NAME
FROM sys.foreign_keys o1
...
April 17, 2008 at 4:04 am
Use Copy-Modify-Merge Model in Visual SourceSafe or remove .ssmssqlproj file form the Visual SourceSafe
This is...
March 20, 2007 at 1:09 am
Sorry , I didn’t notice that the post is in the SQL Server 7, 2000 T-SQL section.
March 17, 2007 at 6:39 am
CTE is a temporary view defined within the scope of an executing statement; CTEs are almost same as the derived tables
March 15, 2007 at 10:03 pm
Please try the below given script
WITH CHDetails(Item, Cost, CostDateFrom, CostDateTo) AS
(
SELECT Item,
...
March 14, 2007 at 10:47 pm
Hi All,
Thank you very much. I will check my code and close if there is any open recordset exists.
Thanks and Regards
Sajan
August 25, 2006 at 10:21 pm
First create a DTS Package using export wizard, then we can customise the package
August 24, 2006 at 6:30 am
Greg,
Thanks for your reply, But I have some doubts. please help me to clarify these things
Am creating the DTS package through a VB Application using the Structured Storage File. Am...
May 9, 2006 at 6:17 am
Viewing 13 posts - 1 through 13 (of 13 total)