Microsoft SQL Server Forum

I would like to increase the length of the column from LOCNumber VARCHAR(30) DEFAULT '' to LOCNumber VARCHAR(100) DEFAULT '' without losing any data currently stored in the field. And it has an index on it defined as

How about backup with MSDE? is there some utility for it? tnx

Hi, I am trying to perform a query that is beyond my knewlegde and was after little help, I have two tables in my db, national and CDR. the National table displays the codes and location for every std code in the UK, the CDR table displays the information about calls made from people in my company.

hello Reader, Table Name: Area ID_Area (Primary Key) Area ID_PIN PIN

Does anyone know why SQL Server occasionally hangs when secure connections are made via ADO?

When we deploy applications, we have been using DSN's set up on the users systems. Then in the sqlconnection string, we go "dsn = xyz". I tried this with our new application, which is the first to be done with ADO.net and I get the following run time problem: "An exception 'System.ArgumentException' has occured in <Myapp>". I do the run...

I am creating a table and would like to know the most efficent way to do this. One of the colums will be text datatype and can have several thousand characters in it (less than10k). The 'ntext' datatype in SQL and hold over a million characters so that isn't a problem. The question is: Is it more efficent to have the data directly in the...

I have two servers running SQL Server on the same network and I am receiving errors registering the various instances as follows: SERVER1 tried to register the local instance (by netname, ip address and local) ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen | Connect() SERVER1 trying to register Server2's default...

Using the included stored procedure I am getting the following result. However I need this to return the DISTINCT forum.ID from the tables while maintaining the correct post count, topic count and last post date. Columns c_ID t_ID f_ID c_Name f_Titlle TopicCount PostCount LastPostDate Results 2 1 55 Equipment Lures 4 1 2005-04-20...

Marcello (md9@ibest.com.br) writes: I'm not surprised. :-) For very common attributes like name, id, code and so on, I typically include something related to the table, so that you have product_name, customer_id, currency_code and so on. But prefixing every column is useless in my opinion. It only adds noise.

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file during the execution of a sql script ? Indeed, my sql script work with very large table and my transaction log file use all the space on my hard drive. so the script have to stop with an error. - Is it...

DBC ensuring your applications don't fail due to a missing database structure object.DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool.Sort sync scipts with database dependencies. goto www.d-softs.com

I have SP, which has a cursor iterations. Need to call another SP for every loop iteration of the cursor. The pseudo code is as follows.. Create proc1 as Begin Variable declrations... declare EffectiveDate_Cursor cursor for select field1,fld2 from tab1,tab2 where tab1.effectivedate<Getdate()

I cannot figure out why this is not working. For some reason the following statement is yielding multiple records with the same CESAFID eventhough it is supposed to be grouped. The query is intended to find the most recent record status date (GoStatusDate) and record status (GoStatus). Please help! SELECT CESAFID,...

I am trying to setup replication between 2 databases on the same/one sql server 2000. i like to know if this is possible. i also want to filter out some of the records that are replicating. i know its possible to replicate to another server but i like to know if i can replicate to the same server since both databases are on the same...

Hi, I am writing a small dating site and now I am designing the DB. At some point I realized that I will need to create a table with more than 12 columns and I felt that it is not such a good idea. I?ve tried normalizing the database, but It was with no effect. So let?s sat that I have the following table: CREATE TABLE users

Hi, I need to specify sql server 2005 express TCP connection port during installation. Is it possible? Thanks for answer.

Does it make sense to make some tables table w/ cities, states, zips, etc. And then refer to them by ID say in a customer record for the adress fields for the customer. Or should these just be string fields in the customer table?

Hello Everyone, This is probably a simple fix so be kind when/if you reply. The query below retrieves information for individuals based on a column named ATTRIB_DEF, and assorted other columns; however, the ATTRIB_DEF column is important one. Currently the query gets all individuals that have an ATTRIB_DEF that contains the string 'AC1'...

Table: All columns int -------- Col1 Col2 Col3 1 1 4 1 2 4 1 3 7 2 1 8 2 2 8 2 4 8

Hello, I only have remote access to the db via textual interface. Now I try to find out what an existing stored procedure is doing. I tried like 'desc sp_sale_pro' and 'show sp_sale_pro' - but that is not working. Can anybody help?

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file during the execution of a sql script ? Indeed, my sql script work with very large table and my transaction log file use all the space on my hard drive. so the script have to stop with an error. - Is it...

Welcome to the -Net User Group Development Discussion. Inviting all the intersted ones to join this group and make a good Success!! http://groups.msn.com/-netusergroup http://groups.msn.com/-netusergroup shivs

hello Reader, Table Name: Area ID_Area (Primary Key) Area ID_PIN PIN

I know I should know this but here goes... I have a table with the following rows: UniqueID int IDENTITY ParentUniqueID int RecordLabel nvarchar(50) RecordText ntext RecordDate DateTime What I'm trying to do is to group all records by ParentUniqueID