SQL Server Database Administration

• 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?
• Databse Backup
• 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
• Concurrency issue
• Table file
• ODBC & SQL SERVER DRIVER
• ODBC - call failed
• convertion of database into mssql
• sql error
• 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
• Sql Server
• system account
• 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
• Performance issue
• 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
• tempdb related
• 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
• DTS examples
• How to export a DTS package to remote servers?
• Auto Generate Numbers from different desks from sqlserver Dataabse using vb6
• Beginner to Replication
• Table Space
• number of tables in MS Sql
• VB6.0 & SQL Server 2000
• restore database
• Open Position - Sql Server DBA - TX
• Restoring with different logical name
• ddl
• Server Server 2000 Study
• using NTEXT column in inserted table
• Replication
• 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
• Error 18452
• finding top n rows from a table-n should be passed as parameter
• Lock in Tempdb
• counting record
• Monitor/notification of db growth and free space
• Exporting very large table to text
• DBA job
• 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
• Hardware requirements
• 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)
• DDL Extraction
• record locking on sql
• SQL SERVER
• Remote Query
• Import data into SQLserver7 database.
• Replication
• Kansas City, Sr. SQL Server DBA, Allegent Partners, Inc.
• How to convert integer value to time
• Help with replication
• Dbinfo
• ODBC timeout after 30 seconss
• SQL 2K XML Features
• Differential backups
• 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
• SQL Server2000
• Relication - RAM problem
• SQL 7.0 (sp3) Replication using Filter (Horizontal Partition)
• SQL/DTS/Job schedule problem...
• DBCC
• Syscomments table
• Protocol error in TDS Stream
• Server property
• 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
• SQL Registration
• 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
• Database Design
• Autogrow option for production databases
• How to take all tables in .Txt format through coding
• Insert/Update to Text datatype fields
• Performence Tuning
• 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.
• Set ANSI_PADDING
• Auto increment avarchar
• Creating New Databases or Instances of SQL Server
• Problems starting SQL Server 6.5
• creating a query
• log shipping
• 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
• DB Reload
• SQL Server DBA needed in NYC for Janou Pakter, Inc.
• query needed
• DSN Creation for SQL 6.5
• Move devices
• DTS
• 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
• Transact- SQL
• Sql Server locking up with newly installed firewall
• format change
• 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
• linked server
• 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
• Earthquake
• 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
• Database Compare
• 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
• OLAP Security
• 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
• remote backups
• Default
• 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?
• load status
• CoInitialize message
• 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
• Userid/Password Syncronization
• 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?
• Non-Whitespace Characters
• ANSI Nulls Off/On
• Database link
• 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
• Identity Seed
• 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
• error 18456
• Query Timeout
• 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?
• Upgrade wizard...
• 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
• Performance problem
• 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
• Error 605
• Transaction logs as big as backup
• Internet Data Warehousing
• passing quoted parameters to sproc
• E-mail List from SQL Query
• SP upgradation?
• 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
• Sub-Totals
• cascading deletes
• Upgradation failed while importing replication settings...
• ODBC-call failed
• Registry settings
• setting up master and enlisting servers thru EM
• Sending Mail
• kill statement
• Linking SQL 7 servers
• Group By?
• Save backup config
• Maintenace
• READY FOR A MOVE? AiC needs DBA in Nebraska. SIGN ON BONUS available!
• Writing a large amount of NTEXT data using ADO
• SQLMail
• 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
• RAND Function
• 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?
• DBCC LOG
• MS Terminal Server ODBC error
• Procedure call through ODBC
• Stored procedures
• What is an error 20527?
• Changing NT Machine Name (SQL Server 7.0)
• RowID
• Access query to SQL Server stored procedure
• Error 18452
• 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
• DeadLocks
• 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
• Clustered Indexes
• SQL Server DBA position in Costa Mesa, CA (Dallas, TX too)
• Redesigning the structure...
• Stored Procedures
• 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.
• Package
• Need SQL Server Developers & SQL Server DBAs in Seattle
• SQL Server DBA needed in Dallas, TX
• FieldSize property's
• Upsizing Access97 to SQL7
• Cursors
• database and web
• Locking in Tempdb
• SQL Server DBA opportunity, Michigan
• We Need E-Commerce Stars!-US-Seattle
• E-Commerce Today! Seattle WA
• About Oracle
• pstmt.setDate(index.sqlDate) message ?
• DBCC output
• Connect by the web to database
• Restore Error
• 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)
• Stored procedures
• SQL 7 Backup and Restore Problem
• Jobs scheduling
• 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...
• REvoke access
• Linked Server - Informix Server
• services not started
• DBCC Allocation Descrepency
• How do I re-name SQL Server 7 Computer name
• server roles
• 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
• Update statement
• SQL Server DBA position in San Diego, CA
• DTS package error message
• error 21271 in MS SQL Entreprise Manager
• SQL7.0 server installation
• TABLOCKX command
• Management of logins
• Replication(allocate distribution)
• Error 14151(Replication directory) and ODBC (URGENT, please)..
• Scheduling dts package using ServerAgent problem
• Server registration
• Error 14096
• Error 126 (URGENT)
• Error 229
• 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.
• Unistall replication
• Error 14222
• sp_droppublisher
• Replication Probleme
• sp_addserver
• 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
• Replication error.
• 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.
• Carriage returns
• Hyperlink in a database
• SQL in Buttons Part 2
• sql queries i buttons
• Do Functions alter the effectivness of Indexes?
• Advanced queries & merging temptables ???
• Transferring Databases/Paths
• Y2k
• Backup & Restore.
• Memory configuration.
• Are numeric indexes more effecient?
• Case-sensitive / Case-Insensitive
• Checking Data Migration...
• temp_db issues
• Regarding triggers
• Numbering rows
• querying remote server
• Message 17652 - Can't find any documentation
• Retrieving Autonumber on INSERT
• Report Generator for sql stuff
• SQL 7.0 full recovery
• DBA4s responsibilities
• VB 4 and Stored Procedures
• Regarding Triggers
• Hashing problem...
• 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
• Recommended Hardware
• 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
• Current Activity.
• SQL Question
• 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
• timestamp issue
• SQL Server 7.0 Upgrade Failure
• Power designer rgd...
• VB5 to move data from ASCII format to SQL 6.5
• OLAP Services
• 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
• Forward engineering...
• reordering of rows on updates
• How to Query NT network to find user id
• sysdepends gets out of whack
• SQL stored procedures
• Replication rgd...
• Follow up on your reply to moving SQL 6.0
• Where can I find
• 17903 Mapi Logon Failure
• DBA's responsibilities
• SQL Mail
• 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
• Installation.... Help!!!
• server parameter /t342
• SQLMail Configuration
• 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
• Answers please..
• 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
• error 21770
• 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 ...
• Connection problems...
• Faster BCP?
• Suspect flags
• Edit table's structure
• SQL Mail Service and Export data to Sybase
• Connecting to a different server
• SQL Command
• support for double byte strings
• object/relational database
• SQLServer Registry Documentation
• Importing data
• Help!Please!
• Data Dictionary queries and reports; tinyint decode