DTS: Re-Naming Package

Jan 2, 2001

I am using SQL Server 7 w/ SP2. This may seem silly, but I'm trying to re-name a DTS local package -- so far without success. Surely there's a way to do this. Also, where is DTS info stored? That is, how does SQL Server store package names and other details? Thanks!

View 1 Replies


ADVERTISEMENT

Re-naming A DTS Package

Oct 12, 2000

Does anyone know if there is someway to rename a DTS package? Or can I go into the msdb database
and delete the old name?

Thanks for your help.

Dianne

View 3 Replies View Related

FK Naming

Sep 28, 2007

Hello, I have 2 tables: Articles and Users. These 2 tables are related by AuthorId (FK) in Articles and UserId (PK) in Users. My question is: should the use the same name for the 2 keys, i.e., UserId? Or it is normal to use AuthorId in Articles table and UserId in Users table. This makes more sense. Just a naming question. Thanks, Miguel  

View 5 Replies View Related

DB Column Naming

Jun 18, 2006

What does everyone think of this method?I have a ton of tables like User, Project etc. I use the SAME column names for each table. For an example, ID, Name, Status etc instead of UserID etc.Only for relationship naming will I use UserID.The reason I do this is from a OOP perspective.My dad often said that a table was a entitiy of an object and each record in the table was a instance of that object.

View 2 Replies View Related

Naming Problem

May 3, 2005

I have a function which is named like this:

CREATE FUNCTION [GEEKASPNET.Split]

How can I use it in my stored procedure:

UPDATE Tasks SET Status = 0
WHERE TaskID IN (SELECT CONVERT(int, Value) FROM [GEEKASPNET].Split(@Tasks,","))

This does not work and gives me that "unreconized function GeekASPNET.Split

View 5 Replies View Related

Naming Conventions

Jan 31, 2005

Most of the programming I do is in Access. I like to use naming conventions for all my tables, queries, etc. I am now moving several databases to SQL Server. Does anyone know of a good resource for naming convetions in SQL Server. Website, book?

View 2 Replies View Related

Naming Convention

Aug 21, 2006

Hi all,
I wanted to ask for the naming conventions in SQL SERVER.as in case of pl/sql server we have ..name_of_package.name_of_procedure thats how we call the procedures i.e. owner of schema then name of package n then procedure name.....i want to ask you all how is it done in SQL SERVER..please try to reply as soon as possible,
i will b waiting for the replies,
regards

View 3 Replies View Related

Naming Conventions

Mar 8, 2006

In our database tables are generated like
EMP_MASTER
DEPT_MASTER

like that. when we generate classes from database the class names are looking like

EmpMaster
DeptMaster

but for my classes that Master suffix is not required.
please solve my problem.

Thanks and Regards,
guru

View 4 Replies View Related

Naming Convention

May 8, 2006

Would like to know what naming convention you folks use.

What I need specifically is column naming conventions.

For instance, I have a table called 'lst_as400_srvr'. We could go with the vigorous:

CREATE TABLE lst_as400_srvr
(
as400_srvr_idintNOT NULLIDENTITY,
as400_srvr_namevarchar(128)NOT NULL,
as400_srvr_is_activebitNOT NULLDEFAULT 1
)

Or, I could loosen the rules a bit and go with:

CREATE TABLE lst_as400_srvr
(
idintNOT NULLIDENTITY,
namevarchar(128)NOT NULL,
is_activebitNOT NULLDEFAULT 1
)

I would lean towards the vigorous because it would be very obvious what data is being referenced by the name. In the loosened version, I could very easily have many tables with a 'id' column or a 'is_active' column.

Inversely, I would lean towards the loosened version because the names are a lot shorter and, thus, easier / faster to type.

I figure, if I'm going to learn a new standard, now's a good time to do so.

So, thoughts? Appreciate the help folks. :)

View 5 Replies View Related

SQL Database Naming

Jul 18, 2007

I'm creating a new database for an application that I wish to sell in the future. When we sell it the client will have the option to host is or have us host it. I want to create a name for the database that doesn't describe what the product is. I also want to be able to create new databases if we host it and those names be of a similar convention or subject. I was thinking each would be a Greek god, galaxy names or something along those lines. Does anyone have any suggestions?

Thanks,
Ryan

View 7 Replies View Related

Naming Conventions

May 3, 2007

I'm coming from a MS Access background and so I'm very used to andcomfortable with the hungarian (Leszynski et al) naming conventions.However, I'm getting started into my first SQL Server Database andreally want to use the appropriate up to date standard namingconvention (ISO compliant).I think I have the general idea from raking though countlessconflicting sites and posts, but I'm a bit stuck on what to doregarding pk / fk namingFor example, in my MS Access world I would have two tables:tblOrders=======strOrderIDintCustomerIDdtOrderDate....tblCustomers==========intCustomerIDstrCustomerName....So what would the appropriate and most up-to-date and standard namingbe for SQL Server? My Guess:Orders=====Ord_Order_ID_PkOrd_Customer_ID_FkOrd_Order_Date....Customers========Cus_Customer_ID_PkCus_Customer_Name....How close (or far) am I from "Celko Proof" naming here?All help gratefully accepted!

View 9 Replies View Related

DTS Naming In Jobs

Oct 4, 2007

When I schedule a DTS package as a Job and then look in the job step detail I am presented with the following line.

DTSRun /~Z0x3A2210EB05CE1F9968C82E............etc

This number means nothing to me and I presume it might be encoded or encrypted.
If I wanted to be sure that this code actually relates to the correct DTS package how can I check.

Is there a specific table that will hold that code that will relate it to the DTS package??

Cheers
Tom

View 1 Replies View Related

Naming Of Reports

Dec 27, 2007

I use data driven subscriptiosn to deliver the same report to 6 different customers. But each customer can see only his data. Reports are saved in a shared folder in xl version. Reports are saved like report_1,report_2 etc. Is there anyother way to name these reports without letting customer to change the name?

Thanks

View 4 Replies View Related

Naming Convention

Feb 26, 2007

Sorry if this seems trivial, but is it allowed to add hyphens in a physical server name?
eg: PC-01


Will this cause any errors (when connecting, etc)
Thanx.

View 1 Replies View Related

Naming Convention

Dec 5, 2007



Is there any standard naming convention for SQL Server that microsoft suggest it?
the same as naming guidlines in MSDN for designing libararies in .Net Framework.

View 4 Replies View Related

Sql Table Naming Convention

Dec 20, 2003

I have to build a table Physicalcharacterics in sql.

Convention for naming a table

Would I name this table in sql server
tbl_User_PhysicalCharacterics.
My main parent table is tbl_User.


Is that too long of a name.

View 2 Replies View Related

SqlServer Naming Conventions

Nov 18, 2005

I noticed that a lot of my stuff is getting named dbo.XXXXXXX.  Why is it happening and what does this mean?

View 4 Replies View Related

Naming Of Relationship Table

Jun 10, 2006

We have two tables. Users and Projects and there is a many-to-many relationship.Ex. A user can be assigned into multiple projects.For the relationship table, should the table name be UserProjects or ProjectUsers?Also should it be singular or plural? (ex. UsersProjects or ProjectsUsers)?

View 2 Replies View Related

SQL Table Naming Problem :(

Mar 31, 2000

Hi, can anyone help me with this strange problem?

I am trying to name a new SQL table, but I keep receiving a message that a table with this name already exists in the database. However, when I try to run a SELECT statement using that table, the error msg tells me the object does not exist,and it is not in the combobox of existing tables that can be added to a diagram.

Any clues would be appreciated, thanks !

View 2 Replies View Related

Dynamic Table Naming From Sp

Sep 22, 2000

Does anyone know if it is possible to create dynamically named tables from within a stored procedure? The goal is to append a unique identifier on the end of an otherwise static table name to allow for multiple incarnations of the table to exist concurrently while not interfering with each other. For example, we would like to create and use a temp table that is suffixed with a login name to or a timestamp to make it unique.

Is this possible?

View 6 Replies View Related

Naming Standards For SQL Objects

Sep 2, 1998

I was wondering if there are generally accpeted naming standards for SQL Server ojbects (tables, store procedeures, triggers, views etc.) that might be available somewhere on the WEB. I was also wondering if most DBA`s prefix the object names like "sp_" or suffix the object like "Customer_T"? Any opinions?

View 1 Replies View Related

Cluster: Instance Naming

Sep 3, 2007

Hi all

SQL Server 2005 cluster. Active-Active. We want to create two instances. The two nodes are named:

mike-940-01
mike-940-02

I read somewhere that there can only be ONE default instance in a 2005 cluster. So I interpret that as meaning that I can only have one instance named after a virtual server (example: mike-940-03) and the other instance has to be a slashed instance (example: mike-940-03/instance1). But what if I create another virtual server (example: mike-940-04). Can I install a default instance in that server? Can someone help me clarify this?

Also, if I'm using all slashed instance names, then what does it choose as the base name before the slash? In other words, what decides which virtual server name is used? Is it the management node? Is it one of the nodes?

My objective is to keep consistency in the naming on the cluster. If I have to use slashed instances, then I want all sql server instances to have a slash.

Sorry about the confusing explanation, but that's probably a symptom of MY confusion.

Thanks!

View 4 Replies View Related

Naming Based On A Subquery

Jun 13, 2008

I'd like to name an output field based on the result of a subquery look up. This is the idea:

select colname1 as (select name from tableofnames where nameid=1)

..but that doesn't work. What would?

View 4 Replies View Related

Naming Calcualted Columns

Jun 19, 2006

I have several calcuatled columns in a table (see below) that I have been work with. First can I assign a proper naming decision to the columns? How can I reference these columns in other tables?

For example how can I assign names to the columns listed below?

select date, ((abc * .05)+ efgh * .05), (((efgh * .475) + (abc * .475) + (123gross * .05)))
from table
where date = '2006-03-31

Thanks

View 15 Replies View Related

Universal Naming Convention.

Aug 21, 2006

how can i find the servername and sharefolder on my computer to access a file?

for the server name i used the ip aand sharefolder i used computer description.
i think its not right cause its not working.

View 18 Replies View Related

Where Can I Get I Guide On Conventions For Naming

Jun 12, 2007

Where can I get I guide on conventions for naming, stored procedures, tables, user functions ? that I can implement in my work

View 6 Replies View Related

Tables, Naming Problem

Feb 14, 2008

Is there a good way to name tables that are used as lookup tables? If you have a table for movies and you think that a movie can be in more than one genre. Then you will have tables like the following.

a table for movies, table 1
id name ...
1 Scarface

a table for the movie genres, table 2
id name ...
1 action
2 mafia

a table that links the genres to the movies, table 3
id table 1 id table 2 id
1 1 1
2 1 2

Table 1 is no problem. I name it movie.
Table 2 is the genres. I name it movie_genres.
Table 3 specifies the genres for a specific movie so I name it movie_genres. Duh, already taken.

This is just an example and perhaps not the best. What should I call my to genre tables?

View 6 Replies View Related

Naming Column Names

Jul 23, 2005

Hi,I am learning Ms Sql and I found that a lot of the tables I am finding( in different tutorials ) are using special names for their columnnames such like au_username, au_salery ...Is the any naming convention for column names, or just at all is thereany reason for naming the table columns in specific way.Thanks in advance.

View 4 Replies View Related

Naming Syntax In 2005

Mar 12, 2006

Here is a simple question. I am having difficulty accessing booksonline at Microsoft so I thought I would ask here. What is thestandard naming syntax for Sqlserver 2005? Assuming I had thefollowing table, [proddb01].[details].[dbo].[daily_tranx], how would Irefer to it in the new version?Thanks a lot!

View 5 Replies View Related

Naming The Database Server(s)?

Apr 2, 2007

Hi.Could somebody kindly tell me what conventions and best practices areused when naming a database server (not the database itself) and/or acluster of database servers?thanks!

View 5 Replies View Related

Column Naming/spacing

Apr 19, 2007

Is it possible to have spacing within a column name? Something like"column name." I can do it from EM but won't let me do it in queryanalyzer. Can someone tell me the command to do this in queryanalyzer? Thanks!

View 1 Replies View Related

Instance Naming Problems

Jun 16, 2006

When I try to Add New Item - Database in VS C# Express, I get "An error has occurred while establishing a conncection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)"

When I open the management studio, I can connect to a database named Dev, and when I try to "Browse for more" from the server selector combobox, it is the only one found. I believe "Dev" was my old MSDE name, although this is also what my "Computer Name" is set to. Unfortunetly the setup of SQL Express didn't ask me what to name my instance.

I thought maybe the SQL Server 2005 Express Toolkit installation didn't actually contain the server software, and only installed the tools, as during the installation the section where I select components only listed things like client tools and what not, with not mention of the server software.

So I thought maybe it didn't install the server, so I downloaded the server installation that is by itself, and installed it, this time I saw the check for hide advanced options, so I went through the advanced options this time. I've have been through this same setup before at work, and both times it has confused me. It seems very different from installing previous versions of SQL server.

Where I choose to create a new instance or upgrade, I choose to upgade, and it is not clear what I'm upgrading, the selector does not display instance names.

At another point it asks me about configuring it to use the Local service, local system, or network account. The documentation of how these differ is vauge. For example, the network account is described basically as "don't use this" without saying what it is.

I was accustomed to just a local account, and network account settings from previous versions, and network was always the logical choice for me to use intergrated security. I don't understand what the new catagories represent and what will be functionally different in the way I connect.

So I'm really confused, and getting back to the instance names. In the surface area configuration as well as the VS Express, it only sees the name as MSSQLSERVER

For example if I "add new connection" from database explorer and click advanced, the datasource drop down lists only ".MSSQLSERVER"

So I'm thoroughly confused at this point and not sure what to do.





View 1 Replies View Related

Variables In The Four Naming Conventions

Apr 27, 2006

Hi

I am running SQL Server 2000 and have two different databases with different names on two different machines.

The servers (machines) are linked and I want to use a single set of stored procedures on both databases.

I want to know if and how I can use variables in the four naming conventions in a stored procedure. This way I do not have to write an if statement and rewrite the code for each database.

Example:

Select * from SERVER_A.DATABASE_1.dbo.CENSUS

Eventually, I want SERVER_A and DATABASE_1 to become the variables that will change depending on which database that is being requested.



Any help would be appreciated.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved