Sponsored Links

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

Page 17 of 283

« First

117

Last »

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Yellowfin BI Evaluation Pack on The Server Side Yellowfin a leading web-based BI solution that can be easily integrated into any third-party application or delivered as a stand- alone enterprise... JTP PR	03-26-2009 04:50 AM JTP PR	0	109
inexplicable record deletion hello, i have a strange situation. records in one of tables in my database have inexplicably deleted. only a few person know the access key to... fasisi	03-25-2009 07:41 PM fasisi	5	230
In memory DB (MS-SQL vs MySQL) I normally work with MS-SQL (inc clustering, mirroring and replicated systems) but I've been tasked with looking at MySQL Cluster so that we can... Ryan	03-25-2009 02:59 PM Erland Sommarskog	6	149
TSQL I am working on a system that appears to have TSQL removed. Is there an easy way to locate and/or add the tsql executable to this system without a... onedbguru	03-25-2009 07:15 AM onedbguru	4	223
ODBC and Active Directory Hi all, I am able to successfully connect to one of our development SQL Server databases using ODBC from my Linux server (using the FreeTDS Linux... Geoff Muldoon	03-24-2009 04:33 PM Geoff Muldoon	4	410
Content push from SQL Server to Client. Hello again, Is there anyway a client can 'subscribe' to a table and automatically be notified of changes to the data when connected to sql server... A. User	03-24-2009 03:59 PM Erland Sommarskog	1	140
Simple sproc executes 240 times slower when called from asp.net thanwhen called from QA Hi. My site's users will upload some "PIN" excel files. On receiving them, I have to investigate their structure, and if correct, load... Radu	03-23-2009 04:35 PM Erland Sommarskog	5	150
Why quiet installation of sql server 2005 express no longer works? The following code was working on XP SP3 machines even a few weeks ago, but failed now. Start /wait SQLEXPR.exe... DL	03-23-2009 11:52 AM DL	0	227
SQL Server 2005 - filegroup backup/restore problem Hello everyone, I have a problem with filegroup restore - short description: 1) I restore a filegroup from the filegroup backup with NORECOVERY,... Darek	03-20-2009 03:55 PM Erland Sommarskog	3	331
Just Curious I have a C# application that compares IP addresses in a table. In table A, the IP address is in the format of 192.168.001.021 and in table B, it is... Ron	03-20-2009 10:33 AM Andrew Morton	2	174
help with SELECT Case statement Hi, I'm trying to get the following statement to run but receive the following error message on an SQL Server 2005: "Only one expression can be... wibni	03-18-2009 12:19 AM wibni	9	149
Collecting data from two tables Hi, I have a view like: CREATE VIEW dbo.testview AS SELECT f1, f2, f3 FROM dbo.maintable Gerd Brix	03-17-2009 07:06 AM Plamen Ratchev	2	226
create unique string with restrictions. ( 1 2 ) Hi. I hope you can help me, I feel kind of stupid. :) I need to generate unique varchars, that fullfill the following conditions: - exactly 8 chars... Gerrit	03-17-2009 05:51 AM Gerrit	12	240
Counting Records By Time I'm trying to get a count of records based on time. For example - all calls between 7 AM to 1 PM, 1 PM to 4 PM, 4 PM to 10 PM, and 10 PM to 7... Jennifer	03-16-2009 11:52 AM Jennifer	2	132
Database Updates within a software upgraded How do you guys handle software upgrades? We currently use Wise for the installation process and use DELTA (change) scripts for the database updates.... GM	03-16-2009 06:54 AM juanv@infomc.com	3	227
ISO-11179 naming conventions Questions about the standard for Joe Celko and anyone else: Questions: 1. Am I looking at the right standard? * 2. Shouldn't the data be named the... bill	03-16-2009 02:38 AM --CELKO--	6	174
Transaction identifier? We are looking to implement trigger level auditing of the database, but I would like to include in this the 4GL component, application (not SQL... Iain Sharp	03-13-2009 05:03 AM Iain Sharp	1	233
Take Control of your SQL code! v5 of DB Ghost SQL Change Management tools now out with over 1,000 improvements. Free eval at http://www.dbghost.com/ggmssql1.htm The toolset has... malcolm.leach@innovartis.co.uk	03-12-2009 07:43 AM m_baekdal@hotmail.com	1	123
Re-design of data storage table ( 1 2 3 ) Hi, I have been tasked with redesigning the way that our application data is stored in the database. I have come up with the way I think it should... Paul	03-11-2009 07:33 AM Leif Neland	24	559
SQL Server Express 2005 Asp.Net Hi - i was wondering if someone can help me. Basically i have been building an SQL (2005 express) & Asp.Net (2.0) solution that connects to my SQL... csgraham10001@googlemail.com	03-10-2009 07:14 AM csgraham10001@googlemail.com	0	132
Syntax error in MSDN Library? Hi, check out this MSDN Library page (it's about the FROM clause): http://msdn.microsoft.com/en-us/library/ms177634.aspx In line 8... ©ime Vidas	03-09-2009 05:44 PM ©ime Vidas	2	134
return counts from multiple ranges? Hello, Can anyone point me in the direction of this? I'll simplify the example, so take a table with two columns, CustomerName and UserCount. What... Jamesb	03-06-2009 08:54 AM Jamesb	2	132
Creating a trace from a script I do this all the time on SQL 2005 but for some reason it's not working properly on SQL 2000. I'm trying to create a trace from a script... Bill E.	03-06-2009 07:03 AM Bill E.	5	263
Business Intelligence when an economic downturn becomes a soberingreality Business Intelligence when an economic downturn becomes a sobering reality (EBW) Friday 6th March, As an economic downturn becomes a... JTP PR	03-06-2009 05:03 AM JTP PR	0	99
Stored Procedure Enhancing Performance Hello everyone. Using SQL Server 2008. I am a amateur but any help appreciated. I have a Stored Procedure that does several steps. First step... eighthman11	03-05-2009 12:59 AM Erland Sommarskog	1	109
beta call - Query tool Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to... Itamar	03-04-2009 09:28 AM Itamar	0	135
Cant get them at once.. and count()! Hi all, I want to get all the Groups in one Query, but i cant find it out.. The query looks like this: Code: Select acc.Textfield2 as... xmux	03-04-2009 09:04 AM xmux	7	148
What SQL Statements are currently running within a Procedure? Hi, When a Stored procedure is executed is there a way to find out what sql statement is actually being executed inside SQL. DBCC INPUTBUFFER (SPID)... Query Builder	03-03-2009 04:46 AM Henrik Staun Poulsen	4	137
Add autoincrement to an existing table. Hi everybody: Is there a way to make set autoincrement to a field in an existing table? The scenario is: I have a table that has no autoincement... macruzq	03-02-2009 12:26 PM newscorrespondent@charter.net	2	134
Query Analyser displays SQL list ordered by last modified descendingnot filename ascending I'm not sure what's happened, but the File Open window under Query Analyzer is showing the filenames in LIST format with the names displayed in... byrocat	03-02-2009 09:01 AM byrocat	0	134
Optimising behaviour changes for the worse when a Union is introduced- can we help it The execution plan for this query shows it is a simple constant scan. There is no need to access the table in any way as the result set will always... Aidan Hall	03-02-2009 07:44 AM Aidan Hall	4	132
Saving a file in the Management Studio I don't know if this is the group for questions about the Management Studio. If not, please let me know where I should post. For some reason, ever... Dom	02-28-2009 01:56 PM Dom	4	139
column filter The following query will return 3 word in 3 "TABLE COLUMN", How can I modify the query to return "NO 3 words are the same"? the following Table will... Carl Forsman	02-27-2009 02:18 PM Plamen Ratchev	3	148
Problem with 'case sensitive' after changing collation Hi, the collation of my database was: "Latin1_General_CI_AI". I changed it for "Chinese_PRC_90_BIN" because I want to store chinese and english... boomcreation@gmail.com	02-26-2009 09:23 PM boomcreation@gmail.com	2	123
Odd schema issues after restore Hello, I need to do some testing on an app. I restored the sql 05 database on a new server. Here are the following steps I did: 1. restored db 2.... j	02-26-2009 04:47 PM Erland Sommarskog	1	126
Problem Setting up Database Mirroring I'm having a small problem configuring database mirroring. I tried to do it through Management Studio but ran into some problems. I was able to make... mastershake	02-26-2009 04:25 PM mastershake	0	113
Update query using 2 separate servers Hi guys... im just trying to update a table using 2 server (using Linking Server) this is the scenario just like i`ve done.. update... Hansel Ortiz -[BrEcHaWarr]	02-26-2009 04:19 PM Erland Sommarskog	8	130
join statement The following query will output 2 words that's close in position, but how can I output 3 word that's close in position instead of 2 word? the query... Carl Forsman	02-25-2009 07:03 AM Plamen Ratchev	1	245
Problem Refreshing Views I recently converted all my db's bit fields to smallints. I refreshed all the views using: SELECT 'EXEC sp_refreshview ' + quotename(name) FROM... Neil	02-25-2009 04:59 AM Neil	2	231
Ok, need help with another query I have another sort of flattening problem, but more of a tree issue I think. create table attributes ( parent_id int, attributes_id... Greg D. Moore \(Strider\)	02-24-2009 04:44 PM Plamen Ratchev	3	240
Archiving a database I am looking for a way to archive a database without archiving the delete statements. So just insert and updates are performed on the archive... heijden68@gmail.com	02-24-2009 03:45 PM Greg D. Moore \(Strider\)	1	140
Help with Data Driven Query - Update Good morning, I've got a DTS package that includes a single Data Driven Query whose purpose is to update address records in a SQL Server... FiMac	02-24-2009 09:57 AM FiMac	0	220
query Why the following query does not work? select a.Word, b.Word a.Document from data where ABS(a.Position - b.Position) < 3 and a.Document =... Carl Forsman	02-23-2009 08:20 PM Plamen Ratchev	1	169
Why is performance of WITH so bad? Hi all, I've recently stumbled upon this construct, that AFAIR doesn't appear in the ANSI:SQL standard (I'm no expert). In light of a very... iT_Ti	02-21-2009 04:46 PM Mxyplx	8	158
Q: sqlcmd equivalent of @script param Hello Just getting used to sql server, I'm figuring out how to do some things I find useful from the command line, which appears to mean... Malcolm Dew-Jones	02-21-2009 04:08 AM Erland Sommarskog	1	130
deleting row Hello, I have 3 Databases live We do rougly 200,000 transactions per day after lets say 2 years i want to move old Data to a History... DaveL	02-20-2009 12:16 PM DaveL	3	183
Linked server to its self? Is it possible? SqlServer 2000 Hi, I have multiple databases for the same application on SQL Server 2000; each database is for different project. They have exactly the same... Inna	02-20-2009 09:30 AM mednyk@hotmail.com	2	165
sp_who in 2005 only working for sa I use the results of sp_who to find out how many people are logged into a particuler application and control the licensing, this has worked OK in... Viasys	02-19-2009 04:00 PM Erland Sommarskog	3	139
ISALPHA() I have a string '5B3' and I want to determine if it is both not numeric and not alpha. For example: ISNUMERIC('5B3') = 0 This doesn't help me... laurenquantrell@gmail.com	02-19-2009 07:16 AM --CELKO--	9	286
Qustion about transaction log Hi, If SELECT statement is done on a table and that table has no trigger on sql statement. Does sqlserver keep track of this transaction somewhere,... grawsha2000@yahoo.com	02-19-2009 07:08 AM Plamen Ratchev	1	223

Page 17 of 283

« First

117

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