Hi all, I have sql server 2005 express edition installed. i want to take a backup of sql database Using the sql management studio, under tools, in...

johnhitashi@gmail.com

11-05-2007 11:02 PM
darek

SQL Server 2005 SP2 Are there any guidelines/rules of thumb as to the max number of SQL Server instances on a single 64-bit server? thanks aj

aj

11-05-2007 05:49 PM
Erland Sommarskog

(mirandacascade (AT) yahoo (DOT) com) writes: As long as the job is so simple that replace() does the job, why not use it? I would not be...

Erland Sommarskog

11-05-2007 05:44 PM
Erland Sommarskog

The new table I need for an ASP project includes a PK. After creating a View, how can I add a new PK column, which will add the increaing integer...

cjeffwang@gmail.com

11-05-2007 05:40 PM
Erland Sommarskog

I know that in a relational database the order of the columns in a table usually is not important, but I need to know if it's possible to alter...

D.

11-05-2007 05:31 PM
Erland Sommarskog

Hi, The following SELECT statement works fine and returns what I need as one of the columns in my query. I have to create more than 10 of...

Faye

11-05-2007 11:56 AM
Roy Harvey (SQL Server MVP)

I hate people like that -.- Troll-by-ignorance... Lew wrote:

Jurgen Haan

11-05-2007 05:17 AM
Jurgen Haan

hi all i need to search a table for columns i have to match data i recieve from a online transaction batch example in our system we send...

Analizer1

11-04-2007 11:54 PM
Ed Murphy

Hi, I have 1 SQL statement selecting data from various tables and updating other tables. The question then is how do I prevent other applications...

dhek

11-04-2007 03:02 PM
dhek

I have structure: FolderId, FolderName, ParentFolderId, FullPath e.g. 1, First, null, First 2, Sec, 1, First/Sec .....

danko.greiner@gmail.com

11-03-2007 05:02 PM
Tony Rogerson

Hi. I'm looking at a problem and I can't find any solution short of coding. I have a pool of, say, 1000 PINS. I have 7 tables (buckets). Any of the...

Radu

11-03-2007 12:34 PM
--CELKO--

Hi all! Several weeks ago, we successfully transferred our database from SQL Server 2000 to 2005. Below are our steps in transferring the database...

Ben

11-02-2007 05:08 PM
Erland Sommarskog

I have a very large DB (>300GB). Each day I receive a file containing an average of 2 million individual delete statements. The delete statements...

halftime57@gmail.com

11-02-2007 11:49 AM
--CELKO--

Hate to ask trivial questions on newsgroup but I've had no luck on google, IRC, or a 500 page SQL book. Long story short I'm creating a instant...

danny

11-01-2007 11:57 PM
danny

Hello, can I do this via SQL: example: tbltest has 5 rows: col1 === A C

candide_sh@yahoo.de

11-01-2007 05:28 PM
Hugo Kornelis

I have two tables: one with person information and the other with a person's status changes/updates. (A person's status can go from Prospective to...

melissa820@hotmail.com

11-01-2007 08:19 AM
melissa820@hotmail.com

Hello, My goal is to setup and configure the "Community MySQL server" on my "Vista" laptop. I want to run the server and clients on the...

Vasya

11-01-2007 06:14 AM
Greg D. Moore \(Strider\)

I have created a C# library containing CLR stored procedures and user- define functions using Visual Studio 2005, and I have used Visual Studio to...

Amber

11-01-2007 03:24 AM
Erland Sommarskog

I have a query file, test.sql, in the root of my C drive. It is 400,000 lines worth of insert into statements and is so big i cannot load in into...

mitchman10@gmail.com

10-31-2007 08:56 PM
Roy Harvey (SQL Server MVP)

Hello, Has someone used the latest product (supposed to be out sometime in November), SCDPM 2007 for backing up and restoring SQL server...

serge

10-31-2007 07:20 PM
serge

if exists(select * from dbo.sysobjects where id = object_id(N'BBSItems') and OBJECTPROPERTY(id,N'IsUserTable')=1) drop table BBSItems GO CREATE...

cong

10-31-2007 05:45 PM
Erland Sommarskog

Hello, The part of my stored procedure giving me problems is...

signon77

10-31-2007 09:07 AM
--CELKO--

Hi In my DTS I am updating an Ingres database on a different server. I'm getting the following error immedtiately .... HResult of 0x80040e09...

David Greenberg

10-31-2007 02:36 AM
David Greenberg

clustered/non-clustered indexes in the msdn http://msdn2.microsoft.com/en-us/library/aa964133.aspx

Jackie Silva

10-31-2007 01:08 AM
Jackie Silva

Shoud a SQL 2005 database remain open in a Visual Basic program, or should it be opened and closed in every subroutine? Thanks for any info.

Charlie

10-30-2007 10:21 AM
Charlie

Hello Connecting to SQL 2005 Developer Edition with .NET 1.1 SqlClient If I attempt to connect using TCP/IP all is well but if I try and use...

John Rivers

10-30-2007 10:07 AM
John Rivers

Could someone help me, I'm getting this error message: Procedure or function UpdateResources has too many arguments specified. Here's my stored...

JJ297

10-30-2007 06:44 AM
JJ297

I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a replication betwwen them: SERVER1 as Publisher and SERVER2 as subscriber. the...

shgzs33@gmail.com

10-30-2007 03:42 AM
shgzs33@gmail.com

Hello, I'm trying to link two tables... one for Employees and the other for Timecards I need to get a list of employees that do not have timecards...

pbassutti@hotmail.com

10-29-2007 07:44 PM
pbassutti@hotmail.com

Hi, I am trying to Pass Column Name(FieldName) using Parameter in SQL Statement... But i am getting error... how can i pass Column name using...

raghutumma@gmail.com

10-28-2007 03:18 AM
Tony Rogerson

Hello, I run the following query on a database (SQL 2005): delete from person where pers_companyid in (select pers_companyid from company where...

davidaustinarcher@gmail.com

10-26-2007 08:36 PM
--CELKO--

I am getting the following intermittant error upon accessing data from my server: Run Time Error '3146' ODBC Failed ConnectionWrite...

Lisa

10-26-2007 05:39 PM
Erland Sommarskog

I have a query that simply slelcts the min value of a specified field from one table, I want to take that value to update a field in annother table,...

rzito@si.rr.com

10-26-2007 05:35 PM
Erland Sommarskog

I have searched for how to upload image data types using just TSQL and cannot find anything. I do find examples using VBA or ASP but nothing...

Artie

10-26-2007 05:34 PM
Erland Sommarskog

I installed the SQL Server 2005 SP2 update 2 rollup on my 64-bit server and the performance has tanked! I installed rollup 3 on some of them, but...

traceable1

10-26-2007 05:28 PM
Erland Sommarskog

I have a table on a database that contains 18million records. I need to design a system that queries this table to produce fast counts. I have got...

DBMonitor

10-26-2007 05:12 PM
Erland Sommarskog

How many exams need to be successfully completed to become MCDBA Certified for SQL Server 2005? What are the exam numbers? What are the best books...

Mycoal

10-26-2007 07:05 AM
Tom Brown

Hi all, I have a very large table with many columns: dateTime type, nvarchar type and integer field type. A program exec many type of query with...

Enorme Vigenti

10-25-2007 05:14 PM
Erland Sommarskog

I have a Store Procedure on a Sql Server 2000 Where I use the Table Hint "NoLock" on all selects. One of my clients (OleDbConnection from C#)...

bmm

10-25-2007 05:09 PM
Erland Sommarskog

I just made a major addition to the data in our database (SQL 7 with an Access 2000 front end). The users had been working with a set of 66,000...

Neil

10-25-2007 12:49 AM
Neil

Is there a way to delete all data from a database - all tables and all tables excluding system tables? sqlserver 2000? Thanks, Tmuld

Tmuld

10-24-2007 09:02 PM
Joe Hurzeler

Hi all, I'm having some trouble with connecting to SQL server instance lately without adding a port number. I used to be able to always connect...

Flash08

10-24-2007 07:02 PM
Joe Hurzeler

Hi All : CREATE TABLE TABLEA(Person Varchar(20), Country Varchar(20), Subject Varchar(20), Type Char(1)) INSERT INTO TABLEA VALUES ('Einstein',...

thetaamommy@gmail.com

10-24-2007 05:27 PM
Erland Sommarskog

Hello! Here is the statement in question: --STATEMENT A SELECT * FROM dbo.myTable WHERE colX in (SELECT colX FROM dbo.sourceTable) The problem...

Anne

10-24-2007 04:46 PM
--CELKO--

I'm need to get the from the classifications table Trying to join it to another table (titleclassification) but I don't need info from that table. ...

JJ297

10-24-2007 01:24 PM
JJ297

I have rows of data that have a datetime stamp. I need to find rows that have a datetime stamp within 10 seconds of the top of each hour. I started...

rcamarda

10-24-2007 11:15 AM
Roy Harvey (SQL Server MVP)

We have a Access app that has been split with the backend on SQL 2k. We setup an ODBC connection on the clients to point to the SQL server and we...

mike@mcarlson.net

10-24-2007 11:01 AM
mike@mcarlson.net

Hi, I'm constructing a query that will performs a lot o datetime calculumns to generate columns. All that operations are dependent of a base...

brazil.mg.marcus.vinicius.lima

10-24-2007 09:24 AM
Roy Harvey (SQL Server MVP)

Hi friend ! i want to ask you about view. will the view data be updated automatically when we insert or update the physical table or it is updated...

Phung

10-24-2007 09:19 AM
Roy Harvey (SQL Server MVP)

I'm pulling multiple campaigns associated with companies so that I have a result set with company name, campaign1, campaign2, campaign3, campaign4,...

Chris H

10-23-2007 05:40 PM
Erland Sommarskog