Rating Thread / Thread Starter	Last Post	Replies	Views
Transaction Logging Backup Set Hi I take one nightly full database backup at 02:00 and backup the transaction log to one backup set every 15mins. The commands to do this are as... Thiko	12-09-2003 12:28 PM Igor Raytsin	3	56
Removing duplicates Hi I have inherited a web app with the following table structure, and need to produce a table without any duplicates. Email seems like the best... Iain	12-09-2003 08:42 AM P.D.N. Tame	2	70
Memo field problem using Access97 with SQL2000 Backend I have an application written in Access 97 that connects to a SQL2000 backend. One field is a description field that is a data type NTEXT in the SQL... Bob	12-09-2003 08:35 AM P.D.N. Tame	1	52
Getting the latest row from a batch Hi All This is a belter that my little brain can't handle. Basically I have 1 SQL table that contains the following fields: Stock Code Stock... Robbie	12-09-2003 08:29 AM Robbie	3	60
Database Permission Could someone please tell me how I can trap permission errors in vb.net on a stored procedure: ie. Execute permission denied on object 'sel_mytable',... Julie Barnet	12-09-2003 08:06 AM Dan Guzman	3	73
Date Stored Procedure Hi all, I am trying to write a stored procedure that will delete records in a table that are older then 30 days. I am checking against a field... GuyInTn	12-09-2003 07:31 AM GuyInTn	4	50
help with stored procedures using IN / GROUP BY statements trying to get to the bottom of this for some time...... eventually to be used with asp. heres the problem the following rather complex SQL... chowda	12-09-2003 04:04 AM chowda	3	57
Full Time Database Consultants Needed Jobs at MySQL AB: / Field Sales Engineer/Consultant MySQL is rapidly growing and looking for high-caliber technical engineers who will work to both... Philip	12-08-2003 08:23 PM Greg D. Moore \(Strider\)	2	55
Return versus Raiserror I am trying to get a better understanding of when to use return (with a print statement) and when to use raiserror. * Both statements can be used... Jason	12-08-2003 08:02 PM Igor Raytsin	2	55
Help desk systems.. I was wondering if anyone could suggest a web-based help desk system that uses MS SQL server that also has a knowledge base and also allows support... Belinda R. Kelly	12-08-2003 08:00 PM John P. Marshall	1	58
newbie: query problem from jsp page Hi all, I'm writing html in a while loop in a jsp page. Unfortunately, although I'm getting 3 results back from my first database query (I tested... Mike	12-08-2003 02:48 PM Mike	0	58
ISQL and OSQL Output Lines Wrapped Around at 256 Characters? I am trying to use a command line program to run a stored procedure that generates output in a comma-delimitted format. Somehow, ISQL or OSQL always... Jay Chan	12-08-2003 11:44 AM Jay Chan	5	82
Setting up SQL Server for Remote Clients Hi, I am having a hard time setting up an SQL Server 2000 Developer Edition instance for remote clients. The instance is running well and I can... Oliver Klozoff	12-08-2003 10:50 AM Oliver Klozoff	1	60
Sort Order and case sensitivity I have a query which filters records containing uppercase and Lowercase i.e. Smith and SMITH, Henderson and HENDERSON etc. Is there a way that I... Steve	12-08-2003 09:31 AM Steve	6	55
sqlserveragent hangs when starting For some weeks now, SQLServeragent hangs after I restart the computer. What could be a reason for this? I don't think I changed anything. The system... Michael Peters	12-08-2003 04:36 AM Michael Peters	2	55
Any Migration issues??? Hi, can anyone let me know whether there are any known issues for the following migration: 1) Migrating a web application (classic ASP 3.0) from... ls_ng2003	12-08-2003 04:20 AM ls_ng2003	0	61
Help! Index corrupting? DBCC CheckTable failing? We are having quite a time since moving a large database to a new server (actually built new server, renamed as old to make seamless for users,... David Schwartz	12-08-2003 03:27 AM M A Srinivas	2	123
Need Help for query I have two tables Income(Date, IncomeType, Amount) and Expense(Date, ExpenseType, Amount). I want to create a balance sheet report for which need a... Raju Shrestha	12-08-2003 02:42 AM Erland Sommarskog	4	62
Newbie Question: Restoring BAK file into a new server Hi all, I have a .BAK file which i need to restore. It originally came from another machine and I am now trying to restore the DB. When i try to... Graeme	12-07-2003 07:50 PM Graeme	4	56
error 1012: the correlation name '%' has the same exposed name as table '%'. Im trying to find the error in this statement: CREATE PROCEDURE STP_selectmain AS select a.inventoryid, b.firstname, b.lastname, art.title,... Jim	12-07-2003 05:36 PM Erland Sommarskog	1	79
Newbie Question about views I have created a view by using following statement:- ALTER VIEW vw_ctotalweeks AS select DISTINCT allweek from hr_depts WHERE allweek >... Adnan Jamil	12-07-2003 04:18 AM David Portas	4	65
Surely not! I know I must be missing something pretty obvious, but what setting should I change to get the correct length of my string ie why does the select... DMAC	12-06-2003 07:47 PM Dan Guzman	3	73
Timeout Expired Error Hello: I have an application (using ADO 2.7 - written in VB) that access a SQL Server 2000 Database. Every once in a while, the program hangs when... Ryan P. Kennedy	12-06-2003 04:16 PM Erland Sommarskog	1	60
Creating Mobile Database on Pocket Pc Does anyone know a site that shows me how to develop a mobile database system on the pocket pc? im a newbie to mobile databases. Thank... Eugene Yeo	12-06-2003 09:33 AM Eugene Yeo	0	56
sql server 2000 and windows xp home edittion Ive seen several sellers, both retail and on ebay, who say that sql server 2000 developer edition will run on windows xp home edition. Is this true?... chaz	12-06-2003 03:20 AM David Portas	1	49
DTSRUN.exe Application error Problem Hi All, I am getting error message when Running DTS package through Scheduler. The message is "DTSRun.Exe Application error -The Instruction as... Kris	12-05-2003 07:47 PM Kris	0	56
Stored procedure won't use index Hi, We're using SQL Server 2000. A very basic query on a 5 million row table would not work. If we hard coded the one input parameter, the query... Trudie	12-05-2003 05:29 PM Erland Sommarskog	3	52
Using Openquery Without Returning Resultset Hello, Quick, and possibly strange, question. I am doing some work testing the running time of some dynamic SQL statements on a remote machine. ... Phil Sandler	12-05-2003 05:19 PM Erland Sommarskog	1	50
Finding all references to a column I have a task to where I need to move a column from one table to another. I want to be sure I update any view, stored procedure, trigger, etc. that... rnewman	12-05-2003 05:09 PM Erland Sommarskog	1	54
Mysterious mystery -- 2002-11-08/2002-11-09 I have function that returns a table of information about properties. The data comes from three different tables -- addresses (called... Jim Geissman	12-05-2003 05:02 PM Erland Sommarskog	3	65
NJ-Business Objects Consultant - 3 month contract **** We are a Direct Vendor for Wipro Technologies ***** Wipro requires a Business Objects Consultant. Location: NJ / UBS Bank Jon Blackburn	12-05-2003 01:30 PM Jon Blackburn	0	74
"Tree View" with a SQL Server Database We need to present hierarchical data on a web page, the same way the tree view shows files in Windows Explorer. Here's the catch: that tree view... imani_technology_spam@yahoo.com	12-05-2003 11:36 AM John Bell	3	66
Preventing logins/users from having more than one active connection Hello all. I am wondering if there is an easy way to prevent users from connecting to the same database more than once at a time. Ie. I do not want... Dave Pylatuk	12-05-2003 11:29 AM Dave Pylatuk	0	60
MAIL Ok, folks, a question for you. I wanna send email through MSSQL Server 2000 using SMTP protocol.HOW? Licemjer	12-05-2003 09:50 AM John Bell	1	141
2nd CFV: comp.databases.etl LAST CALL FOR VOTES (of 2) unmoderated group comp.databases.etl Newsgroups line: comp.databases.etl Extraction, transformation, loading... Cara	12-05-2003 09:12 AM Cara	0	54
Restoring DB Hi all, I have a very old MSSQL data backup file. I do not even remember that it was created in SQL7 or 2000. Anyway, I'm trying to recreate DB from... Kev	12-05-2003 07:33 AM Jay	2	98
Newbie to sqlserver Hi, I have been working as Oracle dba for quite a few years. But now my company is been getting a couple of projects relating to sql server which... sudhakar kalra	12-05-2003 07:25 AM Simon Hayes	2	72
How to do this self-join?? Greetings, Would be thankful for your kind help. I have a table (Northwind employees table). In the employees table, a column called... al	12-05-2003 07:25 AM Myron	1	66
Connection failed between PC Hello, i ahve a problem to connect a pc to another with MSDE installed. The response message of this failure is: 'Server not exists' Can help... Alex	12-05-2003 03:54 AM Simon Hayes	2	65
SQL Server 2000 Exam #70-229: Good book? I'm currently taking an online class for SQL Server which is aimed at teaching you the information you need to pass exam #70-229. However, concerns... who be dat?	12-04-2003 10:34 PM who be dat?	0	48
table mantenance within a replicated database When I try to remove a table, it complains because it's part of a publication. I could script the publication and subscriptions such that they can... golsen	12-04-2003 08:49 PM Greg D. Moore \(Strider\)	1	61
Book Recommendations Needed I am looking for a book that discusses query tuning, index tuning, execution plans, etc. Can anyone recommend something? -- BV. WebPorgmaster -... BenignVanilla	12-04-2003 06:08 PM Greg D. Moore \(Strider\)	1	61
mysql immediate assistance needed please. Objective: The primary table I loaded into MySql has 2.5 MM records: ID, Ticker, Date, Price; and all works well. My need is to write a QUERY to... tread	12-04-2003 05:41 PM Erland Sommarskog	1	50
Altering linked tables I have a table (in Access) that is linked to the SQL server, and I need to add a column to it. I wrote the following: ALTER TABLE Census ADD COLUMN... Christine	12-04-2003 05:18 PM Erland Sommarskog	1	63
Triggers on Delete and on Insert & SQL Server 2000 Hi everybody, I just wrote my first two triggers and from the minimal amount of testing I have done, they work! However, I was hoping I could get... Shock	12-04-2003 04:52 PM David Portas	1	57
View Users Connected to SLQ Server? Is there a utility that will allow me to see what users on my network are connected/active on SQL server? Ryan Ryan McMinn	12-04-2003 01:03 PM CptVorpal	4	64
Internet Queries I have a security setup question: I have a group of employees that must be able to make ad hoc queries against data stored on the SQL Server computer... Frank Py	12-04-2003 11:30 AM Frank Py	0	74
SQL Profiler on a Prod System...is it safe? I have been using the index tuning wizard to review some of my stored procs, and views. So far most of my indexes have been set up well, but I am... BenignVanilla	12-04-2003 09:22 AM BenignVanilla	2	53
Restore a remote backup I want to restore a huge database into my workstation. The size of the backup file is more than 6 GB and I don't have enough space on my HD for both... emmexx	12-04-2003 09:08 AM emmexx	2	55
Dynamic SQL I'm writing a stored procedure that uses DynamicSQL using the following code: SET @Get_Role_Number = 'Select @Role_Number = ' + @DatabaseName... Susan	12-04-2003 07:47 AM Susan	3	108

Page 245 of 283

245

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off