View Full Version : Microsoft SQL Server
- Recent dates only
- MDX To retrive value of dimension for calculated member?
- sql server backup/restore
- Sql Server 2005 Backup & Restore
- Insert SP
- Install SQL 2000 client on SQL 2005 server
- Linked Server Problem AS 400 with SQl Server 2005
- Extent Scan Fragmentation Increases After DBReindex - Why?
- access and dynamic sql
- WHEN? IF? statement
- DBF file that changes daily
- Ordeering data separated by commas
- SELECT only changes
- .mdf and .LDF file names
- Can't get started
- Search Procedure
- Capturing ID when executing an INSERT
- Urgent Help required--Error: 9003,Severity:20,State:1.
- PLEASE HELP!!! multiple error messages
- connect to sql server 2005 from my laptop
- Direct SQL vs Stored Procedures
- Removing Duplicates to create a primary Key
- Timing a SQL function
- Error whilst adding foreign key
- very NEW to this database server stuff... probably simple for you, but hard for me...
- Becoming a DBA over-time (or not)
- Access is.....
- SQL Server 2005 64 bit version
- Studio Solution: password on every query
- dtsPumptask/transformation looping
- SQL Server Reporting Services/Hyperlink question
- Need Help with MDX Query
- Runtime Error -2147467259
- Performance problems with SQL2K SP4 on Win2K3 SP2
- Data file will not shrink
- Commands
- MS SQL Server problem....
- SQL Server Profiler Permissions
- SQL MSDE installation problem
- profiler to capture sql for 1 table
- Inserting a tabular data
- Query in stored procedure runs too fast
- Problem after Active directory reinstallation
- Bulk insert alternative?
- About copying table..
- MS SQL Server Management Studio Express (2005) Express Edition
- Can profiler run forever?
- SQL Server Profiler with a VPN Connection
- SQL Server Express Scenario
- Does this stored procedure look ok?
- Interesting error
- Restore database by Read-only
- Recovering a SQl 2000/2005
- date help
- number sequence
- Reporting Services 2005 - Parameters
- Changing SQL Collation on Database
- moving all Databases
- Import TXT file cannot work on SQL server 2005
- datetime help
- Maintain Leading Zeros when exporting to .csv using SQL Server 2000 DTS
- openrowset
- Transform XML from a SELECT...FOR XML
- DTS Package hangs while editing
- Copy Database Wizard
- Renewal Dates
- how to check Service pack on Client tool
- SQL Server - Optimize Database
- Replicate every 15 minutes: insane?
- Permission
- 3 level self join
- Management Studio crashes
- What will happen if I change startup Service Account?
- Using Data as Column Aliases
- Query Needed
- How to get the drive letter and the backup directory
- Stored Procedures -- correct practice?
- User Defined Types
- Trigger or Stored Procedure Question
- Need Help with DateTime Query
- creating a query showing file not existing
- Odd problem with "Autoincrement" fields
- Schema change\multiple publishers into single subscription table
- Selecting a sub set of results
- How to import dts package from file xxx.dts
- Remote Access to Individual Databases
- Export table to txt file from DTS with different column names
- Understanding licensing for 2000
- installing sql client tools
- Transact SQL puzzle
- Any way to build a bridge to DB2 mainframe?
- Image/Text filegroup
- Read only access to all databases on a Server
- ERROR EXECUTING ssis PACKAGES
- Replication : ANSI settings
- Must declare the scalar variable Error
- distinct not showing. Kinda URGENT!
- error : nvarchar into smalldatetime
- How to ensure date are handle as it should
- Copy SQL Server Objects - strange behavior
- UNQIUE constraint on string column?
- MCTS: SQL Server 2005, 70-431
- Backup Log is terminating abnormally because memory.
- Return a result set from a SELECT query in a function?
- Database Migration
- Help MS SQL 2000 Server Error
- Protect data from DBA
- Database Recovery
- Database Comparison
- How to search SQL for table updates
- Replace Text in Text, Char & Varchar fields all at once?
- Hyperlink In report services
- Application Hosting
- Windows 2003 Server
- FETCH index details of a Table
- MSSQL Replication Help
- Datacenter Migration - SQL
- Surrogate key as parameter in stored procedure?
- Analysis Services
- SQL Server from.....excel
- Calculating total events (query)
- Week Number
- SQL query to extract DB2data
- Need help with a Query
- stored procedure parameter filtering
- Log Shipping and Analysis Services
- Database design-room availability
- An internal consistency error occurred
- Sql Usa
- SQL query over 2 sql servers
- ADP Nightmare
- Let Sleeping SPIDS lie
- Database table design for huge number of columns
- Cognos Controller 8.2 prob
- ODBC with 2005
- SQL Server Management Studio Express
- Large Number of Tables and Performance
- Applying a Hotfix to a failover Cluster
- Varchar(8000) is not enough... what can I do?
- Linked table/server to db2(AS/400)
- EAV performance and clustered indexes on views
- Problem with logging into SQL Server via LAN
- Drives on Server and How to Define Raid for them
- SQL 2005 Database Mail Shutting Down
- Issue with sql server jdbc driver 2005
- Dataware house query help !
- No logs
- Need help with transfer many records between tables
- Advantages of SQL Server over Informix?
- How can I estimate time, which query needs to complete work?
- HowTo compare data from 2 different db-sources (xls,csv,sql server, mysql server)?
- Scripting a Default Value for an INTEGER field
- Frequently used tables
- Applied math problem - creating a cut list
- Changing compability mode from 2000 to 2005
- Absences between a date range...
- Third dimension, or something instead?
- SSMS Scripting
- full text search is disabled
- trigger in sql server 2000
- Session Browser in SQL Server
- Synching SQL Server data on a pocket PC and Windows?
- how to speed up table data transfer thru bcp in?
- Backing up transaction log file
- OLAP Design or MDX Syntax to handle 1-many and distinct counts
- Breakout records based on UNIT total without cursor
- SSIS package script
- UNION on two views (Collation issue)
- Dts
- View Performance Problem
- SQL result set materialization process
- Which way is better?
- sql server connection problem
- SQL 2000 Cluster Memory Settings
- #Deleted when a record is changed
- how do you build an enterprise database solution?
- how to convert long date format to short date format in store procedure.
- help with complex delete
- Moving from access to sql, frontend question.
- (+)
- Simple Security Question
- Calling stored proc. multiple times...
- Swap Database to a new server
- Is it possible to to have a primary key that...
- Insert and Update Records
- Problem getting the desired result..Need quick help please!!
- For Xml Explicit
- search all columns of all tables
- Fixed length file output
- Error reporting customization
- Query optimizer for sql 2005
- Linked Server
- Export Text File
- query syntax plz
- How to tell if user has exec auth on sproc
- Local Admin on Report Services
- PartitionFunction & PartitionScheme
- I have a crazy question!!! (Possible or Un-Possible?)
- Select records from two tables, plus page and order them?
- Cannot connect local database
- revoke connect guest user
- Event Class 80 - Missing Join Predicate
- Question about bit masking.
- Application connection string using windows auth
- SUM function
- Query not showing all the records?!
- Stored procedure to access another database...
- Database Recovery warning
- SQL2K FOR XML maximum return length?
- SQL Server 2005 Failover Cluster Install tips
- Update statement.
- Finding some tables
- How to maintain transaction order for perpetual inventory
- Updating table referencing 2nd table using case
- Trigger problem
- group by, max and another column
- Database migration plan - (mssql/msde to -> pgsql/mssql)
- migration from 2000 to 2005 issues/tips
- patch apply question
- EXECUTE AS in MSSQL2000
- sql server login
- How to save a calculated measure in MS OLAP?
- backup file of SQL Server 2000 is Restore in SQL Server 2005
- End a Blocking Process (Was "Block")
- SQL 2000 DTS. Parse Query Bug?
- CPI compliance
- History Cleanup Task
- SQL Server 2005 how to check port
- Error log increase from 6
- Different Sort Orders ??? please help
- Need to remove all duplicate records.
- help on extracting only with three capital letters from the field
- simple pivot sql server 2005
- Pls Help Me! :(
- SQL 2005 return a list of missing rows by date?
- Temp Tables Created in Stored Procedures
- get the latest changed records
- Remote Distributor Cluster
- What is taking so long?
- Bcp
- SQL 2K5 Replication with DB Mirroring - Any experience?
- MOSS Collation Question
- Opening/Converting unknown database
- convert into to 'mm/dd/yyyy'
- Accept NULL value and convert it to default value...
- Execution of a full-text operation failed. 'No such interface supported'
- Installing Sql Server on Web Server
- Convert UPDATE from Oracle to SQL Server.
- Updating Two tables
- Unable to open a DTS with an FTP step. Help!
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.