View Full Version : Microsoft SQL Server
- ODBC from Solaris 7 Sparc to MS SQL 2000
- use age field to calculate an age category (was "Please Help")
- MSDE question
- Encryption Between SQL Server and Client
- Separating one Contact Field into First / Last Name
- EM Registration Question
- SQLIO results
- database maintenance plan emails
- Replication over VPN when IP address of VPN connection was changed
- How to Backup To External Tape Drive ?
- Install MSDE
- how to split ?
- Two cursors in T-SQL
- Problem in trigger
- Good interview questions for OLTP / OLAP
- Recover the SQL Data
- VBscript - odbc - Login fail for user '(null)'
- Prompt before Executing a DTS?
- Hierarchy search...
- Migration of Logins Sqlserver 7
- error in oracle sqlserver connectivity
- DTS Package Global Variables Uses Old Values?
- Export a query to a text file
- sqlservr -c -m pls help
- rtf to text conversion
- import from excel error
- returning tables with UDF
- Help creating tables
- Why are select * views bad form?
- Centralizing my procedures
- SQL Server 2000 Developer Edition and Cognos Contributor/Enterprise Planning
- Retrieving selective records from a table.
- Looking for DB-design examples for customer/order case
- Restoring Log
- test 70-228 comments (was "Ooops! very tough.")
- Need suggestion for importing
- get proc name
- Need help on MS SQL 2000 Cal
- Migrating indexes from DB2 -> Sql Server
- SQLServer and OLEDB
- indexed columns
- QA & EM ports
- ACCRInt in SQL
- Interesting Index Behavior
- Lucy, s'plain me somethin' 'bout money-to-varchar conversion...
- Bulk Insert using format file is blowing chunks
- server access
- Index defrag on all tables
- XML Loading/Processing Question
- How to check the existence of object in db
- Where are the SQL Server system sp sitting
- a tree structure with checkboxes (was "Query Needed Urgent")
- Unique index violation using Merge Replication
- sp_OACreate
- Port Number Script?
- SP Recomilation - Compile time options
- DTS Package security problem
- Dbcc Page
- copying sql jobs
- Capturing @@ERROR and master..sysmessages problems
- Database Design Problem
- Noob Q - MS Search is part of ??
- upsizing or moving data with constraints??
- ODBC problem on IBM Machines
- Why the table is locked ?
- Data / index diskspace ratio
- error 20026
- Looping back in a cursor when errors occur???
- Reuse alias in MS SQL select
- Manually Compacting MS SQL Tables
- Modify DTS Package
- convert time format to show regular time (was "Query")
- DTS Column Mappings and Transformation
- data history
- Counting rows based on a condition?
- Automatically reinitialize replication
- SQL Server Access to FoxPro Data Question
- Extract SQL Server Security by database
- @@ERROR not trapping errors
- importing data
- setting the default date to NULL
- Need some help with DTS script
- Using multiple stored procedures in one report (SQL Server Reporting Services)
- MSSQL accessing other database (Informix)
- Question about importing different sheets from excell to SQL using DTS
- Auditing DTS Package - Impacted tables
- Alerts and dead lock...
- automatically import from XLS to MsSQL
- DTS Package Job Fails ...
- Is there a way to tell if an index is being used by the database?
- Uninstall SP4
- match successive rows within the same second (was "Query help")
- Partition By Range
- Grouping by 15 minutes
- Missing SQL Server after Visual Studio Install
- Display Name or ID
- Error near end of SQL 2000 setup
- MS Access Data Access Page can see all the tables (was "Lost and Confused")
- Too slow update (SQL Server 2000)
- find difference between rows
- How to store only date without time
- how to select data by month
- MSDE on peer-to-peer network (workgroup rather than domain)
- Finding the frequency between values
- Suppress SQL Server information messages
- Automate MS Access upsize to MS SQL Server
- Problem saving Euro symbol, stored as "?"
- Sales from Between Certain Dates on One Row
- Cannot Associate Fields with Different Databases
- restoring my .bak file
- Problem in upgrading SQL Server 2000 Personal Edition to Standard Edition
- Username password problem in SQL server
- Should you ever need to change the domain of your server cluster, perform the followi
- General Network Load Balancing Best Practices
- SQL server logs size
- Problem migrating trigger from db2 -> sqls
- CASE expression
- SQL Server basic security
- Problem Lauching Query Analyzer from Enterprise Manager
- keyboard Shortcuts???
- Indexes
- Date Format
- DTS Transactions Problem
- Merge replication - Filter rows by join
- design issue...
- DBCC CHECKIDENT syntax error :/
- Maint Plan Issues
- Stored Procedure (V.V.Urgent)
- Copying selected tables to a db based on given date range
- Linked server query problems
- Working With MSDE 2000 ISSUES!
- please don't keep posting duplicate threads (was "Stored Procedure (Urgent)")
- Server Roles and Scheduled Jobs?
- copy data from tables to another database
- Rank-Order by counter Dilemma
- Strange Problem with datediff()
- need help!!! how to fix pie slices in SQL Reporting Services??
- What is suspect Database ?
- Backup SQL 2000 by sql statement
- Cannot create an instance of DTS Package (was "SQL server problem plzzz")
- T-SQL question
- select into ... question/problem
- changing data type
- SQL Server full backup/recovery model
- SQL Server -- how do I retrieve mail?
- transfer tables from Access to MSSQL (was "beginner please help")
- Security. Strange, is it a BUG!
- BCP and Truncation Error
- Index Tuning Wizard
- SQL Server Standards
- Could not open FCB for Invalid file ID 3
- Moving System DB mdf and ldf files
- View sql server 7 License
- need simple SQL Security User script /w db_ddladmin
- Minutes between two dates
- How do I force a replication.
- Grouping records every 15 minutes....need help
- Trigger Failure ?
- Which will perform better? MySql or MSSQL??
- Trouble in server agent job
- Transaction Log Backup
- To Bind or Not To Bind
- Comparing numeric to char question...
- User defined function - parameter question
- Need help with dynamic SQL query in my Stores Proceure
- Complete Automotive Database - Year, Make, Model
- Update with reference table
- question about fillfactor
- Login failed for user '(null)'. Not associated with a trusted SQL Server connection
- Problem with UNION - order by items must...
- php upload problem
- INSERT into Oracle prob using 'MSDAORA'
- Sql 2k5
- executing tsql script?
- Ok, somebody explain THIS behavior...
- SqlConnection fails on Open()
- Relations
- Counting and Dividing
- Moving SQL Replication
- Convert from Lower to Upper Case for Nvarchar Data
- SQLServer does not accept connections as local for ASP.NET applications
- Transaction Log Shipping New SPs
- How to Recover DB from a .TRN file
- Indexed Views viabilities
- displaying the inactive/active count (was "Help in Query Building")
- Help on listing query...
- Call a DTS local package from a SPROC
- Dbcc Showcontig
- Replication/Triggers
- DBC sqldriverconnect failed
- Discarding Seconds from datetime dispay
- Need help with full-text install
- hour :minute calculation from datediff
- Split Full Name in SQL Server
- Microsoft SQL Server 7.0
- PK multiple in another table
- AVG runduation calculation.
- Let me try this again, hour:minute calculation
- special_permissions, user_permissions, module_id... (was "complex query...")
- Changing physical model
- sp_preparedocument error
- Copy database from Computer to Another
- Optimizing multiple calls to same function in Update statement
- Can't access data with ADO in database with application roles
- 2X Updates
- Permissions setting
- strange query error, help
- View
- Syntax error converting the varchar value 'Man' to a column of data type int.
- diff between Truncate and delete
- Stored Procedures
- How many .Net developers per SQL developer?
- 845 error
- Table description including actual string length
- Compare Database
- replication in MS SQL server
- life of a Data Warehouse guy
- Really weird SQL Server errors
- Unattended Import
- Complex SQL Query
- New Server - Missing Jobs, DTS, MainPlans
- Query Analyzer vs ASP.NET Performance
- ReSorting a Database's Primary key
- Error 515? has anyone seen this error before ?
- MSSQLSERVER sysxlogins and sysusers
- error in starting MSSQLSERVER.server could not be started
- logins and user relation script
- Rounding non divisible numbers
- Migrating a SQL 2000 W2K server from NT4 to Active Directory
- Select all names that start with "m"
- Change database in Stored Procedure
- Replication of TEXT
- Backup Failure
- Moving SQL Server Security
- Locks not releasing
- The dependency or group failed to start
- Stirring the pot...heh,heh,heh...
- SQL Server 2005 and Current Testing Platform
- Row Delimiter Problem
- Dbcc Shrinkdatabase
- database backup failures
- SMTPsend
- SQL 2000 locking issue
- how to use dynamic where in cursor
- Consistency Error - SQL Server 2000
- SQL Server Query for non existing records
- Max. I/O transfer rate
- Creating triggers in a procedure
- change collate
- Jobs in SQL Server
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.