Viewing 15 posts - 1,441 through 1,455 (of 2,496 total)
You can use DTS in both SQL Server 2005 and 2008. You need to install the 'DTS Designer' component from the SQL Server Feature Pack.
On SQL Server...
March 9, 2009 at 10:22 am
I assume you do have enough space in other file in the filegroup to hold the last bit of data? Otherwise all I can suggest is Googling this problem...
March 4, 2009 at 2:58 am
When I was developing on DB2 m/f all I used was BEGIN TRANSACTION and END TRANSACTION...
...I sometimes used to add some SQL in the middle...
and I just remembered that DB2...
March 3, 2009 at 10:14 am
Does DB2 mainframe v7 support the MERGE statement? I don't know when this sttement got to the various DB2 versions. If it is supported then it would be...
March 3, 2009 at 9:07 am
I am not sure what bit of the SHRINKFILE processing causes it to fail after the EMPTYFILE keyword is used, but fail it does. Even if you issue a...
March 3, 2009 at 5:17 am
Have a look at the services running on the box. If Notification Services is not there then it is not installed.
Be aware that Notification Services is deprecated in SQL...
March 3, 2009 at 3:25 am
I would recommend going to 64-bit SQL Server 2008 running on Windows 2008. This will give you a platform that will remain current technology for a few years to...
March 3, 2009 at 3:23 am
I hope you get this to work - you seem to be getting through most of the problems.
Oracle does indeed deal with NULL values differently to SQL Server and DB2....
March 3, 2009 at 3:20 am
The SQL Server FineBuild Reference manual has a good description on how SQL proxy accounts are used, how to create them, what security is needed, and best practices for SQL...
March 3, 2009 at 3:12 am
In my experience, once you have used the EMPTYFILE keyword on a shrink, you must do a OS close and open on the file before you can drop it.
Stopping and...
March 3, 2009 at 3:02 am
SQL Server 2005 SSRS needs IIS on the box before it will install. All other components will install without IIS being on the box.
SQL Server 2008 SSRS does not...
March 3, 2009 at 2:53 am
Gift, you are right. On re-reading the thread I see the OP problem has nothing to do with the .Net level.
February 26, 2009 at 8:04 am
You can get some multi-layer insulation that may do what you need. It is similar in concept to what NASA use to insulate spaceships. There are a lot...
February 26, 2009 at 5:30 am
SQL Server needs components that are at the .Net 2 level and will not use the equivalent .Net 3 components.
Do not be surprised if you have problems installing .Net 2...
February 26, 2009 at 5:21 am
Retro-fitting insulation is an established practice in some parts of the world.
In Switzerland, the government periodically raises the insulation requirements for offices and apartmement blocks. Compliance with the new...
February 26, 2009 at 4:29 am
Viewing 15 posts - 1,441 through 1,455 (of 2,496 total)