.NET, Java, PHP, C/C++, SAP, MainFrames, Testing, SQL Server, MySQL, Oracle Developer Links

Having problems using SqlServerCE 4.0 & Transactions / TransactionScope

Hi folks,

I've got some code which is throwing an exception when I use this against SqlServer CE 4.0 & within a TransactionScope. First, the code, then the error.

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :141 Vote Up: 0 Vote Down: 0

Merge data from two columns.

I have two columns. I am combining these two columns using Select ( FirstName + LastName) AS Name and assigning the datasource to a listbox.

The listbox shows the data without any space between the first and

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :108 Vote Up: 0 Vote Down: 0

Recovery from a Snapshot and applying Differential and Transaction Logs on top of it????

Here is the question:

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :93 Vote Up: 0 Vote Down: 0

SQL Server2005 transaction log

SQL Server 2005, Database recovery mode = FULL; Nightly Maintenance plan performs database full backup, followed by a transaction log backup
In spite of this, the transaction log for our production database is gro

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :121 Vote Up: 0 Vote Down: 0

How to Restore SQL Db with transaction log , while without bak files?
Hi team, I have a SQL 2000 server failed with RAID and lost some data. The latest tape backup completed is 18 Jan. We restore data from tape and its complete backup seems only to 12 jan. But transaction log between 13 and

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :78 Vote Up: 0 Vote Down: 0

Does moving table partitions need changing in any of the sys tables storing partition information?

Hi All,

I am having a scenario in which I am having a table which is partitioned. Every week a new partition is added to the table and consequently a new ndf file is added to the DB(new filegroup)&nb

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :51 Vote Up: 0 Vote Down: 0

Automated DPM SQL restore from one database to a reporting database???

Goal: Nightly DPM 2010 restore from clustered SQL Production database to overwrite Production Reporting Database on same server.

I know this cannot be done via DPM 2010 GUI and needs to be approached via D

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :98 Vote Up: 0 Vote Down: 0

Database Restoration Problem

Hello Everyone

While Restoration, I am getting an error "There is in sufficient system memory to run th query". Restore Database is terminating abnormally. But the drives have 35 GB of free space, wher

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :75 Vote Up: 0 Vote Down: 0

SQL Server 2008 Web Edition Clustering?

I cannot seem to get a clear answer to this and was hoping someone on the forum could clarify. We are rolling out an update to our hosted web application. The updated app will use new web servers and new SQ

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :65 Vote Up: 0 Vote Down: 0

SQL Server 2005 Cluster group can't take on line

Hello All !

I have some trouble with my SQL Server 2005 Cluster. This is my staging environment:

MS Windows 2003 Cluster MSCS (Enterprise Edition x64 US SP2 R2)

SQL Server 2005 Enterprise Edition x

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :50 Vote Up: 0 Vote Down: 0