Hello all, SQL Server 2000 documentation http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part10/c3761.mspx states that if view is using...

V T

12-23-2005 03:48 PM
Erland Sommarskog

Hi all, As the topic describes, I'd like to run a batch file using sql server. How do i do it? Thanks in advance

coosa

12-23-2005 08:51 AM
Dan Guzman

I've seen several posts that begin to address this problem, but have not found a simple, elegant solution that will accomplish this goal. The...

matt@endosearch.net

12-23-2005 05:15 AM
jsfromynr

Hi how to set the referential integrity between 2 tables using enterprise manager (microsoft SQL SERVER).. i tried and the tab doesn't allow me to...

chavasreedhar

12-22-2005 08:17 PM
Dan Guzman

Table DDL below: The tables I have contain Timesheet information. Each row in the tblTSCollected table contains an entry for an employee into...

teddysnips@hotmail.com

12-22-2005 08:03 PM
Dan Guzman

Please here with find the requirement details as follows Business Analyst with i2 Location: Overlandpark,KS Duration: Longterm Startdate:...

Radhesh Reddy

12-22-2005 05:53 PM
Radhesh Reddy

Hi, I'm using ASP 3.0 and ADO with a web based MS SQLServer 2000 database.Web page forms collect criteria for SQL queries (dynamic SQL?). These are...

Ray Allison

12-22-2005 04:24 PM
Erland Sommarskog

Hi, When I click on the properties of a linked server, all the General properties are read - only, which means that if I want to edit any general...

Crazy Cat

12-22-2005 04:19 PM
Erland Sommarskog

When a SQL statement is executed against a SQL Server database is there a server-side setting which dictates the size of the fetch buffer? We are...

Mike Collier

12-22-2005 04:15 PM
Erland Sommarskog

Hello, I am trying to create a view that shows the following Field1: Sum of Amounts from Table A Field2: Count of Amounts from Table A Field3: Sum...

Ryan

12-22-2005 03:14 PM
Hugo Kornelis

Hi all, Since yesterday I'm unable to lauch the enterprise manager, it gives the following error : Unhandled exception at 0x0101f07e in mmc.exe:...

Koen Appeltans

12-22-2005 11:01 AM
denappel@gmail.com

I'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all.

Ranjit

12-22-2005 07:05 AM
Greg D. Moore \(Strider\)

Hello. I using a simply SELECT statement to retrieve some data from a SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT because the...

gene.ellis@gmail.com

12-21-2005 09:48 PM
Dan Guzman

Hello Config : SQL 2000 on WIN 2000 (IIS 5.0) In my ASP page for some queries i have this error : Microsoft OLE DB Provider for SQL Server error...

Not4u

12-21-2005 08:11 PM
Doug

I have a stored procedure that works fine on SQL Server 2000 or 2005, but when run on an machine running MSDE, I get the Operand type clash, int is...

coop

12-21-2005 05:08 PM
Erland Sommarskog

Hi, I wrote the following in the SQL Server 2005 Express Management Studio Query Analyzer and hit execute. Even though Query Analyzer indicated...

Crazy Cat

12-21-2005 05:00 PM
Erland Sommarskog

I have a column that has text delimited by a percent sign that I wish to turn into rows. Example: A column contains ROBERT%CAMARDA, I want to turn...

rcamarda

12-21-2005 04:55 PM
Erland Sommarskog

Wondering if there is a physical or realistic limitation to the number of UNION statements I can create in a query? I have a client with approx 250...

laurenq uantrell

12-21-2005 11:48 AM
laurenq uantrell

Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from...

Takpol

12-21-2005 09:04 AM
Takpol

I've stumbled across the above error and am a little stuck. I've just installed SQL2000 (sp3) on my PC and restored a database from our Live server....

Ryan

12-21-2005 07:57 AM
Ryan

Hi all, Seems like a fundamental question to me but I dont have a definite answer for it, Gurus please enlighten me. I have a table 'Table1' whose...

adi

12-21-2005 03:29 AM
David Portas

Is a single transaction log created for a database or, if you have a primary and a secondary file group in that database, are two transaction logs...

plsullivan63@gmail.com

12-20-2005 10:57 PM
plsullivan63@gmail.com

I have a table that has values as follows: PersonID Degree 55 MD 55 Phd 55 RN 60 MD 60 Phd I need a create a query that will give me output like...

bika

12-20-2005 03:34 PM
Rob Smith

Question: (SQL Server 2000) Can I arbitrarily delete a transaction log file in either bulk or full with a cron job and still be able to restore a...

plsullivan63@gmail.com

12-20-2005 08:48 AM
Mike Epprecht \(SQL MVP\)

Can anyone tell me if you can display line numbers in the query window of SQL 2005 Management Studio and if so how do I go about doing it? Thanks a...

LineVoltageHalogen

12-20-2005 08:40 AM
LineVoltageHalogen

I was working on figuring out where a certain application was storing the multiple selection choices I was doing through the app. I finally figured...

serge

12-20-2005 08:29 AM
serge

I'd like to build an application that will react to specific changes to data in a set of tables in a database. The application would replicate these...

Laurence Breeze

12-20-2005 03:18 AM
Tibor Karaszi

Hello, I have the following error message in the sqlagent.out file, looping each minute. 2005-12-19 10:58:54 - ! SQLServer Error: 14262, The...

dba999

12-20-2005 12:29 AM
Razvan Socol

Hi Guru, This weekend, I migrated SQL Server7.0 to 2000 and below is the scenarios: 1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL)...

kmounkhaty@yahoo.com

12-19-2005 11:01 PM
Dan Guzman

Ardenta Ltd, announce the release of NetSearch, the premier Business Intelligence Search Engine. NetSearch provides tradditional search...

Mike Streeton

12-19-2005 12:49 PM
Mike Streeton

Greetings Group Members, I am going to implement a strategy for archiving and restoring old filegroups. Part of my data has been stored in date...

Takpol

12-19-2005 10:55 AM
Takpol

Hi, Is it possible to have many different clients conncecting to a web based server all using, simultaneously, the same DSN-less connection string...

Ray Allison

12-19-2005 04:35 AM
StingRay51

Greetings, I am having some trouble with a trigger. This is my first attempt at creating a trigger so any help would be great. The function of...

Matt

12-18-2005 01:13 PM
John Bell

Hi again, I have setup a maintenance plan schedule, my question is; can I create an additional plans located on another network location ? In my...

Steve Blair

12-18-2005 04:13 AM
Razvan Socol

Hi All, I'm hoping someone can help me. I think I'm missing something very basic. I'm trying to put a clustered index on a view that I...

Bethany Holliday

12-17-2005 09:00 PM
Alexander Kuznetsov

SQL BPA says the following: "One or more objects are referencing tables/views without specifying a schema! Performance and predictability of...

serge

12-16-2005 10:03 PM
Dan Guzman

A few years ago I wrote an active-X server to maintain a single connection to a file .mdb from multiple apps on same PC because I was having to many...

walt@clubknowledge.com

12-16-2005 09:44 PM
Dan Guzman

SELECT TOP 100 w.TimeDate AS , p.ProdCode, COUNT(w.BoxID) AS cases, AVG(w.PrintedWeight / w.PkgsPerBox) AS avgtrayweight FROM ...

msg

12-16-2005 12:41 PM
Doug

SQL Server 2000 SP3A Last week one of our processes starting issuing or suffering deadlock detected errors every 15 minutes or so. I have read...

Mark D Powell

12-16-2005 12:36 PM
Doug

There is apparently a new worm called "Dasher" that is making the...

Larry Bertolini

12-16-2005 10:11 AM
Larry Bertolini

Greetings, I have an application that need to get all the user defined child tables first before their parents. I wrote a query, given in this...

pankaj_wolfhunter@yahoo.co.in

12-16-2005 09:15 AM
Tony Rogerson

Hi all! What is the best tool to use in order to get some SQL performance logs? I could use build in admin tool perfmon but I was wondering...

Rukia

12-16-2005 08:45 AM
Robert Klemme

I have heard that machines running applications with embedded MSDE frequently experience conflicts between the MSDE apps and other applications such...

Ellen K

12-15-2005 02:52 PM
Jens

Stylus Studio wants to inform you that Dr. Michael Kay has released a new tutorial called, "Schema-Aware Queries and Stylesheets". This is his third...

Stylus Studio

12-15-2005 02:28 PM
Stylus Studio

Can someone explain to me why the following doesn't work? declare @oname sysname select @oname=name from sysobjects where name...

JLavalley@Enlighten.Net

12-15-2005 10:14 AM
JLavalley@Enlighten.Net

HI, I have a table with IDENTITY column with the datatype as INTEGER. Now this table record count is almost reaching its limt. that is total record...

Praveen

12-15-2005 06:07 AM
Tom Moreau

Have good grasp of mdb's. Beginner with sql Have sql db of charity organisations with contact details, all fairly simple. Have one Field for web...

graham menzies-kitchin

12-15-2005 02:47 AM
graham menzies-kitchin

Sorry, the prior message was multi-posted. Here's a cross-posted version. Please disregard the other one. Is there a way to create and encrypted...

Martin

12-14-2005 10:08 PM
Martin

I am running SQL Server Best Practices on a SQL 2000 database and it is recommending me to change the temp tables inside SPs to table variables. I...

serge

12-14-2005 06:04 PM
Hugo Kornelis

I need some assistence here. I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS desktop engine). I need to sync my databases...

sql guy123

12-14-2005 04:20 PM
Erland Sommarskog