career

ADO.NET or ADO?

• by Barkingdog

• Redgate

• Topic

ADO.NET looks like a reasonable solution for database access from the Internet. But what about when the client and database server are on the same LAN? Is ADO.NET overkill? Should I use ADO instead to connect? TIA, Bill

2002-01-30

1 reads

Master database import in SQL Server 6.5

• by mattfuz

• SQLServerCentral.com

• Topic

Hello On a SQL Server 6.5, I export the master database and try to import it to another SQL Server 6.5. OK for the export (200Mo dumped to a 15 Mo file). I run SQL Server 6.5 in single user mode (sqlservr -c -m), select master database in Enterprise manager, select restore/from file, select the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-01-30

9 reads

Updating part of field value

• by msregalla

• Redgate

• Topic

Hi friends, I am performing a search and replace on columns having different data types (note not only "Text" or "Image" data) through my VB application using ADO in SQL SERVER 6.5. Oracle provides a "Replace" function for that which can be used in a an update statement for searching for a perticular work within […]

2002-01-30

70-028

• by vishalr

• Redgate

• Topic

Iam preparing for 70-028. I have confustion for the following question.Can any one explain what is correct answer. You are a member of fixed server role serveradmin. You create a job, which backs up the database and then copies the backup file on a network drive. When you do the individual steps, they run okay. […]

2002-01-28

5 reads

What do you like best about databases?

• by Robert Marda

• Redgate

• Topic

I am wondering what part of working with databases everyone enjoys the most. For me, I must say I love creating, designing, and modifying DTS packages. I have seen some of the new things offered with SQL Server 2000 DTS and look forward to using it, but for now I must use SQL Server 7.0. […]

2002-01-23

4 reads

ISQL script for Creating user, database and tables

• by msregalla

• Redgate

• Topic

Dear All, I am writing a script for SQL6.5 for auto generating a database and a user for that database and few tables within the database. This is for packaging and distribution purposes of my application related database to the clients. I am struck at changing the user from 'sa' to the newly created user […]

2002-01-21

123 reads

start synchronization through sql dmo

• by zuhx

• Redgate

• Topic

I am trying to start synchronization for reeplication through sql dmo, but I have no idea on how to do this. Can any one give me some insight on how to do this. If you can provide some sample code that will be very helpful.

2002-01-21

2 reads

Convert Second to Time format

• by aziz

• SQLServerCentral.com

• Topic

Can anybody help me to convert 91423 second to hh:mm:ss within Sql select statment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-01-21

1 reads

HELP With Replication (Agent Retrying)

• by Pechmen

• MSDN Communities

• Topic

Hello. Sometimes, merge agent at Replication Monitor show status "Retrying" even after agent is stopped at subscriber. Next try to start agent will cause "The merge process could not initialize the Publisher. Another merge agent for the subscription(s) is running". I can even disconnect subscriber and that status will not change. Does anybody know, where […]

2002-01-20

3 reads

Slow Master DB

• by bigdave

• Redgate

• Topic

I have just taken over a client that is having a severe performance issue re their master database. eg. it takes forever to drop down the database list in Enterprise Manager (15 minutes!). They have a under-spec server (dual PIII, 2GB RAM, but only mirrored boot drive and mirred data drive - both UW SCSI […]

2002-01-16

4 reads