Sponsored Links

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

Page 42 of 282

« First

142

Last »

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Can a View be protected to support "JOINS" only? I know this is a way-out question, and I'm not confident of a positive answer, but I'd like to know whether it is possible to protect/secure a... Kevin Frey	10-10-2007 08:06 AM Erland Sommarskog	1	45
Business Intelligence Consultancies must adapt to survive and prosper. The business intelligence market is changing rapidly. Three major forces driven are changing the landscape. Firstly, BI software vendors are working... YellowFin Announcements	10-10-2007 08:02 AM YellowFin Announcements	0	38
Joining SQL Results Sorry newbie question... I have made two different search queries on the same table that both retain the identical column information. $resultfirst... Alec	10-09-2007 08:13 PM --CELKO--	2	42
How to select a word substring in a coumn header from right to left I have an application providing me with multiple headers which I have mergerd into one big header (below), this header my not always be the same but... sjharri@gmail.com	10-09-2007 08:07 PM --CELKO--	2	42
Opinions on SQL Server hardware Hi all, I was wondering if I could get some experienced opinions on SQL hardware to run an ERP app on SQL 2000. The app does not yet support SQL... Artie	10-09-2007 10:25 AM Tom van Stiphout	3	42
SQL Server does not allow remote connections. Hi all, i'm using MSSQL Server 2005 Standart Edition. i created ASP.NET application without MSSQL Server 2005 Express. every time i Run my app always... aCe	10-09-2007 02:06 AM Nick Chan	2	47
Sql Server 6.5 Client Tool and ASP.net Hi, I want to connect to Sql 6.5 server database server, What clientTool should I use to connect it? And also Is it possible to update records in the... ABCL	10-08-2007 06:05 PM Erland Sommarskog	2	37
Help a newb (issue with excel, ms access and SQL Server) hello everyone. I recently changed the database of a project from Ms Access to SQL server and had to make a lot of adjustments but there's one here... joaotsetsemoita@gmail.com	10-08-2007 06:03 PM Erland Sommarskog	1	40
time conversion hiccup ( 1 2 3 ) Hi, ddl & dml project varchar(10) start char(5) stop char(5) ------------------------- ----- ----- hey now 21:00 19:25 new... DonLi2006@gmail.com	10-08-2007 05:46 PM Erland Sommarskog	20	131
Dynamic Tables Names and Temporary Tables Options Firstly I consider myself quite an experienced SQL Server user, and am now using SQL Server 2005 Express for the main backend of my software. My... brstowe	10-08-2007 05:30 PM Hugo Kornelis	3	51
A Must Read-MCSD!!! Excellent resource has been found on SQL Server exam 070-229. http://technical-talk.com/mc/mcsd/mcsdqa01.asp rojer.bake@gmail.com	10-08-2007 05:11 AM rojer.bake@gmail.com	0	47
[ANN] WebSQL - web based database administrator tool This is a web based application that can be installed on a web server in your environment to manage your database over a browser. At moment is... WebSQL - staff	10-07-2007 10:45 PM WebSQL - staff	0	44
Retrieve next lowest number in mixed set On 6 Oct, 18:34, Rodrigo De León <rdele... (AT) gmail (DOT) com> wrote: How about: SELECT t1.sequence_id +1 vacancy FROM sequence t1 LEFT JOIN... Zamdrist	10-06-2007 05:29 PM strawberry	6	56
I want to parse @ArrayOfDays into @d1 through @d5 ( 1 2 ) In my stored procedure, I want to parse @ArrayOfDays into @d1 through @d5. @ArrayOfDays is a varchar input parameter containing, for example,... bobc	10-06-2007 05:19 PM Erland Sommarskog	17	81
migrating MSSQL databases to MySQL Hi all, I want to migrate databases in microsoft sql server 2005 express edition to mysql, please anyone can tell me how can i do this.. i tried... agnesroz@gmail.com	10-06-2007 11:37 AM pamela fluente	2	44
Computer Security Information (Free Articles and eBooks) I Want To Share Computer Security Information To All Internet Netter. A. Computer Security Articles: 1. Firewalls Torn Apart 2. Guide To Social... adam.akelis.com.use@gmail.com	10-05-2007 08:41 PM adam.akelis.com.use@gmail.com	0	44
Problem with object owner not dbo I'm probably forgetting something basic, but right now I'm stumped. We are moving a database to a new server. bcp'd out the login accounts and bcp'd... Teresa Masino	10-05-2007 05:43 PM Erland Sommarskog	1	49
SQL 2005 Ambiguous column name I have a strange issue and was hoping somebody could explain. The below query gives an ambiquous column name error on an install of SQL... rdraider	10-05-2007 03:30 PM Serge Rielau	8	51
SQL2005 database backup files We are in the early (development test) stages of upgrading from SQL200 to SQL2005. We have noticed that our backups, created with the append option,... barbara.plume@otda.state.ny.us	10-04-2007 06:05 PM Erland Sommarskog	1	44
SQL Configuration ( 1 2 ) We are running SQL 7 on a server, and are moving to a new server and will be upgrading to SQL 2005 at the same time. Currently, both the old and the... Neil	10-04-2007 01:59 AM Neil	11	91
Finding common joins At the risk of asking a stupid question - Is anyone familiar with either a query against the systables or maybe an outside tool that will provide a... Cindy	10-03-2007 07:53 PM Cindy	6	45
SQL 2005 license downgrade to 2000 Does anyone know more details about "downgrade rights". Do you need to ask MS for this right? How do you get a CD key (a legit key) for SQL 2000... rdraider	10-03-2007 07:49 PM rdraider	0	48
Notification Services Updates My 2007 NS skill is about zero and in lieue of having a full-time DBA, I"m trying to manage a prod environment (on top of my other duties as... Greg D. Moore $Strider$	10-03-2007 06:15 PM Greg D. Moore $Strider$	0	40
negate RESULT SET, all inactive client I' d like to list all inactive clients. Inactive client is a client who hasn't had invoice for 2 months. I use INNER JOIN to join invoice view... Mike	10-03-2007 06:08 PM Erland Sommarskog	1	38
ms sql 2005 developer edition is it possible to install ms sql 2005 developer edition databse server on window XP professional version 2002 with SP2 or just allows install client... HandersonVA	10-03-2007 06:02 PM Erland Sommarskog	3	41
SQL Timeout Errors - Can Anyone Help? I have a client who has been receiving hundreds of SQL timeout error messages in their error logs. Specifically, the message looks... alvinstraight38@hotmail.com	10-03-2007 05:55 PM Erland Sommarskog	1	44
Changing Collation Hey all I have written a script to change the collation of user defined columns "en masse" in case anyone is interested: SET NOCOUNT ON; DECLARE... manstein	10-03-2007 11:18 AM manstein	0	62
SQL Server 9 - Vista 64 - Error message in Event Viewer - interactive service "(MSSQLSERVER) service is marked as an interactive service. However, the system is configured to not allow interactive services" This problems may... Accessed	10-02-2007 06:42 PM Accessed	0	54
replication or mirroring We have a sql server 2000 sp3 server on a win2k3 server standard edition. This is on dell hardware with a dell scsi dasd enclosure directly... mmark751969@yahoo.com	10-02-2007 06:07 PM Erland Sommarskog	1	54
Exporting a MS-SQL database I have an asp site connected to an MS-SQL database, I need to export the database and import it in to a MySQL database? How would I be able to do... bsagal@gmail.com	10-02-2007 08:20 AM Jack Vamvas	1	44
The best way to use the Database Engine Tuning Advisor Hello all, I want to use the SQL Server 2005 Tuning Advisor on our database, and I'm hoping someone here can just confirm the steps for me. We have... Tommy Hayes	10-02-2007 07:07 AM Tommy Hayes	4	55
strategies for paging hello, what are the strategies when designing tables that needs paging? in the past i used to use select top 200 * from table where id not in... Nick Chan	10-02-2007 01:23 AM Nick Chan	4	60
The Two Standards of the Sql CTE Sql really has two standards. There is the ANSI sql standard and then there is the DOUBLE standard. The rest... steve	10-01-2007 10:04 PM steve	0	89
Do you know what the Sql CTE really is? http://beyondsql.blogspot.com/2007/10/sql-whats-really-with-with.html steve	10-01-2007 10:01 PM steve	0	53
web database question Hi, we are thinking of installing sql server as a backend to our website. Q.1. What is the best way to do this - should we host the database on the... Sue	10-01-2007 05:55 PM Erland Sommarskog	2	35
Simple recovery model affect performance? Do you get any performance improvement by using a Simple recovery model? Full backup run each night, loss of 1 days data is acceptable. This is an... rdraider	10-01-2007 05:44 PM Erland Sommarskog	1	48
How Do I give EXECUTE Permissions on Stored Procedures? Hey guys, I'm pretty new to SQL configuration, and I need to give EXECUTE persmissions for one of the SQL user roles. I am running SQL... alvinstraight38@hotmail.com	10-01-2007 05:40 PM Erland Sommarskog	6	52
Reports of users Hi, I need to generate a report that gives me a list of all users and their access right on a sql server Any ideas how i can do this Thank in... zach	10-01-2007 12:32 PM zach	0	50
Database Security How do you determine if a particular database on a SQL Server 2000 has been compromised and/or some malware evil is stealing or removing certain data... tatata9999@gmail.com	10-01-2007 11:02 AM tatata9999@gmail.com	0	57
Re: Alternate to cursors In general this is done with two commands, an UPDATE of existing rows followed by an INSERT of new rows. Very generally: UPDATE Target SET cola =... Roy Harvey (SQL Server MVP)	10-01-2007 10:55 AM Roy Harvey (SQL Server MVP)	0	42
Problem accessing remote sql server Hi We had an sbs 2003 with isa 2000 server. We wre able to access a remote sql server (hosted at our web host) just fine. We replaced the server... John	10-01-2007 03:20 AM Erland Sommarskog	8	51
replication Hi everybody, Could you please advise me what would be the best method to synchronize MSSQL data in the following scenario: SiteA (live site) -----... aleu@vp.pl	09-30-2007 08:44 PM aleu@vp.pl	4	58
Apparent DB engine bug in SQL Server 2005 ( 1 2 ) SQL Server 2005 SP2 (build 3054) Consider the following scenario: - A complex multi-statement table valued function is created. Let's call it... Dimitri Furman	09-29-2007 12:13 PM Erland Sommarskog	13	85
dumb question Sorry about this. But I've worked primarily in access for years. Does SQL Server have a boolean or a yes/no data type for its table... news	09-29-2007 05:20 AM Tony Rogerson	2	52
find unique identifier through multiple tables Hi, I need to do a report from data in a database that was provided by a third party where there is no documentation at all. It contains more than... hugues.morel@gmail.com	09-29-2007 03:13 AM hugues.morel@gmail.com	7	63
Select Into across Linked Servers Hi. I'm trying to copy from one table to another across 2 different servers with the following: select * into #Tmp_Hdr from parsaleshdr where... Jennifer	09-28-2007 05:43 PM Erland Sommarskog	1	38
Network Packet Size Hi Guru, After we moved from old server (windows 2000, SQL 2000 and SP3a) to a new server (windows 2003, SQL 2000 and SP4) that cutting down... kmounkhaty@gmail.com	09-28-2007 05:35 PM Erland Sommarskog	1	41
Partition Optimization I am trying to update my optimization jobs so they will not optimize the older partitions (for performance and snapshot space reasons). ALTER INDEX... traceable1	09-28-2007 05:05 PM Erland Sommarskog	5	59
Users Logged In Is there a way in 2005 to tell what user is logged into what database on the SQL Server? thanks, Scott RogueIT	09-28-2007 02:52 PM RogueIT	3	56
Comparing two tables What is the correct syntax to do so. I have the same fields in the table. Tables called Books and Titles Fields are TitleID and Titles Using SQL... JJ297	09-28-2007 12:13 PM JJ297	3	40

Page 42 of 282

« First

142

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