Sponsored Links

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Page 25 of 283

« First

125

Last »

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Are Deadlocks inevitable ? There are many references to deadlock handlers that retry the transaction automatically. But IMO a deadlock is the result of a design flaw that... John Rivers	07-10-2008 04:57 PM Erland Sommarskog	4	43
DB Structure Advice - lots of measurements in DB or file refs? A project I'm thinking about, could use some advice from those who understand the dimensional limits of an SQL-like DB. Imagine, for example, a... RgeeK	07-10-2008 02:59 PM RgeeK	3	33
Schedule a Query I need to run a rather large query and want to schedule it to run this evening. Is there a way to do that in sql server? (2005) Thanks, Scott scadreau@gmail.com	07-09-2008 03:57 PM Hugo Kornelis	1	54
does this backup sequence commit all data to the database backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk =... Roger	07-09-2008 12:59 PM Roy Harvey (SQL Server MVP)	5	31
Multiple attribute design that need to be searchable Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm... Kevin	07-09-2008 11:51 AM Kevin	0	35
Multiple attribute design that need to be searchable Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm... Kevin	07-09-2008 11:48 AM Roy Harvey (SQL Server MVP)	1	25
Sql Server 2005 Replication Scenario: CustDB from Server1 CustDB from Server2 i need the merge the data from both the database and store it on CustDb from Server3 using... Compguyy	07-09-2008 05:52 AM Compguyy	0	34
BACKUP LOG questions SQL Server 2005 SP2 Using SSMS, I've just backed up my transaction log (which is around 314 megs) on a smallish database. I purposely generated a... aj	07-08-2008 01:13 PM aj	3	31
Using UPDATE to sequentially abbreviate address information ( 1 2 ) Greetings, I'm trying to update an address field with "standard" abbreviations so that I can do a comparison of various accounts to one another on... Chris H	07-08-2008 10:45 AM --CELKO--	10	58
Could not execute a package by a scheduled job I try to set a job to run a DTS package, failed. My environment is SQL Server 2000 sp4 on windows Server 2003. There is a local window group called... Jack Lee	07-08-2008 06:00 AM Jack Lee	0	31
dbcc shrinkdatabase Hello We use SqlServer 2000. I'm trying to run the "dbcc shrinkdatabase" command on a specific database. I keep on getting the message: DBCC... David Greenberg	07-08-2008 04:21 AM Erland Sommarskog	1	57
Data loss importing from Excel I'm trying to import a small spreadsheet from Excel into a pre-created SQL Server table. One column is defined as char(2), and the data values are... D.Stone@ed.ac.uk	07-08-2008 03:17 AM Moby	3	25
programmatically stopping and starting transactional replication Hello, Does anyone happen to know if there is a way to programmatically stop and start transactional replication? I would like to have this... Kruton	07-07-2008 01:23 PM Kruton	0	41
login failed i am working in a virtualized environment where we've cloned a sqlserver to another vm. i've been checking my logs in the original server and there... lark	07-07-2008 10:14 AM lark	0	48
How do I number an output field consecutively? I have a query that lists various records, but also should put a row count next to each. For instance No. Name 1 John Smith 2 Ravi Patel 3 ... COHENMARVIN@lycos.com	07-07-2008 08:46 AM Plamen Ratchev	1	32
Database management and latest updates on SQL server Find the latest updates in database management and SQL server tools and techniques. More tips about flowchart preparation, software testing and many... surana	07-06-2008 07:45 PM surana	0	35
======> Secret Video CLIPS <========= Hi....Friends, watch and enjoy SECRET WEB-CAMS at LADIES HOSTELS and INTERNET CAFE SEX SCANDALS... ====== Cute Girls ======	07-06-2008 09:03 AM ====== Cute Girls ======	0	53
SELECTing from a DML statement DB2 allows one to select from an insert, update, or delete, e.g.: select * from old table (delete from x where y = 1); --OR-- select * from new... jefftyzzer	07-05-2008 11:50 AM Dan Guzman	3	37
design issues with large amounts of data ( 1 2 ) I'm tinkering around with a data collection system, and have come up with a very hackish way to store my data- for reference, I'm anticipating... nflacco	07-05-2008 05:20 AM Arved Sandstrom	10	57
Cursor among several databases Hi all, I am wondering if anyone can help. I am doing a sp that search for any string in any row of any table in any database. The idea is to create... valigula	07-04-2008 08:05 AM valigula	1	31
slow queries for a particular database ( 1 2 ) Bear with me here folks, I don't know much MS SQL performance. Wondering if someone can point me in the right direction. I have 1 particular... Marc Baker	07-03-2008 04:46 PM Erland Sommarskog	11	56
Odd character appended to data The following character keeps appending itself to data inserted through a web form. What is it from (how is it generated) and how can it be removed?... t8ntboy	07-03-2008 12:46 PM VIPS	2	28
GROUP BY a computed column If I want to count the number of records in a table GROUPed BY the first word in a string column, must I first compute the first word and store in a... The Quiet Center	07-02-2008 11:47 AM Alex Kuznetsov	3	37
Re: Database security (non-existent?) "Annonymous Coward" <me (AT) home (DOT) com> wrote This is not a security flaw. When you run sqlcmd without providing the user/password via the... Plamen Ratchev	07-02-2008 10:29 AM Arved Sandstrom	2	32
Datetime import/export issue I am migrating data from one database to another. The process requires that I significantly modify the table and data structure. Therefore, I am... t8ntboy	07-02-2008 10:14 AM Plamen Ratchev	3	37
Yellowfin Business Intelligence Release 4.0 Announced to Industry (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst... Yellowfin	07-02-2008 06:29 AM Yellowfin	0	33
Decimal point and comma I 'd like to insert (via "bulk insert") between 10-20 files (about 300MB each) into one table. The problem is that in input files decimal point is... KiP.Kolodziejczyk@gmail.com	06-30-2008 05:26 PM Erland Sommarskog	2	62
How can I do that using a trigger Hi! I've got a table where an index number is already given. I want to establish a trigger on a tmp table, so each time rows are inserted, the... the_hawk_1	06-30-2008 05:22 PM Erland Sommarskog	1	30
Need a script to recreate scheduled jobs I created a new database instance, but I forgot to script out the scheduled jobs before I wiped out the original database instance. I have attached... traceable1	06-30-2008 05:08 PM Erland Sommarskog	1	39
Help needed for Data formatting. Hello all, I just started using SQL to create a report. I got the syntax working but I have absolutely no idea of how to format data. Can anyone... mik357@hotmail.com	06-30-2008 03:50 PM Plamen Ratchev	1	30
sql agent JOB to Backup Database and Maintain Backup Files Hi friends, How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL 2005) 1) Backup a specified Database (Full Backup) and store the... Prabhat	06-30-2008 03:44 PM Plamen Ratchev	1	33
OLEDB configuration when deploying multiple SSIS packages I have an SSIS package which calls many other SSIS packages. Each of these was created with the import wizard in SSMS. As a result, they all have... Jocky Mac	06-30-2008 11:46 AM Jocky Mac	0	34
Please Help - Can't check for duplicates I'm driving myself crazy with a problem in trying to translate a query written for Access to that for SQL server. I would think that I would use a... Lester	06-30-2008 12:57 AM Ed Murphy	3	31
Re: Stop hotlinking to a specific file & keeping a counter Sinikeltainen linja romahtaa. Ågestan ruotsalaisydinvoimala osoittautui valmistuessaan 1963 jo vanhentuneeksi. Tuottaen ydintyyliin 3 milj kruunua... Aatu Uusitalo	06-29-2008 12:23 AM Aatu Uusitalo	0	35
Re: How to secure a database ...? Annonymous Coward (me (AT) home (DOT) com) writes: I'm still not clear over the scenario. Do you work with an application that is used inside a... Erland Sommarskog	06-28-2008 05:49 AM Erland Sommarskog	1	35
Re: Deploying an app with SQL Server (installation on client machine) If using Visual Studio this is a relatively easy task. See the following articles on using VS setup... Plamen Ratchev	06-27-2008 10:40 AM Plamen Ratchev	0	34
Can I search for a string in a set of stored procedures? I found that I'm making an error in my 'case' statements, and now I want to go through a database full of many stored procedures to find that error... COHENMARVIN@lycos.com	06-27-2008 08:31 AM nidaar	2	34
Applying tranaction log to old data file Yes, I meant NO_TRUNCATE as in the original example I posted. I don't believe the TRUNCATE_ONLY option is allowed when the data files... koszuf@gmail.com	06-26-2008 07:55 PM Dan Guzman	9	28
Re: Storing BLOBs outside database Here is a good reading on the topic: http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45 The biggest problem with storing... Plamen Ratchev	06-26-2008 05:01 PM Erland Sommarskog	1	33
alter table query not working after working at least once. MS SQL2000 drop table . CREATE TABLE . ( NULL , (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , NULL , NULL , (16) COLLATE... quincy451@yahoo.com	06-26-2008 03:29 PM quincy451@yahoo.com	7	30
table naming convention about this case.. Thanks for all your advice. I'll tried to find these tables' nature and naming them in a proper way. On 6$B7n(B26$BF\|(B,... PENANCY@gmail.com	06-26-2008 01:54 PM --CELKO--	4	44
Concatenate in MSSQL Hello. I 'm working on a project which has developed a huge program. Some customers use DB2 as database, and others oracle. So far so good and... Harris Kosmidhs	06-26-2008 10:21 AM --CELKO--	1	43
Re: Creating a database from set of TSQLl files You can execute scripts using SQLCMD command-line utility with the -b parameter. This will cause the utility to exit with a non-zero return code if... Dan Guzman	06-26-2008 07:44 AM Dan Guzman	0	36
Question about recompiling a dll Hi all, I'm reading this article on Microsoft's website: http://support.microsoft.com/kb/932872/ , and they state that the solution is to recompile... Geet	06-25-2008 10:44 PM Geet	2	37
Grouping by Day for a Date Range Hi, I thought this would be easier but after looking all over the web I had to post this question. We have a workflow table that tracks when an... Shai Shefer	06-25-2008 05:11 PM Erland Sommarskog	2	38
Duplicate Tests - Help Please Using SQL 2000 - Columns are AssociateID, Associate, , , Score Application provides the students to take assessment tests. They are instructed to... Chamark via SQLMonster.com	06-25-2008 09:53 AM Plamen Ratchev	1	36
Computing a column that is a percentage of the sum of another column To keep things as simple as possible : I have a table with the following information: Unit1 Unit1 Unit2 Unit2 Unit2 Unit3 k4	06-25-2008 07:43 AM Plamen Ratchev	2	34
Latest updates on SQL server 2008 tools and techniques Find the latest updates in SQL server 2008 tools and techniques. Get details on database management, software testing, flowchart preparation and many... surana	06-24-2008 08:21 PM surana	0	41
Tool to chase down the consequences of adding field to DB tables? Hi all, I'm tasked with adding a few fields to our database, and all of the stuff that goes along with it (updating c# UI code, etc.). The database... sherifffruitfly	06-24-2008 04:01 PM Erland Sommarskog	1	36
Latin1_General_BIN comparing two char strings My database is Latin1_General_BIN. My table is called CUSTOMER. One column in this table (descr_id) is defined as char(10). When I query… SELECT... igor	06-24-2008 07:59 AM Plamen Ratchev	3	39

Page 25 of 283

« First

125

Last »

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