Sponsored Links

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

Page 34 of 282

« First

134

Last »

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Upgrading old query 7 to 2005. Hi all; To Defrag the index at the moment we use a query that among many other things it does: ... declare object_cursor cursor for select so.name,... valigula	02-17-2008 05:23 AM Erland Sommarskog	3	19
Problem With SQL UPDATE HI, I want to know if is possible to update Table1.Col5 from an Table2.Col3 ?? The Problem is Col1 and Col2 doesn't have a same size. Exemple of... SAM	02-16-2008 04:23 PM Erland Sommarskog	6	11
CURRENT WEEK WALKIN UPDATES - VISIT www.walkincareers.com Dear Job Seekers, Greetings from walkincareers.com - The Ultimate Walk in jobs Portal. For the Walk-In drives across India kindly log on to the... jobsearch.india02@gmail.com	02-16-2008 01:14 PM jobsearch.india02@gmail.com	0	13
Log File Recovery. I have a Sql Server Transaction Log file that was corrupted from a power failure. Can someone help me with ideas of how to recover it please. (MS... Kissi Asiedu	02-16-2008 10:14 AM Erland Sommarskog	1	12
Rowlock v. optimistic concurrency Hi, Sql-Server 2000, 2005. A report fetches a lot of rows using the "WITH (ROWLOCK)" syntax (the sql is generated on the fly by a tool and not... Roger.Noreply@gmail.com	02-16-2008 07:49 AM Robert Klemme	9	11
Trigger Question Have a table that has following fields (pkid, field1, field2, field3, field4). I need to create a trigger that will insert a row into another table... Chico Che	02-15-2008 05:04 PM Hugo Kornelis	9	21
CharIndex, Left T-SQL question Hello, I was hoping someone could help me with this SQL statement. The column 'options.optionDescrip' is a varchar field. Some values of the... jeremy@flatironsinternet.com	02-15-2008 10:35 AM jeremy@flatironsinternet.com	3	10
importing multiple excel files Hi I have multiple excel files of the same format in a directory. They are called book1.xls, book2.xls, book3.xls and so on. What is the easiest way... ciaran.hudson@gmail.com	02-15-2008 03:51 AM Jack Vamvas	2	10
Re: How to delete doubled records in one query? A unique row identifier is required to perform a set-based delete of the duplicates in a single query. Without one, you will need either a cursor... Dan Guzman	02-14-2008 10:57 AM jhofmeyr@googlemail.com	4	12
Tips on working around Identity column for temp tables? I am maintaining an existing app that used Create Table statements to generate temp tables (within sprocs). The columns defs are taken from... Mamba	02-14-2008 12:30 AM Tony Rogerson	3	13
How to check setting of CONCAT_NULL_YIELDS_NULL I would like to check the setting of this variable in our MS-SQL 2000 database. Also, is there info on what the default value of this variable is? metaperl	02-12-2008 06:22 PM Plamen Ratchev	6	7
SQL 2005 OSQL qestion on Microsoft cluster Hi, We upgraded SQL 2005 instance on the Microsoft cluster. We have bunch of code which uses OSQL and BCP do not specify -S option since the code was... arichie	02-12-2008 06:13 PM arichie	0	10
Enum the running SQL instances using DMO Hello, I want to enumerate all the RUNNING SQL instances using SQL DMO. But any of the following methods would not help ListAvailableSQLServers... velu5	02-12-2008 08:19 AM Plamen Ratchev	1	10
Interactive Sort on Matrix in RS Hi, I have a Matrix in RS and I would like to sort the data fields based on a header. I've been searching for an answer to this and it appears it's... lee.richmond	02-11-2008 10:15 PM lee.richmond	0	11
Problems character sets / special characters dot.Net <-> mssql-server Hi, I come from the "dark side" php/mysql and there often problems with character sets (utf-8, latin...) and storing data in datebase. Exists in the... Klaus Herzberg	02-11-2008 05:37 PM Erland Sommarskog	2	9
Why does Error log show database restarting everytime a transactionlog backup runs? Why does Error log show database restarting everytime a transaction log backup runs? It also runs a checkdb as well. The log backups are scheduled... Sanctus	02-11-2008 05:28 PM Erland Sommarskog	1	13
Urgent walkin interviews from top rated companies Dear Job Seekers, Greetings from walkincareers.com - The Ultimate Walk in jobs Portal. For the Walk-In drives across India kindly log on to the... jobsearch.india02@gmail.com	02-11-2008 06:43 AM jobsearch.india02@gmail.com	0	11
on line discuss Hello, I am shashi kanta , I want on line help on some topics. sharma.shashikanta@gmail.com	02-11-2008 01:25 AM sreejith s	1	29
Re: New Release of Mogwai ERDesigner NG Ed Murphy (emurphy42 (AT) socal (DOT) rr.com) writes: One thing is for sure: the discussion on whether the posting is on-topic for... Erland Sommarskog	02-10-2008 07:00 PM Mel	1	11
slow stored procedure The following procedure took over 24 hours to run. I've tried several things to make it faster but since I am a beginner I figured I would just post... remylawrence@gmail.com	02-08-2008 10:08 PM Shigeaki Kobayashi	2	12
Simplest way to write a boolean expression in the SELECT clause? ( 1 2 ) My sproc code, simplified: declare @x int declare @y int declare @Result bit --Assign @x and @y by running some complex code. --For testing we will... Tom van Stiphout	02-08-2008 09:42 PM Tom van Stiphout	10	27
Help setting up a view How do I set up a sql statement to use as a view? I want to use two tables but they are both from different databases. From the Offices database I... JJ297	02-08-2008 07:39 PM JJ297	2	11
Primary Key fails to copy in db Export Currently, I'm exporting a database from production to local (test) machine. I've done this several times without problem, but during the last few... ll	02-08-2008 05:33 PM Erland Sommarskog	5	11
Why does numeric data type use storage inefficiently? I have found several sources stating that the numeric data type in SQL Server (without vardecimal options set) stores numbers of precision 10-19 in 9... residual.interest@gmail.com	02-08-2008 01:32 PM residual.interest@gmail.com	3	10
System DB backup Error I have configured the system database backup using SQL Server 2005 Maintenance Plan. It was running properly quite some time with in 5 to 10 minutes.... Praveen	02-07-2008 05:26 PM Erland Sommarskog	1	11
Proper scripting of table with belongings Hello all, SQL Server 2000 SP3. Recently, I was preparing a lot of scripts, for all objects in the DB. As for SP's, UDF's, VIEW's and triggers it... Matik	02-07-2008 05:23 PM Erland Sommarskog	1	11
Help in Table level restore/backup Hello All I am currently doing a project on MS SQL Server 2005 where I am in need of table level backup/restore. I know about FILEGROUP. But in our... Nasif	02-07-2008 02:26 PM VIPS	5	12
Create a new table from csv file using SSIS I was able to create a new table using dts package and an incoming flat file that had col names in the first row. Can this be done with SSIS? k4	02-07-2008 09:07 AM Jack Vamvas	1	10
sql server migration issues we recentely tried migrating our databases from 2000 to sql server 2005.The migrated databases had some issues like collation issues,so we created... 83rish@gmail.com	02-06-2008 05:55 PM Erland Sommarskog	1	9
Sending xp_sendmail from sql 2000 I'm able to send an email from query analyzer with this: master..xp_sendmail @recipients = 'jj297 (AT) yahoo (DOT) com', @subject = 'Over Due... JJ297	02-06-2008 05:36 PM Erland Sommarskog	1	12
Distributed Transactions across Linked Servers Hello. One of our database developers is running into a problem when trying to get distributed transactions to work across linked servers. ... Tim - Milwaukee	02-06-2008 09:26 AM Tim - Milwaukee	0	8
Refresh routine for single view contained in all company (client)databases Hi, I have multiple client databases sharing the same structure that contain a view (dbo.Act1) that needs to be refreshed on a constant basis. The... Chris H	02-04-2008 05:55 PM Erland Sommarskog	2	9
Fiscal Year Help Greetings All, I have a SQL question that maybe someone out there can help me with. Our fiscal year starts on 01/27. I want to write a query that I... CK	02-04-2008 05:31 PM Plamen Ratchev	2	10
Need help writing a stored procedure How would I write a stored procedure to get * where duedate is less than and not equal to today's date. Is this right? select * from library where... JJ297	02-04-2008 09:54 AM Jack Vamvas	2	10
Avg() not including 0's Hi, I have a sql query like this select avg() from data where date > '1/5/08' and date < '1/10/08' group by order by desc If all values within... lee.richmond	02-04-2008 09:46 AM Ed Murphy	8	14
SQL query for this purpose We have two tables and data similar as below Table: MASTER -------------------- Master_id - Dsite -------------------- 1 - NewYork 2 -... MadhavC	02-04-2008 09:31 AM Daniel Eyer	2	12
sql learning I am thinking about doing a computer course.It is learning about sql to become an MCDBA.I am trying to find out how difficult this could be as I will... ian2572@googlemail.com	02-01-2008 02:00 PM --CELKO--	4	17
Join 4 tables - can it be done? I need some help, i need to join 4 tables but get a huge number of results, so I must be doing something wrong. here are my tables WebGroups -... SirCodesALot	02-01-2008 01:50 PM Plamen Ratchev	6	12
autonumber I am working with a database that was created in Lotus and importing it into Access. There are hundreds of clients in this data base that have to be... cbrewer2@kc.rr.com	02-01-2008 12:20 AM Tom van Stiphout	4	34
Inserting multiple records into two tables...with a twist ASP/SQL Server Express 05 I have two tables, A and B. I would like to insert multiple records into both form A and B, but a field in form B is the... t8ntboy	01-31-2008 09:41 PM Ed Murphy	4	11
help with update Hi all.....Im ok with sql but by no means a guru i have like 100,000 rows of lineitems example: invoiceid, lineitemId, squencenum 9999999 11111111... Analizer1	01-31-2008 09:36 PM Ed Murphy	3	17
Create Table with Variable included in Table Name Hi, I am trying to create a routine for generating tables from a master response table. The end result would increment the variable "somevalue" by... Chris H	01-31-2008 05:40 PM Erland Sommarskog	5	11
trig errors Greetings, I am getting a data conversion error I cannot explain! This statement UPDATE dbImageList set cx =... Daft Pict	01-30-2008 11:18 PM Ed Murphy	2	23
Dynamic date range for each row? Hi, I'm trying to group data by date range, but each row of data could have a different date range based on a variable. I want to say "look at the... lee.richmond	01-30-2008 05:23 PM Erland Sommarskog	4	11
detach database file from local SQL Server Express instance by C#? I am using the following C# code to establish a SQL connect to a SQL database file: // connection string // attach a SQL database file to a local... sg71.cherub@gmail.com	01-30-2008 10:10 AM Plamen Ratchev	1	12
Alert doesn't work on SQL 2005 Hi, I have trouble getting the alerts to work on SQL 2005. Below I define a custom message and a custom alert. When I raise the error though the... Patrick	01-29-2008 05:50 PM Patrick	0	11
REPLICATION hi all i have three server each server have DB for replication EX Three DB's A B rajdaksha@gmail.com	01-29-2008 11:52 AM rajdaksha@gmail.com	0	17
Deploying CLR trigger to SQL-Server 2005 -- Permissions Required. I've written a C# trigger on Developer_Box, using VS 2005 Professional. I need to deploy it on Test_Server, running SQLServer 2005. It compile fine,... chris	01-29-2008 11:26 AM chris	2	10
Select statement query In my select statement, I return a column for 'datediff' using a CASE query. I call this column 'Elapsed_days' is there anyway I can use this... Jules	01-29-2008 09:48 AM Plamen Ratchev	1	14
Important about MySQL Certification Information about MySQL Certifications (Newbie) http://career-assessments.blogspot.com/2008/01/mysql-most-popular-open-source-sql.html For MySQL... educational.mysql@gmail.com	01-29-2008 12:57 AM Ed Murphy	1	11

Page 34 of 282

« First

134

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