View Full Version : Microsoft SQL Server
- How to get the second row of a recordset?
- How to get service accounts for 150 servers
- Database acess logscan error
- Naming Convention
- sproc create view and parameter problem
- Connection fails in linking SQL Server 2005 tables into Access using DAO 3.51
- Transactional Replication on an "unusual" Database
- build sql script in excel
- Buggin in 2005
- Restart Linked Server
- replication agents all say "server execution failed"
- Scope of Global Variable
- schema/user details in SQL Server2005
- Global Variable
- SQL Server 2000 and 2005 Express on the same machine?
- Stored procedure problem ? Help needed...
- Iis
- Deadlock Problem in SQL Trigger Urgent
- Export varbinary Data Types to Local PC from SQL Database
- A, B and C are the same but at least D or E are different (was "noob question")
- Problem: DTS parallel tasks running sequentially
- Stored Procedure TimeOut
- Windows Authentication
- Management Studio Missing after installing SQL Server 2005 Dev
- How to save PDF files to SQL Server?
- Timezone of DATETIME data type
- how to access the info of a table created in other database
- Setting up OLAP server: Need Help!
- Installing A Default Instance AFTER a Named Instance???
- Can a user exec a DTS Package...
- copy data from 2 tables
- SQL 2005 replication
- TSQL Text File Output
- SQL Server does not exist or access denied. ConnectionOpen(Connect())
- sql server 2005 install
- sql variables in an SQL transaction?
- WHILE..CONTINUE Problem
- Dropping User created Tables from Master Db
- SQL databases mapping
- probblem with my connection string
- associate each product with multiple bikes (was "How should i.....")
- No dbo for a database - but there are db_owner users
- Check periodically if SQL server is running
- Memory In SQL
- look for not exist data
- How to delete a counter in a field ?
- Reporting Services
- normalizing using sql commands
- Encryption speed?
- 2005/2005Express SQLOLEDB Provider problem
- Select Column
- Stored Procedure that Emails In HTML
- Best Practice? SQL 2000 and 2005 on same server
- SQL 2K EM to SQL 2005
- Need some help with check contraint in SQL2005
- Insert statement with multiple select statements
- SQL Server DBA Salary Survey
- Alter Table Drop Column error
- how to change sql server name
- Creation of Database from dump
- Counting rows
- Reprting Services 2000 Printing
- FORMAT function in SSAS
- Connecting to SQL Server 2000 Named Instances
- replication error
- SQL2000 DTS Save to Storage - funky formatting
- Service Broker example.
- FTS containstable top_n_by_rank
- ADP Report Problems
- distinct row count in a table.
- lob update problem with odbc api
- Querying Active Directory from SQL Server 2000
- Can't drop constraint...?
- reporting services - printing historical snapshot
- Column Alias
- sql server help
- outer join
- Using BACKUP from OSQL and wait for it's end
- how to create a data warehouse or data mart
- Remote Database Management through LDAP Tools
- removing spaces from a text
- Obtaining PATH to master DB
- Replication Best Practice Question: Split Publications
- creating table fields dynamically from another table row
- What are "references" permissions?
- Beginner seeks help
- [help] Oracle 10g publisher to SQL Server 2005
- Adding Delete to Stored Procedures
- Unable to find SSIS Package.
- Reading ClientProcessID
- active X control error when using TSQL
- Getting data off SQL server to CSV
- Query to list indexes from a table ?
- open mdf files w/out sql server
- csv import into ms sql 2000
- Sensitive data
- Need recomendations on architecture.
- Image Error In SQL
- Getting Wrong ID on Query
- Data from versant into MS SQL
- Best practice for 'dbo'
- help,about web server~~configuration~
- Problem with storing a string in procedure
- how to optimize database size in SQL server 2000
- How to use criteria with text file source in DTS package?
- 2000 Evaluation Edition on a server
- simple question regarding outer join (was "SQL Help")
- Date problem
- Store Arabic in Database
- Defining a clustered key
- Dynamic SQL vs OSQL
- linked server w/ text field gets Connection Broken error
- Simple SELECT problem
- Question regarding a Sql Query
- [DBNETLIB] General Network Error - (I have included the event log dump.)
- Multiple parameters to a stored procedure
- how to export db as access mdb file
- Conditional Joins
- SQL Server 2000 Dev Edition - Install Issues on Win XP SP1
- i cant create a model
- OS requirements.
- Mailing DBA when sql server Agent Fails
- incoming mail to SQL server db
- problem with CPU utilization
- User 'sa' is locked out
- Microsoft Corporation Needs SQL Experts
- SQL Query Problem using MAX or Top
- Concatenating a field value from rows
- Bitwise NOT Operation
- Replication 2000 publication to a 2005 subscriber
- BCP failure.
- variable in a select statement
- Exporting DTS jobs?
- Strange problem with Dates
- Call Stored procedure from view
- SQL HELP! Msg 4104, Level 16, State 1, Line 1 - The multi-part identifier error
- Faced unknown problems on SQL Server (Urgent)
- Out of connections... or am I?
- Exit DTS Package
- Concatenating one-to-many relationship into a single column
- Well, this is a new one on me...
- SQL Time format
- Memory of sqlserver.exe cannot released
- Views and alt. user
- Arithmetic overflow error converting expression to data type int.
- xp_smtp_sendmail/xpsmtp80.dll
- Building/Issueing a query with a field with a quote in it?
- Need Info on Tools for MSSQL Reporting etc.
- Is SQL the right DB?
- Converting a Clustered Index on a PK Identity field to non-clustered
- Sql Server 2000 - Dts - Wide Text File Import
- TempDB Placement - One File Per CPU
- MDF without LDF?
- Field too Small; Cannot Use Text or NText; Ugh, little help.
- The timeout period elapsed prior to completion of the operation
- Best Way to handle UID to another server
- Inner Join
- Tracking the history of changes.
- Analysis services
- copy data from one db to an other db
- data migration
- Mgmt Studio Express - open file without opening a new session
- User
- using ActiveX to log into MAccess db
- Analysis Services 2005 Question
- xp_cmdshell execute rights (2005)
- cycles or multiple cascade paths error
- issue with importing paradox blob data
- concat all col2 values for each col1, and add sum(col3) (was "query help")
- SQL 2005 Query Performance
- Analysis Service Question (Grouping Dimension values)
- dbo account error
- Importing Excel Into MS SQL Table
- CASE statement using wildcard
- DTS -Copy tables
- function using comparing dates not working right
- i cant delete a row
- Counting No Of Words In a Column
- Taking EAV create Dimension Table
- Need MIN date
- What is "deterministic"?
- Job fails to communicate with SQL Server Agent
- Login name does not show?
- Executing osql commands through batch file
- Parameter Assignment in DTS SQL task
- checking for free disk space and getting mail , when falls below a certain limit
- Books online downloads for ver 6.5/6.0/4
- Dbf To Ms Sql Server 2000
- What is the query to kown the collate of the database ?
- Identity field with a query ?
- DTS from XML
- Stored Procedure
- counting records in a view
- How to select one record many times?
- MS Analysis Services 2000/XMLA SDK 1.1
- Merge Replication
- Help me in converting Oracle procedure to SQL Server
- Pull subscription initialisation
- updating nodes in a nested set model
- Cross-Tab vs SQL query
- a table/column to table/column data check (was "Help Please, SQL something Simple")
- Does index defrag get logged?
- item master and office stock details (was "Query Problem")
- Need to remove extra spaces in query output
- .cub files
- Find 90th percentile scores for each student
- jTDS and Tempdb Objects
- Querying the primary key for performance
- Getting number of rows
- how to encypt data before i put in the db
- 1900-01-01 in open xml
- SQL Express at home - Can't create login
- Error during Execute sp with IMAGE parameter
- Weird security exception
- SP or query to list locks or deadlocks ?
- import data from MySQL to SQL Server
- SQL Server2000 DB restore problem
- merge replication causes insert timeout
- Problem to install the SQL 2000 on WIndows XP
- Log reader fails on transactional replication
- "TRUNCATE TABLE" in a sproc w/locked-down user
- Discrepancy on Number of Rows
- insert special characters in database
- Do lots of COUNTs
- How To Connect Oracle DB with Microsoft SQL Server
- Formula Error - Cannot find dimension member
- Mentoring
- Installing MS Sharepoint Service on MS SQL2k5
- How do I: SELECT * FROM (1, 2, 3, 4, 5)
- MSSQL replication
- SQL Server Front End - VB/MDB/ADP?
- How do I know if there is a duplicate value in database
- Migrate to active directory
- equivalent in oracle, needed urgently
- dbcc indexdefrag
- Question on Data/structure restore
- View selection question
- Putting CSS and web settings in the DataBase expensive?
- migrating DTS packages
- No regitered server?
- reporting services - subscription
- Spliting single row into multiple rows
- Crosstab problem help
- test your DB skills by answering this
- server.htmlencode in sql store procedure?
- temp tables Vs Tables
- Question on moving logs
- Help - Script that checks for OFFLINE Database
- Database using Frontpage 2003 or Sharepoint 2007 (was "I have a goofy question")
- Database Role/User Query
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.