Viewing 15 posts - 20,386 through 20,400 (of 26,490 total)
Does this give you what you are looking for?
Had to add as an attachment.
June 18, 2009 at 12:54 pm
dh (6/18/2009)
insert into tblDirectory
SELECT
E_ID
,N_ID
...
June 18, 2009 at 12:43 pm
I rarely drink alcohol. Maybe a wine cooler or two on New Years Eve, else wise our house is relatively dry, by choice.
June 18, 2009 at 12:26 pm
foscsamuels (6/18/2009)
i'm trying to figure out how to remove policy number becasue there are multiple questions and answers for each...
June 18, 2009 at 12:06 pm
ps (6/18/2009)
thang_ngo_2002 (6/18/2009)
June 18, 2009 at 3:40 am
There are options you need to select in Enterprise Manager (I believe, its been a long time since I used it) that will allow you to include those in your...
June 18, 2009 at 3:31 am
In SQL Server 2000 you can either roll your own backup maintenance plans using stored procedures run at scheduled times using SQL Agent jobs, or you can use maintenance plans...
June 18, 2009 at 3:28 am
ps (6/18/2009)
hi_abhay78 (6/18/2009)
Why to apply so many differential backups when one would suffice 🙂
He's restoring to the reporting server everyday morning with diff backup...
log shipping would have been a better...
June 18, 2009 at 3:18 am
Since you are running your production database using the simple recovery model you don't have the option of taking transaction log backups.
Try restoring your database as follows and see if...
June 18, 2009 at 12:11 am
You may also want to read Books Online (BOL, the SQL Server Help System), as you may be able to use the STANDBY clause instead of the RECOVERY clause with...
June 17, 2009 at 9:54 pm
What is the recovery model of your PRODUCTION database? If it is using the Full Recovery model, you might want to look at using log shipping to keep you...
June 17, 2009 at 9:49 pm
Once you do a RESTORE ... WITH RECOVERY, no more backup files may be applied. If you are restoring this database daily for reporting using your current process, you...
June 17, 2009 at 9:47 pm
NEI. Not Enough Information. What exactly are you trying to accomplish? Is the mirror database used for any purpose during the day?
June 17, 2009 at 9:32 pm
First, why such a requirement? Second, I am not aware of any utility to accomplish this conversion. Third, if you rewrite the stored procedures as multi-lined table valued...
June 17, 2009 at 9:26 pm
Why would you want to eliminate policy_number? That is what relates the data together? It looks like if forms the Foreign Key relationships you need between the tables.
June 17, 2009 at 9:19 pm
Viewing 15 posts - 20,386 through 20,400 (of 26,490 total)