For more information about the site, see the Site Index
- Application freezes for 30 seconds on VPN
- Designing database to include attribute with hundreds of fields
- Date stored procedure was last modified
- Adding column and changing datatype
- Error connecting to Web-based application
- Conversion of char datatype to datetime datatype resulted in an out of range datetime value
- Remote access to SQL Server 2000
- Query works fine in Query Analyzer, but error via ASP
- Moving log segment to separate device
- WHERE clause not being passed over database link
- Errors connecting remotely after adding port
- Need to import 6.5 mdf and ldf files to SQL Server 2000
- Replication error between two standalone servers with same local and sa accounts
- Equivalent of Oracle's ROWNUM
- Command to get physical data layout
- Sysprepping an image with SQL Server 2000 installed
- Resolving a transaction log full error
- Comparing file size on mainframe and distributed systems
- Transferring data from SQL Server 2000 to DB2
- Automatically incrementing a char field
- Problem trying to connect with the sa account
- Error replicating data from Internet server to dial-up SQL server
- SQL Server has stopped responding to queries
- Error trying to drop linked servers
- Error with RESTORE DATABASE in vb.net code
- Fine-grained auditing in SQL Server?
- Problem deleting records on table with trigger to delete other records
- Error about full tempdb log file
- Rebuilt statistics with rebuilt indexes?
- Clustering in SQL Server 2000 explained
- Lost connection to remote servers on WAN
- Service not starting from dedicated domain user account
- Function to return working days in a given month
- Tools to view content of mdf and ldf files
- Problem creating trigger to update reservations table
- Upgrading, setting up backup/test SQL Server
- Linking SQL Server to Web-based system
- Viewing creation date of disk device
- Where are default constraint values stored?
- Changing SQL Server password from control panel
- Replicating the same database in two SQL Servers
- Error with pull subscription connection
- Problems submitting data from the Web
- Error setting up replication across network domains
- Setting up a multiple-instance cluster with two nodes
- Moving replicated database without dropping publication
- Converting varchar columns to text data type
- Trigger to update table with no foreign keys to original
- Checking life page expectancy, compiles/recompiles and buffer sizes
- Storing photographs in SQL Server
- Copying stored procedures from one SQL Server to another
- Different collation settings on new server
- Procedure to create new domain and move old servers to new ones
- Equivalent of Oracle's v$database
- Products to support undo/redo of image and text datatypes
- Adding new column to table that is part of replication
- Hyphens in server names
- Performance very slow after copying tables
- Error in "Not for replication" database
- Problems trying to connect IIS and SQL Server
- Does script continue to work after failover?
- Starting SQL Server job on first business day
- Memory problems with SQLServerAgent
- Combining two SQL statements and showing result as percentage
- Installing SQL Server 7.0 objects into SQL Server 2000
- Automated script to restore database and transaction logs
- Formatting dates, part 2
- Formatting dates, part 1
- Using Audit Trail, part 2
- Getting error when dropping, inserting into or truncating table with QA
- Can the auto close option cause problems?
- Getting failed Windows server back without losing two databases
- Migrating an application from DB2
- Trouble importing a .db file
- Any issues with linking 7.0 and 2000 databases?
- Changing the language option, part 2
- Importing an Oracle text file into SQL Server 2000, part 2
- Selecting columns without specifying column name
- Replicating SQL Server over the Internet, part 2
- Replicating SQL Server over the Internet, part 1
- Log shipping gets out of sync on one database with re-index
- Importing an Oracle text file into SQL Server 2000, part 1
- Changing the language option, part 1
- Finding all objects modified after a particular time
- Why is computer sending packets to port 1434?
- Comparing full text search features of Oracle and SQL Server
- More on MySQL and security
- Determining the utilization of the database
- Transferring tables between SQL Server and Oracle
- Can't log in with 'sa' and 'password'
- Making an input parameter for a stored procedure
- Using T-SQL instead of menus or shortcuts in Query Analyzer
- Increasing row size
- Often used SP wiped out the database
- Tony's SQL Server book for DBAs
- Automatic FTP updates to an Internet database
- Loading different record types from one text file into separate tables
- Transaction log file exploded in size over the weekend
- Storing data in accounting databases
- Developing a SQL parser
- More