SQL Server Database Administration
: One Forum
Ask a Question
Updating a data
Query on database access for SQL 2000
SQl server2000 Agent service not running
How do we know the how many clients have registered sql server 200 at a particular time. and what is their IDs.
How do we set Master database into single user mode
Sql server database Links
executing a file that consists of set of sql commands
using Linked server
Insert Script for image in sql server2000
Create a database throrgh vb6.0 insql server
how to find out what SQL commands were executed last three days?
Moving SQL 2000 database files.
how do i write query to access remort sqlserver(with ip address) using dial up connection?
Set Query Time-Out on SqlServer
How I see content of tables on remote computer...
how can i get the result set from an stored procedure
Mapped drives are not availible
ODBC & SQL SERVER DRIVER
ODBC - call failed
convertion of database into mssql
Creating dublicate table
Row-Level Locking in MSSQL 7 using ADO
sql 7 to sql 2000
Regarding tables listing in ISQL
RECOVER FROM LOGICAL FILE
How to execute a function via a linked server in the sql server 2000
create crosstab in sql server 2000
SQL Server 7.0 to SQL Server 2000
SQL Server 2000 - Concurrency Problem ??
Howto install sql database files on remote path
Auto Generate Using Triggering Statment
Attach ActiveX script to package through VB6.0
DTS - TImestamp
Check ODBC that DataSource Exist or not?
create DTS Package
how is database adminstratio done in sql server
How to pass query to a stored procedure
SQL server - TabLockX
PV In MS Access
Cross Table Query LiKE Transform in Access
importing data from sybase to mssql
DSN Creat at RunTime in VB
Moving tempdb to other drives
Store details in Arabic
Import sybase datas to Excel
print landscape with ISQL report
Duplicate record in a table
how to display all the table name in database
removing old log file
Restoring SQL Server database thru code
add a sybase server as a linked server to sql server 2000
sql server suer_name
How to restore the database that has gone suspect
"Loading/Suspecing" I can not create sql database when I call stored procedure from VB6.
How do I create secondary datafile on a databse
Resotring transaction Log
Relationship between different databases
How to Check whether ado has already began a transaction
Error deleting scheduled DTS packages
How to export a DTS package to remote servers?
Auto Generate Numbers from different desks from sqlserver Dataabse using vb6
Beginner to Replication
number of tables in MS Sql
VB6.0 & SQL Server 2000
Open Position - Sql Server DBA - TX
Restoring with different logical name
Server Server 2000 Study
using NTEXT column in inserted table
SQL image editing
how to merge data from one database in ms-Access to other thru Visual Basic
Dynamic SQL AND Distributed Transaction
How can I give alert message to a remote use connects to My WEB DB Server
Login failed for 'sa' user in SQLserver 7.0 enterprise mngr
finding top n rows from a table-n should be passed as parameter
Lock in Tempdb
Monitor/notification of db growth and free space
Exporting very large table to text
What is major different between SQL2000 and SQL 7.0
Rule of Thumb: How many DBA's?
how to write delete trigger which has text datatype
Performance degraded after Win 2k SP 4 update
Tempdb - Lock Timeouts
detail explanation on this query
Even after truncating temporary tables , still shows same size not get reduced even a MB
Fast Growth in Database file
how to access database from remote sql server through DSN
Inconsistency in SQL Server performance
Is it possible to automate the backup activities without my interaction
About deleting log files
About log files
how to export role from one database to other
Database(not server) goes down when executing particular application
How do I restore one SQL7 database to another, of a same name, on a different server.
SQL Server DBA for Direct Hire position (80K) in Rochester NY
Announcement J6084 – SQL Server Database Administrator DEADLINE 10/23
Import Access Database to SQL Server 2000
I need to reattach my Database (SQL Server 2000)
record locking on sql
Import data into SQLserver7 database.
Kansas City, Sr. SQL Server DBA, Allegent Partners, Inc.
How to convert integer value to time
Help with replication
ODBC timeout after 30 seconss
SQL 2K XML Features
converting sql7 database to sql2000
Performance Issue while updgrading from 6.5 to 2000
Trigger error handling
Deletes in Sql 7 additional infoe
Change not allowed in stored procedure
Anyone know anything about Seagate using tempdb whilst connecting to SQL server....?
SQLserver 70 Deletes
Relication - RAM problem
SQL 7.0 (sp3) Replication using Filter (Horizontal Partition)
SQL/DTS/Job schedule problem...
Protocol error in TDS Stream
Web-based DB dev Contract opportunity
forwarding email to sql server database
Error during replication which is not documented by Microsoft even
Error# -2147217911 Select Permission Denied ..
Index on Tables used in Partiioned View
can i migrate oracle 8.1.6 to sqlserver 2000
Maximum User Connections for a Single User Login
SQL Error message (table corrupt)
How could i change the code page of sql server 7.0 without loosing my databases and datas ?????
SQL 6.5 datatype "text"?
No.of occurences of a character in a string
full text indexing set up
Software Devel/DBA for Pittsburgh, PA: T-SQL, SQL Server 7
Autogrow option for production databases
How to take all tables in .Txt format through coding
Insert/Update to Text datatype fields
BCP fails when run from a client system in SQL 7.0
isapi applications not working on shared sql server7.0 ??
how to use variable in place of tablename
SQL Server DBA needed in Wilmington, DE
Encrypting the data to be stored in tables.
Auto increment avarchar
Creating New Databases or Instances of SQL Server
Problems starting SQL Server 6.5
creating a query
Can I install vb & sql ser 7 in one computer for learning ?
Tempdb Transaction log keeps filling up
Raleigh, NC contract position for SQL Server DBA/Designer thru ABC Technology Staffing
Merge Replication Problem
SQL DBA skills?
Re : Data File corruption
Access to SQL Server
need help understanding row-level locking
SQL Server DBA needed in NYC for Janou Pakter, Inc.
DSN Creation for SQL 6.5
SQL server manager error
SQL Server Connections
Estimating row count
Data Distribution & Estimated row count
SQL Server - Distribution of Data - 2
SQL Server : Data Distribution
DTS Package Timeout
Problem connecting sql servers
FULL TEXT INDEX PROBLEM!!!
Overwirte backup data
How to set up backup for SQL Server residing on a cluster server?
Upgrading to SQL 200 from version 7.0
Reg SQL profiler
Need SQL DBA in St. Petersberg, Florida immediately!
Looking for a SQL Server DBA South of Seattle...contact Justin @ LightningRod.net for more information!
Create database on WIN2K cluster
NEW DBA scripts and tools!
SQL SERVER Configuration Error
Creating Datebases and Tables using SQL2000 XML support
network error during the initialization of the provider in DTS
SQL Server DBA needed in Kansas City
SQL Server scalabilty
SQLServer 6.5 - How do I rename a database
Sql Server locking up with newly installed firewall
Backup of a table
Eudora and Sql mail
Backup job can't connect to local SQLServ 6.5
help!! database suspect
MS SQL DBA Wanted in NYC - $90k+
Endicott, NY/DBA/Atlas Commerce
SQL Server documentation Templates
I'm a new SQL DBA
Store procedure problems....
SQL Server 7 to 2000 conversion
SQL Server 7
can't querry the linked server help pls
Post to different Rows in DB
Bloated SQL 7.0 Database
How to add go to next step in sql job via code.
Loading very long text data with DTS package.
Are You a True SQL Server DBA?/Alliance Technology
How to automate MS OLAP cube processing?
To Display numbers other than existing ones in a range
SQL Server 2000 B2 upgrade to SQL Server 2000 release
Combining Tables to have unique column names
MS SQL Server DBA 12 Month assignment in NYC
SQL Server DBA needed in Nashville, TN with Willis North America - Direct Hire
Scripting all database objects?
Cannot restore master database - SQL 6.5
Avon Products needs a SQL Server DBA in Rye, NY
Supliment to my previuos Question
Finding Duplicate Records from Table
Need to DOWNGRADE to SQL Server 6.5
Remote Installation Failed
Beginning SQL Server Databases
Bug in DTS
Starting Sqlserver on Single user mode
Backup & Recovery
SQL 7.0 Database Resizing
help needed for learing transact-SQL.
SQL SErver DBA wanted in San Francisco, 90 - 115K, options
[JOB] SQL Server DBA-Pasadena, CA-Ticketmaster Online-no recruiting agency-direct hire
SQL Server DBA , Dallas, Texas 85-90k plus stock
Converting a Case Sensitive database into Case Insensitive (HELP)
Where can i get the free material for sqlserverDBA?
Is Oracle better than Sql Server in terms of Trigger functionality?
stored procedure calling another stored procedur
FTP data transfer
Los Angeles, CA / SQL Server DBA / ProStaff IT Open Position
SQL trans in VBscript or stored procedure
Third Party Tools for Replication
Can I practice on SQL Server anywhere for Free?
Scheduled Jobs not Running All Tasks in Package
Database Maintainance Plan in Multiserver Environment
Microsoft SQL Server 6.5?
Sr. SQL DBA Opportunity--UP to $90,000 plus full benefits and 401k
How do i do a ACCESS97 field Memo in SQL7.0
Check Constraint Fails during update
WOLF EDG: MS SQL DBA wanted.
On-the fly creation of dbf files from result sets?
SQL 7 Assertion Failed!
input paramater in a stored procedure
Can I have an input paramater in a stored procedure be a table name?
ANSI Nulls Off/On
SQL 6.5 Database Dump Inquiry
"AND", "OR"and "Union" in a single SELECT statement using ASP
Populating Full Text Catalogs
FTP from Tandem to SQL Server
Foreign keys Please help
Getting an error while trying to link to a server
How to connect to remote SQL server through IP address
Sr. Database Developer - SF Start Up - Music Industry
SQL DBA - San Francisco start up - Music Industry
Generating 'Create' scripts for DTS packages
Restore from device to Win 98 Desktop Server
Maxim Group is looking for a SQL Server expert
Looking for a junior SQL DBA position
Query time out
SQL7 Upgrade Error
Case senstivity in data
SQL Server 7.0 vs 2000
Where can I find a Senior SQL Server DBA for San Francisco?
Do sheduled tasks get upgraded?
SQL Server DBA needed in Los Angeles area; great environment;!
SQL 6.5 Mirroring
SQL Server DBA needed in MT. View CA. Company; MyWay.com, Pre-IPO
How do I do a "AND & OR" SQL QUERY AT THE SAME TIME?
Uninstall program does not delete SQL 6.5 dir. URGENT.
@sysstat & 7 ?
Information about SQLSERVER
Stored Procedures , permissions
asp and SQL syntax: variables
SQL not running
Data access between 2 sql 6.5 servers
Job Scripting Automation
Enterprise Vs Standard Edition...
Base table updates from the front-end
Transaction logs as big as backup
Internet Data Warehousing
passing quoted parameters to sproc
E-mail List from SQL Query
software to import/load data from unisys mainframe
Deleting field/columns from an existing SQL table
SP failed during upgradation...
differential backups vs log backups
SQL where to begin with
NewAlloc Vs ChecAlloc
Upgradation failed while importing replication settings...
setting up master and enlisting servers thru EM
Linking SQL 7 servers
Save backup config
READY FOR A MOVE? AiC needs DBA in Nebraska. SIGN ON BONUS available!
Writing a large amount of NTEXT data using ADO
SQL Server Needed in Tampa,FL. Consulting company: TransWorld Computer Technologies Group
homestore.com needs a Sr. SQL Server DBA in Thousand Oaks, CA now!!!
Threads vs. fibers in MS SQL 7.
Last update of objects
Installing SQL Licenses on NFR NT
eCommerce web site SQL Server DBA job in Needham, MA - SmarterKids.com
Error Handling in Stored Procedures
New York City Needs Olap expert sql server 7 dba Consultant
Where do I go to find qualified SQL DBA's-I have some great oppty's?
MS Terminal Server ODBC error
Procedure call through ODBC
What is an error 20527?
Changing NT Machine Name (SQL Server 7.0)
Access query to SQL Server stored procedure
Can I auto-disconnect users
Estimating Table Space...
Irving, Texas / SQL Server DBA (7.0)/ elitetek.com
editing Transact-SQL in a DTS Package
Timestamp error while Restoring Transaction Logs
Configuration of mail - error 22022: sqlserveragent error: the mapi call failed
SQL Server Logs Problems
Moving Database to another location
Error Severity l9 occured...
Error: Severity 19 occured...
Why don't I get to choose the database and table to link to?
Database Engineer for a startup is needed
Web Page for Perf Tuning
Optimization Guidelines for OR operator
SQL Server DBA position in Costa Mesa, CA (Dallas, TX too)
Redesigning the structure...
Transactions in SQLServer ... URGENT Inquiry
What roles are required to import data using bcp utility
How to setup sql server 6.5 to access a remote server?
How to connect Sql server 6.5 to Oracle?
SQL Server DBA Opportunities
SQL Server DBA Position in North Florida with Vereon Technology, Inc.
Need SQL Server Developers & SQL Server DBAs in Seattle
SQL Server DBA needed in Dallas, TX
Upsizing Access97 to SQL7
database and web
Locking in Tempdb
SQL Server DBA opportunity, Michigan
We Need E-Commerce Stars!-US-Seattle
E-Commerce Today! Seattle WA
pstmt.setDate(index.sqlDate) message ?
Connect by the web to database
Access a DB through the web
Looking for a SQL Server developer w/ Data Warehousing Experience in So. Cal.
Senior SQL Server Database Developer wanted, Mountain View CA Startup, ODSC is the sole recruiter
Access/SQL Programmer for Ins. Co. in FL
SQL Server DBA for Ins. Co. in FL
What causes SQLCTR60 error message?
How do I set up ODBC for replication from SQL Server to Oracle?
How to convert access database to SQL (Urgent)
SQL 7 Backup and Restore Problem
SQL Server DBA needed in Portland, OR
Network Appliance Help.
finding segement space availability....
Porting of selected and summarized
Jobs Failing in SQL 7
Finding a table in MSSQL like view V$session in Oracle
Job Opportunity at iShip.com/DBA & Database Engineers
Database space discrepancies...
Linked Server - Informix Server
services not started
DBCC Allocation Descrepency
How do I re-name SQL Server 7 Computer name
space availability in database...
space available in database...
Using Linked Server feature in 7.0
table name as parameter to stored procedure
Notify me when a particular database is 80% full
SQL Server DBA position in San Diego, CA
DTS package error message
error 21271 in MS SQL Entreprise Manager
SQL7.0 server installation
Management of logins
Error 14151(Replication directory) and ODBC (URGENT, please)..
Scheduling dts package using ServerAgent problem
Error 126 (URGENT)
Problem attaching a database.
Installing SQL Server on NT Workstation
Login failed (Urgent)
Remote server and replication probleme
Remote server and login
about error 14222 and replication
17824 Error answer from Mr. Eric.
Using ODBC Data Source in SQL 6.5
Writing efficient queries
Configuration of SQL Mail and alert notification
Configuration of Replication
Beginning SQL Server 6.5 training
Database getting full
Using a parameter prompt in a SQL Script
Replication read only setup
What does the message mean LAZYWRITER?
Users and Password's transfer.
Problems with DTS in SQL Server 7.0
retrieve data then send
Connecting to SQL Server
SA Password mis-placed.
Hyperlink in a database
SQL in Buttons Part 2
sql queries i buttons
Do Functions alter the effectivness of Indexes?
Advanced queries & merging temptables ???
Backup & Restore.
Are numeric indexes more effecient?
Case-sensitive / Case-Insensitive
Checking Data Migration...
querying remote server
Message 17652 - Can't find any documentation
Retrieving Autonumber on INSERT
Report Generator for sql stuff
SQL 7.0 full recovery
VB 4 and Stored Procedures
Can not schedule backup on SQL user database or view tables
Transfer Of Data From Oracle
Regarding Indexes And the Recompile option
Trying to compare SQL DB and Access DB
dumping and backing up Transaction logs in 6.5
Device Drivers for SQL 6.5
Screwed up order of data in SQL 6.5
Triggers in BCP
Importing Data from an Access97 table into a SQL 6.5 table
What is MS SQL 6.5 Runtime?
Restoring From Table in SQL 6.5
error while querying a database on sql server
Error message 10005
Informix SQL ODBC SQL Server 6.5 or greater
SQL Distinct # 3
SQL Distinct syntax question
Restoring replicated databases from online backups.
Moving devices for SQL Server 6.5
MS Access cross tab queries in SQL Server
Can Anyone Identify the cause of these errors?
Is Mesg 17309 a general system fault
SQL Access Problem
SQL Server training
Creating tables and indexes with other tools
SQL Database Administrators with TS/SCI
Automatically deleting rows after 40 days
Access to SQL Server 6.5 from Non-Standard-Domains with mixed security
slow connectivity betn. VB6.0 and Sql Server.
SQL-DMO Runtime requirements
Name the Top Ten Tasks of SQLSERVER DBA
Triggers, referencing Deleted and Inserted tables
SQL Server 7.0 Upgrade Failure
Power designer rgd...
VB5 to move data from ASCII format to SQL 6.5
How to avoid identity value errors
Counting records in a database after bcp
Sizing projections for a database?
Are you familiar with VB as a front end...
Asynchronous VS Synchronous Transactions
Disabling of Scheduled Tasks
Select....Into statement failing from remote client.
Cursor only returning one row
reordering of rows on updates
How to Query NT network to find user id
sysdepends gets out of whack
SQL stored procedures
Follow up on your reply to moving SQL 6.0
Where can I find
17903 Mapi Logon Failure
Character sets and sort orders.
Allocating Temp DB and the SQL Srvr Config.....
query off hotkey
SQL 6.5 Licensing for Internet connectivity
Creating Stored Procedure...
6.5 SP5 Problems?
3146 runtime error. ODBC call failed
Moving SQL 6.0 to a new better server
Creating Database on SQL server in VB6
NTFS Allocation Unit Size
Help Tuning SQL Server
16 tables limit
Transaction Logs Explosion
server parameter /t342
Optimising Sql Server (Is it Possible ???)
Full-text searching with Microsoft SQL 7.0
SQL Performance - importing
Access SQL vs SQLServer 7 SQL
Internet connection to SQL Server using ASP/ADO
General SQL server error
Locating MS SQL Server Database on Network Drive
Memory Allocated to SQL server
Changing SQL Server Name
Dr Soloman / SQL Server
SQL Server and DEC Alpha Server
device offline error
Help with BCP in datetime values in nondefault format.
Control and maintain database objects..
Any restrictions on bcp in MS SQL 6.5?
MS Access Database & SQL Server Database
Query on joined tables (more than 2 tables)
Query on text field (memo field)
Help with importing data and structure, Informix to SQL Server 6.5
Finding the one item that makes SQL superior to Access '97
SGL Install failing on WIN98 O/S
SQL Server and Workstation NT on the same machine
SQL Server Error #17824
SQl Server Daily Mainenance Error
Register a server
Help with importing data
System table locks
VB5 create temporary stored procedure
Visual Basic 5.0 SQL
SQL Server Database Recovery
Monitor the SQL Server
Connecting to SQL Server 6.5 using DAO
Overallocation of Memory - SQL SERVER LOCKED UP
adding a record via web interface
Need Website Design Tool with SQL Server DB Interface
NETBIOS Connection Problem
Installation Problems ...
Edit table's structure
SQL Mail Service and Export data to Sybase
Connecting to a different server
support for double byte strings
SQLServer Registry Documentation
Data Dictionary queries and reports; tinyint decode
This forum was set up and moderated by Eric Kohnen, probably back in the 1990s. It is currently a read-only archive. None of the content on this server has been reviewed by the webmaster.
Moderation questions? read