Rating Thread / Thread Starter	Last Post	Replies	Views
Optimzer Questions Hi Everyone, Sorry for the cross-posting from MSDN forum if you read that. I have two questions about the query engine. One is easy, one not so... Eric Proegler	03-06-2006 08:49 PM Conor Cunningham [MS]	6	125
error 14274 After I change a job and want to save, it gives me error as following: error 14274: Cannot add, update or delete a job (or its steps or... 00KobeBrian	03-06-2006 08:47 PM Sue Hoegemeier	4	305
bytes per i/o In SQL server 2000 it recommends configuring 64 kb stripes when setting up raid arrays. So technically each I/O is 64 kb. But when I am monitoring... tbone	03-06-2006 08:15 PM Linchi Shea	2	73
View Results: Column Headers? Is there a way (like with queries) to get the column headers when copying results when running a view? I can't seem to find a setting for... TomT	03-06-2006 07:53 PM Steven Cheng[MSFT]	5	78
check replication conflicts programmatically Hi, I would like to know if we can check merge replication conflicts programmatically. which tables do we need to check for replication... mitsql	03-06-2006 07:26 PM mitsql	0	64
Can't get into sa account In SQL Server 2005, I renamed a database but it did not rename it in the login default database. Since this is the default database for the... Terry	03-06-2006 06:52 PM Mike Hodgson	1	57
Drop-down in DTS Package cut off When working in DTS, specifically in the Transform Data Properties window, when I click on the drop-down in the Table/View field the path will... JKKUS	03-06-2006 05:09 PM JKKUS	3	46
NEED HELP with sql server express and Windows Service !! Hello i'm developping a Windows Service accessing a database on SQL Server Express, the service is doing file imports every night. The problem is i'm... mateo	03-06-2006 04:35 PM Keith Kratochvil	3	71
change password on sql service account For security, I need to change the password of my sql service account. Will this break anything? Is there a kb article on this? Tim	03-06-2006 04:34 PM AndyP	2	79
SQL cant see new drive. SQL2K sp3a. I just added a new hard drive to my SQL Server but cant see it. Any ideas why? I can go right on the box and create a new folder on it,... ChrisR	03-06-2006 04:32 PM ChrisR	1	83
SSIS - check for duplicate file in Script task? I've got two folders - Folder1 contains files that I want to process. Folder2 contains files that I've processed in the past. I want to compare the... Corey Bunch	03-06-2006 03:51 PM Corey Bunch	0	63
Urgent help - Where is backup applicaton log ? Hi, I created a schedule job using SQL Server agent to backup a database. I found that there is a error message in event viewer's application... david	03-06-2006 03:37 PM Geoff N. Hiten	2	81
stored procedure: Incorrect syntax with successful syntax check? Hello, I made a copy of sp_helprotect system stored procedure and saved it to sp_helprotect_new. Then I modified sp_helprotect_new to meet what I... bing	03-06-2006 03:32 PM bing	0	76
SQL Server 2000 requirement I have a server which meets the SQL Server 2000 hardware requirements. However, this server will also be used for serving other critial... Johnny	03-06-2006 02:32 PM David Gugick	1	72
Can't remotely access SQL 2005 named instance SuHi, I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1 server. I installed a default instance, and then a named instance... Ant-nee	03-06-2006 01:54 PM _Stephen	4	87
Index tuning wizard Hello! Is ist necessary to put the database, i want to run the index tuning wizard on, into the single user mode? Many thanks in advance. Christoph xoph	03-06-2006 01:45 PM AndyP	1	64
Will local Disk system do it? Hi, One of my clients is developing an application that has high I/O throughput. Approx. 1000 IOPs per sec, but only about 700 bytes write per sec... ×©×—×¨ ×‘×¨	03-06-2006 12:30 PM Andrew J. Kelly	6	87
Problem with transaction log Hello, I have problems explaining the behavior of the transaction log. We have an SQL Server 2000 database that is used mostly for providing... Ragnar Midtskogen	03-06-2006 11:58 AM Ragnar Midtskogen	4	96
where are permissions stored? Hi, I apologize first if this is a duplicate post. When I finished and clicked post, I was brought up the login page, after logging in, I was... bing	03-06-2006 11:55 AM Ragnar Midtskogen	3	89
new SQL Server 2005 install giving login error... HELP! I completely uninstalled 2000 and did a clean install of 2005. I restored my database and users and all seems fine. I am set up with mixed... SharinDenver	03-06-2006 11:39 AM SharinDenver	2	86
Security implemented in an MDF - what about deployment? I had setup the security from the asp.net configuration. I added roles and user accounts. It created an mdf file with all the security related... Progman	03-06-2006 11:32 AM Keith Kratochvil	1	74
sp_define_log_shipping_monitor I am getting following error while setting up the log shipping . Error 2821: Could not find stored... Prabhu	03-06-2006 10:56 AM Prabhu	2	113
Upgrade path from Express to Standard? Hi, We've been using mysql and are excited to look into the sql express edition as a replacement. We would be implementing SQL Express in a... mbell	03-06-2006 10:55 AM Roger Wolter[MSFT]	1	91
SQL Computer Management Hi, I have installed SQL Server 2005 Developer Edition as a named Instance on my server but I am looking for the SQL Computer Management Option on... Phil	03-06-2006 09:50 AM Phil	4	164
SSQL Cluster Do I need to purchase 2 lic of SQL server to cluster in active pasivein a 2 node configuration. George	03-06-2006 09:26 AM Immy	1	93
How to deposit Username and Password for access on MS-SQL-Database out of excel Hello, I access data of a MS-SQL-data base (w2kserver) with Excel 2003 and update the data automatically. I would like to deposit user name and... e.yaqoubi@applichem.de	03-06-2006 08:27 AM e.yaqoubi@applichem.de	0	83
SS2000 setup Someone else installed SS on what is to be a production server that we want to be as secure as possible. I'm wondering about some of the settings for... Dan D.	03-06-2006 08:19 AM Dan D.	2	77
Benutzerdaten hinterlegen für Datenzugriff aus Excel auf SQL-Datenbank Hallo, ich greife mit Excel 2003 auf die Daten einer MS-SQL-Datenbank (w2kserver) zu, und aktualisiere die Daten über "Daten aktualisieren". Ich... e.yaqoubi@applichem.de	03-06-2006 08:13 AM e.yaqoubi@applichem.de	0	93
date query Hi, I'm trying to convert the last four numbers of the following string SP1/84/056351/0406 to a date. It should default to the 31st of the month.... rosco	03-06-2006 08:09 AM Daniel Crichton	4	79
unable to explain single user benchmark times not being consistent SS2K Enterperise Server. Installed on different duals, quads as dedicated database boxes. Base tables are classic star schema with basic indexing but... the6campbells@hotmail.com	03-06-2006 08:06 AM the6campbells@hotmail.com	0	77
Virtual hard disk Hi, My database server runs very slow. It is only 100-200MB at this moment. And should not be exceeding 300MB because old data is deleted... guoqi zheng	03-06-2006 07:41 AM Andrew J. Kelly	6	97
Triggers Where I would go and create Triggers in SQL Server 2000 through Enterprise Manager. At the same time after creation I also want to edit the Trigger... aroraamit81@gmail.com	03-06-2006 05:31 AM aroraamit81@gmail.com	2	91
Can u swap the columns after creation of table hi, my doubt is --can u swap the columns of the table ie.., create table dd(f int ,e int ,g int) table structure ; f e g 1 2 4 now i... satish	03-06-2006 05:22 AM satish	2	88
bytes used by datatypes Where can i find how much bytes datatypes such as int,datetime,money,bit,varchar consume ? Thanks Hassan	03-06-2006 05:16 AM amish	3	97
Beta Data Conversion I have a data file in Beta 2 version, but now I've already uninstalled the beta version and installed a new Release Version of SQLServer 2005.... Jeffrey Kam	03-06-2006 04:49 AM Uri Dimant	5	94
order data Hi all, someone could help me? I need to order some records by data; the problem is the definition of that data field: it' is't a datetime format,... Wasco	03-06-2006 04:41 AM Wasco	4	88
DBCC CHECKDB Reporting Errors in - SQL Server 2005 HI, I am getting this ttype of errors in SQL Server 2005, This table have xml column. Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID... Srikanth	03-06-2006 02:34 AM John Bell	1	92
Dts problem with dual installation of sql 2000 and 2005 on same box I have Sql 2000 installed first, and a second install of Sql2005 installed as an instance on the same win 2003 server. Dts 2000 designer is raising... Colin Robinson	03-06-2006 02:18 AM Peter Yang [MSFT]	8	60
The text, ntext, and image data types cannot be compared or sorted...wha? Does anyone know what this means? Microsoft OLE DB Provider for ODBC Drivers error '80040e14' The text, ntext, and image data types cannot be... Nathon Jones	03-06-2006 01:53 AM John Bell	5	920
Changing server collation Hello there I've tried to change collation of my server using rebuildm It gave me an error: Rebuild master failed with error: -1 The database was... Roy Goldhammer	03-06-2006 01:43 AM John Bell	4	107
Block access to system objects & system stored procedure Dear Sir/Madam, Is there any convenience ways to block a list of users account from access to system objects e.g. sysobjects, syscomments etc and... Henry	03-06-2006 01:16 AM Henry	0	83
Restrict DTS execution Hi, Does anyone know how to restrict the exceution of DTS packages? The case is I've got some users which want to see the packages that are currently... FJC	03-06-2006 01:09 AM Dejan Sarka	1	78
Installing SQL 2005 Developer Edition I want to install SQL 2005 developer edition (and want to keep a default instance of SQL 2000 running on my machine) Couple of months ago I... c_shah	03-06-2006 01:08 AM Alex Cieszinski	4	83
Comments on Software RAID for O/S volume? Hi, We're going to be purchasing a database server from IBM. Although the database itself will be housed on a 10-drive SCSI-based external... The One We Call 'Dave'	03-05-2006 11:38 PM Mike Hodgson	2	99
Triggers failing Hi, What could cause an update trigger on a table to fail? Details on anything and everything that could do this would be much appreciated. Jason Fischer	03-05-2006 08:10 PM Jason Fischer	7	83
to monitor user logins/logouts Hi All , This link is from a previous posting http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm and i followed the instructions . I am... maxzsim via SQLMonster.com	03-05-2006 07:43 PM maxzsim via SQLMonster.com	9	62
Help with Query Hi, I am trying to perform a query that is beyond my knewlegde and was after little help, I have two tables in my db, national and CDR. the... Crumb	03-05-2006 05:38 PM Hugo Kornelis	3	102
maintenance plan error Hello I try to create a maintenance plan, but without success, having message error : Error 8114: error converting datatype int to tinyint. Please... Elijah Bass	03-05-2006 02:56 PM Sreejith G	1	103
Help Pls - Reporting Table Descriptions Using sys.extended_properties Hi, Using SQL Server 2005 I'm trying to write a view that joins two catalog views (sys.tables and sys.extended_properties) to produce a two... Simon	03-05-2006 02:21 PM Simon	2	87
ADP project on SQL 2000 sp4 We currently have a adp project linked with a Sql server 7 running NT4. We need to replace old server with a win server 2003 with SQL 2000 sp4. When... exchangerookie1994	03-05-2006 02:06 PM Sue Hoegemeier	3	94

Page 501 of 1157

501

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