There are two things you should do.

To get rid of Class not registered issue, install the 32 bit version of SSIS on the server.

To get rid of the other OLE...

Thanks for this. smart programming.

do you have partitioned tables in the database?

I think I had the same issue. I was able to remove all the file groups using the method i explained but one.

Ty this query. Replace the FileGroup0 with your...

This is a bug with SQL server. HEre is the workaround.

1. Add another file to the same file group

ALTER DATABASE DBNAME

ADD FILE

(

NAME = Data_File_Name,

...

GSquared (4/7/2008)

---

I have to agree with SDM. Just because, in general, a clustered index on an alpha field (char, nchar, varchar, nvarchar) is usually a bad idea, doesn't mean...

This is what you have to do.

1) Grant "Trusted for Delegation" to your SQL server's service account (NT account)

2) Add an SPN to your SQL Server using Setspn -A command

once...

OK, firstly sorry if my writing is bit confusing. i'll try to clear it up with this explanation.

My first example which updates the newzip column, is actually to demonstrate the...

Yes, I agree with you guys. the Design is crap here, but my solution is for people who cannot change the whole design to add a new column to a...

Remeber very carefully. Don't ever set a default value when you add a new column to a table with such a large number of rows. Becasue it is no different...

Try adding "Trust for delegation" to your Windows user account if you got this error in SQL 2005.

 

My SQL 2000 is not 64 bit but it was running on 64 bit OS. I haven't done anything to the dll.

I think my dll is compatible with 64bit OS...

sp_helpdb shows you the maximum size of the file not the size actually used by the data in the files.

To find out the actual size of a sparse file

To learn...

Snapshot database and Snapshot backups are two things.

Snapshot database is always <= Original database becasue it only contains the changed data.

Snapshot backup is more complex subject not direclty relevant to...

Hi, how does the unchanged data is accessed from the snapshot? are they accessed directly from the Source database? if so woudn't that be a problem for the source database...