If You Are Associate With CALL CENTER, Then See
Mar 23, 2007(Spam Removed)
View 1 Replies
ADVERTISEMENT
Best Way To Associate One To Many Setup...
May 8, 2008Hi. We're trying to setup a new case management system and I'm having a problem trying to store some of the information. I think I know how to go about it; however, I'm not sure if it's right.
We have two tables: Cases and Clients. The cases table stores relevant case information like case number, case type, etc. The Clients table stores information like name, address, phone number, email, etc.
What is the best way to associate these two tables together? I'm assuming I need a third table. Right? Thanks!
Question: Re-associate Dbo With Sa??
Dec 28, 2006Hi all.Running SQL2K SP4 on W2K3 Standard, SP4.I have just refreshed a database on one server with a backup fromanother. The database had existed previously on the target server, andI am just refreshing its contents. I used the following approach1) From the target server, create a SQL script with users and roles2) From the source server, back up the db3) Transfer the file4) Restore the db, checking the location of the data and log files toensure correctness5) Remove orphaned users6) Run in the users/roles script generated in step 17) Run in a canned script containing object-level grants.I've done this dozens of times in other databases, but something alittle unusual has occurred here:My dbo user is orphaned. Normally it's associated with the 'sa' login,but at this point there is no associated user.I can see why this has happened - on the source db, the dbo user hasbeen associated with a non-default login.And, many of the objects in the db are owned by dbo.The only viable option I see is to change the ownership of theseobjects, drop dbo, re-add it with the association to sa, and reassertthe object-level grants.But what I would prefer is some way to change the association of thedbo user, to associate it with 'sa' without the need to drop andrecreate.Can anyone suggest an alternative strategy to associate a login and auser after-the-fact?Thanks much for all input!BD
View 4 Replies View RelatedCan You Associate A Task/job With A Report?
Aug 16, 2007Hi there,
I'm wondering if there is a way to associate a job or task of some kind (i.e. SQL Agent job or SSIS package) with the generation of a report?
I have a need to provide an on-demand report that somehow initiates the updating of its data source prior to generation. In other words, I'd like the report to do *something* that can start an external process (external to the report) and wait for that process to complete before proceeding with the report generation.
As you can probably tell, updating the data source is expensive. It is normally scheduled along with a scheduled report, but I'd like the report to be runnable on demand when that is (rarely) the need, and I'd also like to guarantee the data source is updated when the scheduled report runs, which I can only do if I can somhow create a dependency between the updating process and the report generation.
Any ideas?
(The only way I can see to execute code synchronously from the report is to build a custom data processing extension/provider, which is fairly absurd.)
Thanks
Sam
Associate Each Product With Multiple Bikes (was How Should I.....)
Aug 26, 2006Hello, im brand new to these forums, scrolled through a bit of the forum(mainly trying to figure out how to go about what im about to ask) and it seems like a good forum...anyways onto my question.
i am in need of ideas/know-how on how to structure a database like such:
its an online motorcycle accessories website, and this is the information i need to store in the db(basically these will be my tables in the db)
bike manufacturer
bike name
products
now my main question is how would i structure those tables so i can get this effect.
each product in the product table needs to have a bike associated to it, 99% of the time it will be more than one bike associated to it, so how would i go about doing that?
originally i had set it up with the bikes name being different columns in the products table with a bit type set to 1 if that product was available for that bike and 0 if it wasnt available. however as you are probably already thinking that isnt the best way to do that.
so what is the best way?
any info at all would be greatly appreciated.
thanks in advance
How Do I Associate A Sql Server Login With The SQLAgentUserRole?
Aug 21, 2007Currently a 2005 login has been granted sysadmin because I can not figure out how to grant the same login the SqlAgentUserRole. I thought I would use SSMS but there must be a trick. The role only exists in the msdb database, which the login has not been granted explicit access to. And the login does not appear in the list of Role Members or its sub windows. This should be real easy and intuitive . . .
Thanks!
Michael
Data Mining : Associate Rules
Aug 21, 2006i begin for Data mining ( analysis manager - sql server 2000)
i create some mining model with Microsoft_decision_ trees or Clustering. it's oK
but now i want to create a model to know "If customer 1 has product A in their basket, what products should I recommend ".
i read and see that "Microsoft analysis manager sp1" have support association rules.
i install pack 4. but i don't see anything else . how i create a model with association rules.
Media Center
Jan 30, 2006Help, I'm trying to burn a CD using Windows Media Player 10. I keep getting the message-interface not registered. I tried to download WMP, and it says it cannot because there is already a more recent version already installed. Should I uninstall WMP, and then reinstall it. If so, how do i do that, I cannot find it on the control panel!
Thank You for your help
Re-associate Server Login With Database User?
Nov 22, 2004Hi all, I've had this issue in the past but dealt with it in a way that I don't think is correct:
Let's say I have a database on Server1. On Server1 I create a login and a user on the database. Now I have User1 with a login authorization on Server1 as well as a user within my database. If I detach that database now, and re-attach it on a different server, User1 exists. Of course, on the new Server2 User1 does not have authorization to login. I've deleted the existing user in the database and then re-created a login on the server, cascading through with the GUI setup to re-create the user within the database, too. Of course this gets ugly if the user has objects within the database. If I create a server login with the same name as the database user the login is not associated with the user too, correct?
I'd like to know the way that I can create a server authorization tied to the existing database user without dropping that database user, preferably within Enterprise Manager.
Thanks all,
MC
Associate User's New Objects With Data File
Apr 20, 2007I'm currently running SQL Server 2005, and have been exploring the feasibility of grouping users to use a default file group and data file. This would be to group a set of users to have their new tables reside in a specific data file. I only see mechanisms for moving an already existing objects into a file group or to set the entire databases default file group--not a user level association or dynamic assignment of the default for that user, script, etc.
It's not looking good.
I'm looking for confimration that it's not possible or leads on doing so.
Thanx in advance
SQL 2005 On DATA CEnter
Apr 4, 2007Hi another sql 2005 question I hope someone has tried this
Okay I want to load data center 2003 with two nodes
Can I set up SQL 2005 and utilize all 8 processors for SQL (As a Cluster)
I know you get DB mirroring and log file shipping ,that is not what I want
We will set up a DR soloution if the above works
So basically
Windows 2003 Datacenter across two 4 64bit Server 4GB ram each
once loaded can I install SQL 2005 and utilize the processors across both platforms
Thanks
Items Centered Or Right Of Center Shift Far Right
Dec 27, 2007Hello,
I have a BIDS project with 14 reports, all formatted the same way. On one report, any text box or image that is placed in the center or right of center in the form, shifts very far to the right of the tables and charts when it's rendered.
The text box placed at the top left of the form stays put. This is really wierd.
Has anyone ever heard of anything like this.
I have a couple of screen shots if you have a place I can put them.
Thanks
Dan
The December CTP From The SQL MSDN Developer Center
Dec 26, 2006Hi
Is this an upgrade for sql server 2005 express.
If I already have Sql server 2005 express must I still download
the whole file.
Rgds
Rob
Installing SQl Server 2000 (2k) On Media Center
May 16, 2006Hi, hope someone can help...
I'm trying to install SQL Server 2000 on my XP Media Center laptop and keep getting the "this operting system is not supported message"
Any ideas?
Many thanks....
Cannot Install SQL Express On XP Media Center Edition
May 30, 2008Hi,
This is my first post. I am trying to install SQL express on my PC but it keeps on having this error:
"encountered an unexpected error in datastore. The action is setdialogs..."
I have searched far and wide for a solution to this problem. Some solutions worked for others, but none worked for me so far.
I don't have a previously installed sql version on my laptop. But just to check, I followed the steps in using msiinv.exe to detect any previously installed software. I am pretty sure that there was no sql server entry in the output file.
I have all the requirements, installed (.net framework 2.0,etc). I have all the latest Windows updates (except XP SP3).
My laptop is well above the minimum requirements for sql express ( Core 2 processor, 2 gigs ram, 7Gigs free space).
I have the Protected Storage service running (which I found out was required to install sql server).
I even followed the directions to fix Cryptograhical services.
I am runninng out of options here.
Thank you for your replies.
Here's my log:
[code]
Microsoft SQL Server 2005 Setup beginning at Fri May 30 11:20:48 2008
Process ID : 564
c:487084033731d74b14setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/4/30 11:20:48
Complete: LoadResourcesAction at: 2008/4/30 11:20:48, returned true
Running: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48
Loaded DLL:c:487084033731d74b14xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/4/30 11:20:48
Complete: ValidateWinNTAction at: 2008/4/30 11:20:48, returned true
Running: ValidateMinOSAction at: 2008/4/30 11:20:48
Complete: ValidateMinOSAction at: 2008/4/30 11:20:48, returned true
Running: PerformSCCAction at: 2008/4/30 11:20:48
Complete: PerformSCCAction at: 2008/4/30 11:20:48, returned true
Running: ActivateLoggingAction at: 2008/4/30 11:20:48
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00E4CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
[/code]
Reporting Services :: How To Display Report At The Center Of Browser Using ReportViewer
Sep 30, 2008I have designed plenty of reports in VS 2005 and have been deployed on the reporting server. I have been designed one web page which shows UI through which user can access which ever reports he/she wants. I have kept some buttons on UI. When button is clicked appropriate report accessed and displayed on the browser.
Â
Problem is that, report width is about 40 - 50 % of the screen and report viewer shows the report on the left align of the screen. I just want to show the report at the center of the screen. Also, any property I can use to set the report size in the proportion of screen in Percentage(%).
Problem With Sync O2 Mini With Windows Mobile Device Center
Sep 9, 2007
I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.
A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.
Thanks.
SQL Server Admin 2014 :: Setup Database Part Of Data Center?
Apr 8, 2015My company is migrating all their servers to a new data center and I get to specify what we need for the db servers.
We've got a 22 prod servers (mainly physical) with a couple of TB of data on sql 2000 to 2012.
We expect to move to sql2014, and consolidate and virtualise where ever possible.
But I'd like start with specifying an overall architecture for this: some Best Practices to guide the build at a server and an installation level
I Just Want One Entry For Each Call, With SLA Status 'Breach' If Any Of The Stages For The Call Were Out Of SLA.
Mar 19, 2008Hi,
I am producing a php report using SQL queries to show the SLA status of our calls. Each call has response, fix & completion targets. If any of these targets are breached, the whole SLA status is set as 'Breach'.
The results table should look like the one below:
CallRef.
Description
Severity
ProblemRef
Logged
Date
Call
Status
SLA Status
C0001
Approval for PO€™s not received
2
DGE0014
05-01-06 14:48
Resolved
Breach
C0002
PO€™s not published
2
DGE0014
06-01-06 10:21
Resolved
OK
C0003
Approval for PO€™s not received from Siebel.
2
n/a
05-01-06 14:48
Investigating
OK
Whereas I can pick the results for the first 6 columns from my Select query, the 'SLA Status' column requires the following calculation:
if (due_date < completed_date)
{ sla_status = 'OK';
}
else sla_status = 'Breach';
The Select statement in my query is looking like this...
Select Distinct CallRef, Description, Severity, ProblemRef, Logdate, Status, Due_date, Completed_date;
The problem is that my query is returning multiple entries for each stage of the call (see below), whereas I just want one entry for each call, with SLA status 'Breach' if any of the stages for the call were out of SLA.
CallRef.
Description
Severity
ProblemRef
Logged
Date
Call
Status
SLA Status
C0001
Approval for PO€™s not received
2
DGE0014
05-01-06 14:48
Resolved
Breach
C0001
Approval for PO€™s not received
2
DGE0014
05-01-06 14:48
Resolved
OK
C0001
Approval for PO€™s not received
2
DGE0014
05-01-06 14:48
Resolved
Breach
Any help will be much much appreciated, this issue has been bothering me for some time now!!!
Install Developer Edition On Windows XP Media Center Edition?
May 13, 2007
Can I install SQL Server 2005 Developer Edition on XP Media Center Edition?
Thanks.
Feedback Regarding Feedback On The Feedback Center
Mar 10, 2006Just a note to the MS guys...
I'm fully supportive of the product Feedback Center initiative and the subsequent withdrawal of sqlwish.
Problem is, if nobody ever gives us feedback on the things that we submit then it simply is a glorified version of sqlwish with no added value.
I apologise if there are plans afoot to address to offer feedback to the things we put up there but I (and others) have been freely submitting bugs and suggestions for a few months now without hearing anything back and I'm beginnign to wonder why we bother.
Even a simple "This is a good idea and will be considered for Katmai" or "This is a terrible idea now go and stick your head back in the sand" would be better than a cut and pasted response which is just about all I've seen so far.
Comments???
-Jamie
Getting One SP To Call Other SPs
Jan 8, 2008I've written a T-SQL stored procedure that I want to call other stored procedures. The opening part of it looks like this:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[spArchive] @dtArchiveBefore DateTimeASEXEC spArchiveAHD @dtArchiveBeforeGOEXEC spArchiveContract_History @dtArchiveBeforeGOEXEC spArchiveContracts @dtArchiveBeforeGO But I'm getting this error repeatedly: Msg 137, Level 15, State 2, Line 2 Must declare the scalar variable "@dtArchiveBefore".I've searched for this term but can't figure out what's wrong with my code.Any ideas?Robert W.
View 4 Replies View RelatedCall Dll
Aug 27, 2001Hi, There,
Do you know when should I use extend sp to call a dll file, and when should I use sp_OACreate to call dll. It seems only dll created by C++ can be called from extend sp, how about VB created dll?
Thank you very much
Tony
Call A SP From Another SP
Jun 23, 2008MS SQL 2005
I developed several SP that update tables
If I execute them one by one in the SQL Sever Management Studio, they work ok
Now,
I want to execute them all inside another SP
I wrote it (attached code)
Execute it and give me a message that runs successfully but that is not true
May anyone of You tell me the right syntax to do it?
[Code]
USE REPORTES
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATEPROCEDURE dbo.Astral_sp_Acumula
AS
--
EXECUTE [REPORTES].[dbo].[Astral_sp_AcCpasArtC]
GO
EXECUTE [REPORTES].[dbo].[Astral_sp_AcDevArtC]
GO
EXECUTE [REPORTES].[dbo].[Astral_sp_AcVtasArtV]
GO
-- More sp executions
[Code]
Thanks
JG
Sql Call
Apr 3, 2006i have made a .sql file in which i want to call another .sql file
plz tell me the syntax for it
Want To Call SP From Another Sp
Sep 21, 2006Hi all,
I have 2 tables like that
CREATE TABLE tab1 (
id int IDENTITY (1, 1) NOT NULL ,
master varchar (50) NULL
) ON PRIMARY
GO
CREATE TABLE tab2 (
id int IDENTITY (1, 1) NOT NULL ,
student_name varchar (50) NULL ,
master_id int NULL
)
Now i want to create a Sp
which is
create proc inner_sp(@s1 varchar(50))
as
insert into tab1(master) values (@s1)
and i want to call it from another sp
create proc outer_sp2(@s2 varchar(50),@s1 varchar(50))
as
declare @r int
exec inner_sp @s1
set @r=Scope_Identity()
insert into tab2(student_name,master_id) values(@s2,@r)
exec outer_sp2 'Vivek1','Test'
But in table tab2 master_id column contain NULL value....
Please fix it...
Ujjwal
Call SQL Job In ASP.NET Application
Jun 27, 2006is it possible to call a SQL job from an ASP.NET application? if so, how? I'm using VS.net2003 and am programming in C#I've been searching for a while, but haven't found anything. It doesn't help that one of my keywords when searching is "job(s)."
View 1 Replies View RelatedCan I Call A Web Service From SQL??
Sep 14, 2006I have two databases with two identical tables in seperate physical locations. I want database B tables to be updated automatically when database A tables change. Is there a way to call a web service from SQL to make this happen? Or is there a better way to do this? I would really like it to get the rows that were modified and then copy only those rows to the other database tables. If anyone knows if this can be done please let me know. Thank you.
View 4 Replies View RelatedXML Import Do Not Call
Dec 18, 2003Well I seem to be a gomer when trying to understand XML. Could some one please help me? I am trying to write a script or DTS package that will read 4 XML files (Do not call list) compare each phone number to the numbers I have in my DB and if there is a match put the contactID in to another table. Or at the very least get the XML phone numbers into the database. This is what the XML doc looks like
- <list type="full" level="state" val="AL">
- <ac val="205">
<ph val="2025896" />
<ph val="2061994" />
<ph val="2061995" />
<ph val="2062028" />
How Do I Call A Udf For Asp.net/ Vb.net Code?
Apr 16, 2005can someone point me in the right direction? I know how to call a stored procedure, but I can't seem to find code examples on how to call user defined functions.
View 2 Replies View RelatedCan I Call A DTS Package From An SP??
Jan 4, 2000Hi SQL Colleagues:
Is it possible for me to call a DTS package from within a stored procedure? If it is not possible to do so directly, would I at least be able to call the package through a job?
Thanks!!!
Don
Problem When I Call A C++ DLL
Aug 23, 2000Hello,
Somebody in my society has realised a function logwrite in a DLL logfil32.dll
With Sybase we can use it without problem.
It write in a file for example 'c:logmetrixloglogmetrix.txt' the text 'test logwrite'
I add logwrite in the extended stored procedures of mzster
and i tried to do :
execute master..logwrite 'c:logmetrixloglogmetrix.txt','test logwrite'
In the file logmetrix.txt 'test logwrite' wasn't be added. WHY??
Thanks to tour answers
Axel
How To Call A Sp From A SQL Statement??
Oct 2, 2006Hi,
I need to call a stored procdure from a SQL statement that I am running from query analyzer.
My SQL statement will select from a master table of bills. I have a stored procedure that calculates the amount due on each bill. The sp does not use the master table in the calculation.
How do I form the SQL statement to call the sp, which needs one of the master table columns as a parm?
i.e.
SELECT *, EXEC sp_abc columns name AS whatever
FROM tblMaster WHERE......
TIA!
Dave