Viewing 14 posts - 16 through 29 (of 29 total)
Hi all,
I have worked on a solution to solve my issue for backing up and restoring to a different domain and server. The statement below is the job scripted...
October 15, 2007 at 10:06 am
yes, the results I first post give me that result set. But I wanted to know if there was a way of adding the Primary Key(ReasonID) with out affecting the count.
I...
September 17, 2007 at 5:00 pm
here are the two columns
[ReasonID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_Reason]
September 17, 2007 at 3:41 pm
Thanks for helping out
I will like to do both, the problem is since the reasonID value is unique, the NominationCount will be duplicated for each reasonID because as you see...
September 17, 2007 at 3:34 pm
The Primary key is coming from the reason table.
September 17, 2007 at 3:19 pm
NomineeFirstName NomineeLastName NomineeDept NominationsCount
AmanPreet Singh is 1
Dyana Pearson is 1
Jaime Maccou is 3
matt Chambers is 1
Paul Nelson is 2
Rukmini Yalamanchi is 2
Shannon Robison is 1
The Data results I will lke...
September 17, 2007 at 1:18 pm
Thank you for taking the time to respond. After reviewing my data I had found that some of the date information was updated and the time portion of the date...
September 13, 2007 at 4:59 am
Using SQL 2000
Backup
"C:\program Files\Microsoft Analysis Services\BIN\msmdarch.exe" /a ServerName "E:\program Files\Microsoft Analysis Services\Data" "DatabaseName" "E:\DBBACKUPS\olap\DatabaseName.CAB" "E:\DBBACKUPS\olap\DatabaseName.log"
Restore
"C:\program Files\Microsoft Analysis Services\BIN\msmdarch.exe" /r ServerName "E:\program Files\Microsoft Analysis Services\Data" "DatabaseName" "E:\DBBACKUPS\olap\DatabaseName.CAB" "E:\DBBACKUPS\olap\DatabaseName.log"
May 14, 2007 at 7:01 am
Create your account in AD and add that account to SQL server logins. assign appropiate permissions to the database.
July 25, 2004 at 9:10 am
You should be able to accomplish this using SQL mixed mode.
July 22, 2004 at 5:16 pm
The pegays database uses is own services accounts. What are you trying to accomplish?
You can associate windows authenication accounts if you setup up your SQL services using windows authentication
July 22, 2004 at 3:15 pm
You can add and activex scripts like this
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
June 11, 2004 at 11:36 pm
Check you dimension for error such as count, sum. The data type from your source to destination may not be the same.
June 11, 2004 at 11:17 pm
Great article. I do have a question; how can I output the results from master..xp_msver production to a table?
March 31, 2004 at 11:08 am
Viewing 14 posts - 16 through 29 (of 29 total)