Viewing 15 posts - 91 through 105 (of 140 total)
Hi there,
If you are doing this regularly you might want to look at using a tool such as Red Gate's SQL Compare [Schema comparison and migration] and SQL Data Compare [Data...
March 8, 2007 at 2:44 am
The quickest way to do this (but I'm fairly sure not the most efficient) would be to do the following:
Create the table in your target database (right click the table...
March 8, 2007 at 1:32 am
Sounds like that user's default database is screwed in some way (might be permissions, the database might be offline or suspect etc..). You need to login as an administrator and...
March 8, 2007 at 1:24 am
I used to live about 2 miles away from a nucelar power station and spent quite a lot of my youth swiming in the sea by the plant's cooling water...
March 8, 2007 at 1:13 am
Hi there,
Do you have the output from the command - IE any errors reported. You probably dont want with recovery because as soon as you issue a command using WITH...
March 7, 2007 at 6:24 pm
Have you followed the steps outlined here: http://support.microsoft.com/kb/811889?
http://blogs.msdn.com/sql_protocols/archive/2005/10/15/481297.aspx might be worth trying first though.
- James
March 5, 2007 at 2:23 am
Hi,
I think you probably want somthing along the lines of:
CREATE
PROCEDURE sp_Project_Step_Cost
@MS_ID varchar
(10),
@Project_Phase_ID
INT
AS
March 5, 2007 at 1:29 am
I dont think its offically support as Balmukund and MarkusB pointed out but I have certainly had it running in a VMWare instance before (both x86 and x64 guests) with...
March 3, 2007 at 4:47 am
You might also be better looking at some other "serialization" mechanism so you get one table per grid rather than one big table as this is likely to perform better....
March 3, 2007 at 4:39 am
Hi Tom,
SP2 treats 2005 maintenance plan units (IE delete maintenaince history after x days and delete history after x days) as hours rather than days. So if your maintenance history...
March 3, 2007 at 4:36 am
Stefano,
The principle of log shipping is fairly simple, microsoft dont give you all the niceties in SQL Server Express but you can still get pretty much the same functionality.
The first...
March 2, 2007 at 6:24 am
Stefano,
There are several options - the first would be some sort of log shipping mechanism - however this is generally only a unidirectional process and you would have to reseed...
March 2, 2007 at 4:28 am
Stefano,
Are both databases being updated or just one?
- James
March 2, 2007 at 3:06 am
Somthing along the lines of
UPDATE
tableName SET data = CASE
March 2, 2007 at 2:37 am
There are several articles on SSC and some other good resources around the web..
Picking an edition: http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Feature sets: http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp
Migration: http://www.sqlservercentral.com/columnists/vRainardi/migratingdatawarehousesystemstosqlserver2005.asp &
http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp
An Upgrade handbook from Microsoft: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Other...
March 2, 2007 at 2:20 am
Viewing 15 posts - 91 through 105 (of 140 total)