Viewing 15 posts - 1 through 15 (of 64 total)
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...
August 10, 2010 at 9:34 pm
Thanks for this. smart programming.
June 23, 2009 at 10:01 pm
do you have partitioned tables in the database?
March 24, 2009 at 7:10 pm
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...
March 24, 2009 at 4:28 pm
This is a bug with SQL server. HEre is the workaround.
1. Add another file to the same file group
ALTER DATABASE DBNAME
NAME = Data_File_Name,
March 22, 2009 at 5:05 pm
January 7, 2009 at 5:08 pm
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
July 24, 2007 at 11:36 pm
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...
May 23, 2007 at 5:46 pm
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...
May 23, 2007 at 5:31 pm
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...
May 23, 2007 at 5:19 pm
Try adding "Trust for delegation" to your Windows user account if you got this error in SQL 2005.
April 23, 2007 at 9:47 pm
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...
December 20, 2006 at 6:34 pm
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
December 11, 2006 at 6:09 pm
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...
December 11, 2006 at 5:44 pm
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...
November 28, 2006 at 10:49 pm