Rating Thread / Thread Starter	Last Post	Replies	Views
Replication: Transactional: Multi Publications, One Subscriber. Greetings All, I was hoping that a replication sage might be able to answer a question for me. I want to have one subscriber subscribing to N... Louis Frolio	09-23-2004 02:29 PM Louis Frolio	3	74
Replace SQL server in multiple server network Hello all DBAs what is the best methodolgy to replace a server with a new server in a multiple sql server environment.. Is is using back up/restore... William Logan	09-23-2004 11:00 AM William Logan	0	65
CAlling a sp outside a transaction Hello, So I explain,..... A sp, named spc_A, is called from a COM component and that COM component is transactionnal. So a transaction is open and... Thierry Bertin	09-23-2004 08:11 AM Thierry Bertin	0	51
Database server connection I am trying to using sqlserver as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish... Leon	09-23-2004 06:34 AM Sunil	2	64
How to print the Table layout Hello to everyone I am using SQL Server Enterprise Manager and I would like to print the structure of each table of a database, with the purpose to... Fabio Terrosi	09-23-2004 05:56 AM Scot McDermid	2	85
How many records in a table? Hi! Stupid question as this also depends on hardware but is there a limit on how many rows I can have in a single MSSQL 2000 table? Table consists of... Martin Feuersteiner	09-23-2004 04:06 AM Martin Feuersteiner	2	80
Microsoft Reporting Service I have the following Question: Is it possible to install a Reporting Service at IIS Webserver without SQL Server 2000 on the same machine. We have... flecki	09-23-2004 03:37 AM Simon Hayes	1	72
Mailing Lists Hi All We are running SQL Server & Outlook with an exchange server. We are looking for a way to import the address book & email details into... Mick Kehoe	09-22-2004 09:59 PM David Rawheiser	2	88
Using a Select statment for the name of the field? Do any of you know if it's possible to get the name of your field from another table? E.g. Select FYear as I need the name of the fields to be... sbligh	09-22-2004 09:28 PM --CELKO--	2	84
Design Question Hi I am trying to implement a invtentory control system and would like some advice on the best design for it. The system will have to main tables... Boogieboy	09-22-2004 09:24 PM --CELKO--	2	73
Timestamp Conversion I am working with an application that is returning a second based timestamp. It returns values based on the 86440 second day in GMT. Is there an... Dave	09-22-2004 05:28 PM David Portas	1	107
How do I change the owner from a table in a database Dear Group, I have a table in the a database that I need to change the owner to dbo. How can I do this. Thanks in advance. Jeff Magouirk Jeff Magouirk	09-22-2004 05:17 PM David Portas	1	131
Removing Tuning Wizard Indexes Just curious if anyone has a script to find and delete all indexes created by index tuning wizard, leaving the original indexes untouched. All of the... crystal1	09-22-2004 12:25 PM python1	3	79
Subform problem with unique-table-property set in access adp Dear All, W2000 Office2000 Access adp SQLserver DB Problem: Adding a new property for a company in the subform. The FIRST time I Select a property... Filips Benoit	09-22-2004 08:04 AM Simon Hayes	1	75
Runtime error data provider or other service provided an efail status Anyone knows what would cause this?When Enterprise Manager is used to open a table Runtime error data provider or other service provided an efail... Vincento Harris	09-22-2004 08:01 AM Simon Hayes	1	100
Write from MS SQL to MySQL I have a MS sql 2000 db that needs to sync with a Mysql db. When a password is changed in the MS SQL table, I need to make sure that the same value... Dave	09-22-2004 04:42 AM cazz	4	76
full database backup Question 1 3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD Database size 10 GB - How long will full database backup take if... newbiegca_sqlsever2000	09-22-2004 01:00 AM newbie sql2000	2	73
Replication as backup Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the... Ian Wyld	09-21-2004 10:01 PM John Smith	2	75
Function that returns highest of two columns? Is there a function that compares two columns in a row and will return the highest of the two values? Something like: Acct Total_Dollars Collected ... Philip Mette	09-21-2004 04:58 PM --CELKO--	2	70
Synchronization of multiple clients Hi all, I've got a question concerning synchronization of multiple database clients. Consider a database, accessed by two clients. Is it guarantted,... Stephan Keil	09-21-2004 10:10 AM Simon Hayes	1	67
Outsourcinng is being outmoded http://yahoo.businessweek.com/bwdaily/dnflash/sep2004/nf20040920_0654.htm http://vmdd.tech.mylinuxisp.com/catalog/	09-21-2004 07:50 AM http://vmdd.tech.mylinuxisp.com/catalog/	0	67
Stored procedure to grant all users db_owner I am trying to come up with a stored procedure to grant all users db_owner role (rather than have to manually check the users each time) Thanks in... Tyler Smith Watu	09-21-2004 04:26 AM Simon Hayes	1	73
Record Snapshots Greetings all, please bare with me this will take a little bit to explain but I'm really hoping someone might have some ideas or can point in... Muhd	09-20-2004 01:43 PM Muhd	0	84
convert date to MMDDYYYY Hello All, I can't seem to find an answer to this anywhere else: I need to convert a datestamp to the following format: MMDDYYYY. I've... mscgloss@yahoo.com	09-20-2004 12:53 PM Simon Hayes	1	84
Need help with MS SQL research Subject: A Student Needs Your Help with Research Dear All, I am pursing a Master’s degree from Monash University. Currently, I am in the final... Rattanan Nantiyakul	09-20-2004 05:10 AM Rattanan Nantiyakul	0	64
[webcast] SQL Server 2005: Integrating SQL, XML, and XQuery Dr. Michael Rys of Microsoft discusses SQL Server 2005 support for XQuery, SQL/XML and the SQL:2003 standard. He discusses b-tree, quadtree, and... Ken North	09-20-2004 03:57 AM Ken North	0	70
Query could not be processed. Access is forbidden I am using http to access my cube (MS Analysis Server) and there are users who are getting "Query could not be processed. Access is... Ramir Santos	09-20-2004 03:08 AM John Bell	3	65
What is the best way to move data from... Am MS Access 2000 DB To an SQL SERVER 2000? (without Enterprise manager) Elisha	09-19-2004 02:17 AM John Bell	3	63
Using Transaction log to update another database I am doing some replication setup in test environment. Will it be possible to use the transaction log from a production server to update the... mokles	09-19-2004 02:14 AM John Bell	1	75
Problem: mssql locks several records in a specific table, while no one is editing them Hi, I have an Access application with linked tables via ODBC to MSSQL server 2000. Having a weird problem, probably something i've done while not... Oren	09-18-2004 04:04 PM John Bell	3	66
YUKON Setup Failure Hi, I am trying to reinstall YUKON beta 2 after uninstalling it. Now I'm getting error when it tries to install the SQL Server components and the... Jay	09-18-2004 11:55 AM Jay	0	73
index questions there are two types of indexes in microsoft sql server a) clustered b) non clustered Question can u create a primary key which is non clustered... newbiegca_sqlsever2000	09-18-2004 10:20 AM newbiegca_sqlserver2000	2	82
Need help with Stored Procedure Can someone please help me write a stored procedure? I run a query (see below) for 50 tables and for every day of the month. I would like a SP which... sah	09-18-2004 08:44 AM Dan Guzman	3	68
Hide databases in SQL EM from dbo owner If i create a new SQL login and give that login db ownership for a test db. When that user adds my SQL Server through his own SQL EM, why does... serge	09-17-2004 11:23 PM serge	3	73
xp_sendmail blocks trigger ? Dear All, we are running SQL2000 Sever and make use of the xp_sendmail. For any reason the mail service can run into problems and it looks like... Rolf Kemper	09-17-2004 11:01 PM Greg D. Moore \(Strider\)	6	113
Choosing DB Edition (Std vs Ent) I need to decided between Standard and Enterprise Edition (Cost is a criteria - but its secondary to performance - <!--and I am not paying for it... Jonas Hei	09-17-2004 05:24 PM Stephen Dybing [MSFT]	4	77
Weird Cast operator In the following examples, why the first case statement works and why the second doesn't, I wonder. Could anyone shed some light on... Ganesan Rajaraman	09-17-2004 05:10 PM Erland Sommarskog	8	84
Datetime condition in 'where' - international problem I use datetime condition in sql-query. For example: select something from sometable where date between '06/15/04 00:00:00' and '06/15/04... seigo	09-17-2004 04:57 PM Erland Sommarskog	2	69
Report effective permissions for all users? As our customers demand that we tighten our IT security in the company, I've been asked to prepare a report quarterly showing, for each user... Ross Presser	09-17-2004 04:46 PM Erland Sommarskog	5	80
DTS to add a field on imported data I am in the process of importing data that is in a text format to the sql server, I want to add couple of fields and insert general data in the... John R	09-17-2004 03:59 PM John Bell	1	59
Very long rich text information - datatype? Sorry if this seems a little basic, but I'm putting together an application where large amounts of text will be required in a single record - way... John Clark	09-17-2004 11:22 AM John Clark	3	68
Converting Access qrys with logical expressions I'm upsizing an Access database. Got the data converted, working on the front end, converting queries to views, but having trouble converting queries... Terry Bell	09-17-2004 10:27 AM Ross Presser	5	73
What resources does truncate table use Hi, We have a heavily used production server and a table which logs every hit on a web site. This table has grown large over time and we want... martin	09-17-2004 09:31 AM Carl Unternahrer	3	86
Entity Relationship Management Idea Please let me know what you think of this scheme I have come up with (not to imply that noone else has before me) for managing relationships. I have... Mike Sutton	09-17-2004 09:30 AM Mike Sutton	0	70
ETL library We are looking for an ETL library or callable application that would allow us to transfer and transform data between platforms but mainly into a SQL... elizabeth	09-17-2004 07:38 AM Adrian Edwards	4	73
Remote Sync -- SQL 2000 I am just beginning development of a new app and I need a little advice on the best way to go about doing something. The app is a project management... Jake Jessup	09-17-2004 07:11 AM Adrian Edwards	1	68
proc argument type array I have ... CREATE PROC InvoiceDeleteExample2 ( @InvoiceList1 VARCHAR(255), @InvoiceList2 VARCHAR(255) = '', ... @InvoiceListN VARCHAR(255) =... biuoserwis	09-16-2004 04:17 PM Erland Sommarskog	1	67
SQL Server 2000 - how do I change the name? I need to change the name of the SQL Server on my development machine. My client's server name is "Server1". My development server name... Hmmm...	09-16-2004 02:36 PM Hmmm...	3	84
Transaction-style Inventory? Hello, I'm looking for a little input on this situation. I'm working on an inventory system and was thinking that I'd like to build it similiar to... Kenneth Courville	09-16-2004 01:11 PM Kenneth Courville	2	84
ERROR 1141 on mySQL creating a User on NT 4.0 Hi, I just installed mySQL on MS NT 4.0 workstation and applied Service Pack 6a. When trying to add a new user using the Control Center I get... Paul K. McKneely	09-16-2004 10:45 AM Simon Hayes	1	72

Page 195 of 283

195

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