Detaching and Re-Attaching Loses Stored Procedures

Hi, I've just detached using QA and sp_detach_db a database that I have been
working on for a client and taken it to the clients site and using QA and
sp_attach_db attached it to their SQL 2000 Server.
The problem is that a) there are none of my stored procedures for that db on
their server, b) when re-attaching it back to my SQL Server there are none
of my stored procedures and worst still c) who forgot to backit up first!!
I thought all user stored procedures were stored within the mdf files so why
have they not gone with the db, tables, etc. The user sps did NOT start with
sp_ by the way.
Any help would be much appreciated.
Thanks
David Smith
MCP MCSE MCDBA <-- (ha, ha - I'm supposed to know!)Look at that issues:
http://groups.google.de/groups?q=at...c.rr.com&rnum=1
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"David Smith" <david.smith@.lonsdale.co.uk> schrieb im Newsbeitrag
news:uGfYA8bSFHA.2356@.TK2MSFTNGP14.phx.gbl...
> Hi, I've just detached using QA and sp_detach_db a database that I have
> been working on for a client and taken it to the clients site and using QA
> and sp_attach_db attached it to their SQL 2000 Server.
> The problem is that a) there are none of my stored procedures for that db
> on their server, b) when re-attaching it back to my SQL Server there are
> none of my stored procedures and worst still c) who forgot to backit up
> first!!
> I thought all user stored procedures were stored within the mdf files so
> why have they not gone with the db, tables, etc. The user sps did NOT
> start with sp_ by the way.
> Any help would be much appreciated.
> Thanks
> David Smith
> MCP MCSE MCDBA <-- (ha, ha - I'm supposed to know!)
>

Desktop vs. Standard

Hello,
I purchased some software that comes with the desktop edition of SQL 2000.
I have a Windows 2003 server and about 20 clients who need to access the
database.
Are there any limits to the desktop edition that I should be aware of?
Does it work with Windows 2003?
Does it have a limit to the number of simultaneous users?
Does it have memory limits?
Thanks
I assume you mean Desktop Engine, also known as MSDE...
1. Yes
2. No. But there's a performance throttling kicking in when you have > 8 simultaneously executing
queries.
3. Max size for db is 2GB (data, not log).
More info at http://www.microsoft.com/sql/default.mspx.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"boe" <boe_d@.hotmail.nospam.com> wrote in message news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
> Hello,
> I purchased some software that comes with the desktop edition of SQL 2000.
> I have a Windows 2003 server and about 20 clients who need to access the
> database.
> Are there any limits to the desktop edition that I should be aware of?
> Does it work with Windows 2003?
> Does it have a limit to the number of simultaneous users?
> Does it have memory limits?
> Thanks
>
|||Thank you - good to know!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uKv%23VNc3EHA.3472@.TK2MSFTNGP09.phx.gbl...
>I assume you mean Desktop Engine, also known as MSDE...
> 1. Yes
> 2. No. But there's a performance throttling kicking in when you have > 8
> simultaneously executing
> queries.
> 3. Max size for db is 2GB (data, not log).
> More info at http://www.microsoft.com/sql/default.mspx.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "boe" <boe_d@.hotmail.nospam.com> wrote in message
> news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
>

Desktop vs. Standard

Hello,
I purchased some software that comes with the desktop edition of SQL 2000.
I have a Windows 2003 server and about 20 clients who need to access the
database.
Are there any limits to the desktop edition that I should be aware of?
Does it work with Windows 2003?
Does it have a limit to the number of simultaneous users?
Does it have memory limits?
ThanksI assume you mean Desktop Engine, also known as MSDE...
1. Yes
2. No. But there's a performance throttling kicking in when you have > 8 simultaneously executing
queries.
3. Max size for db is 2GB (data, not log).
More info at http://www.microsoft.com/sql/default.mspx.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"boe" <boe_d@.hotmail.nospam.com> wrote in message news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
> Hello,
> I purchased some software that comes with the desktop edition of SQL 2000.
> I have a Windows 2003 server and about 20 clients who need to access the
> database.
> Are there any limits to the desktop edition that I should be aware of?
> Does it work with Windows 2003?
> Does it have a limit to the number of simultaneous users?
> Does it have memory limits?
> Thanks
>|||Thank you - good to know!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uKv%23VNc3EHA.3472@.TK2MSFTNGP09.phx.gbl...
>I assume you mean Desktop Engine, also known as MSDE...
> 1. Yes
> 2. No. But there's a performance throttling kicking in when you have > 8
> simultaneously executing
> queries.
> 3. Max size for db is 2GB (data, not log).
> More info at http://www.microsoft.com/sql/default.mspx.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "boe" <boe_d@.hotmail.nospam.com> wrote in message
> news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
>> Hello,
>> I purchased some software that comes with the desktop edition of SQL
>> 2000.
>> I have a Windows 2003 server and about 20 clients who need to access the
>> database.
>> Are there any limits to the desktop edition that I should be aware of?
>> Does it work with Windows 2003?
>> Does it have a limit to the number of simultaneous users?
>> Does it have memory limits?
>> Thanks
>>
>

Designing reusable column transformations?

We receive thousands of files every week from various clients and we attempt to clean the columns using the same technique over and over so the data is consistent. The problem is I dont see a way to reuse complex column transformations in different packages. I would hate to have to go change every package if we change the rules for cleaning a column.

So #1: Can you create some kind of script or .net function that cleans a column and reuse it in multiple packages (or even in the same package)?

#2: Is it possible to call functions from the Derived Column expression builder?

Thanks!

1)May be. You always can use a script component with the transformation rules and copy and paste it many times; it that sounds reasonable to you.

2) No you can not.

|||

Craig, I have had do do the same thign.The best solution is not a script component, as the person above mentioned.

Take the hit, build a custom component. Once you get it built, adding a new column is as simple as adding a new column to the transform.

You will want to build a custom pipline component. Both Wrox and O'riely have some decent chapters decribing how to do this. and there is definately info in microsoft.

I have 350 packages, that all chagne time from european time to us time, in the data flow. By writing 1 component, once, I was able to then delegate the rest of the work, since the hard part was encapsulated in a compoent.

good luck

Design Advice

I'm trying to design a database that handles Clients, Cases, Individual and Group Sessions. My problem is that a client can have individual sessions and belong to more than one group at the same time, so I have a many-to-many relationship to deal with. Also I'm trying to design it so that I can have a form that when a group is selected from a drop down it shows all clients assigned to that group and will let me enter new session data for them.

Just looking for some advice on how to handle the relationships.
Maybe someone could show me how they see the relationships working.

My take is that the session is linked to the case not the client, I could be thinking incorrectly?

Thank you,

tblClient
tblClientCase
tblCaseSessionLog
tblClientCaseGroupLink
tblGroupscreate look up tables to handle those relationships.|||What do you mean? Can you explain?

Thank you,|||When a case can have only one client, you can simply add the clinetID to the case.

if a client can be in multiple Groups you need

a master table of Clients
a master table of Groups

an additional table to link them that contains 2 columns (ClientID, GroupID)

this extra table allows you to add additional rows for each group a client belongs to.

You'd need to better define what the SessionLog is for before i can comment on that last question.