View Full Version : sql server answers
- sp_xml_preparedocument
- How do I write a query to get the path from ancestor to node in a tree?
- stored procedures using external applications
- sql query question....
- sqlmaint.exe failed
- Execute DTS package from .adp ?
- SQLMANGR.EXE optional parameters?
- connection based temp tables
- Data changes made late at night "dissapear"
- SQL script - sum total issue
- table copy misses indexes
- Version of Windows Server?
- Location of logging for temp tables
- A connection could not be established LOGIN FAILURE
- problem - open recordset - ADO
- Creating Text File from Stored Procedure
- Extracting Time from the SQL DateTime field.
- Reading an XML dataset into a SQL Server dynamically
- How to BCP IN to table with IDENTITY column
- the 'DEFAULT' filegroup is full
- Immediate Synchronization?
- SQLDMO Object
- Inserting large amounts of data
- bcp utf8 file
- Multi-table UDF not returning all rows
- Schedule a T-SQL Script
- DTS- Add global varible's value to text file
- writing SQL data to XML files
- Problem with uncommited transactions in log-file
- inner joins
- joining one table with itself
- Crosstab Query
- Logshipping
- Problem writing XML files.
- Increasing performance by selecting one table
- Slow stored procedures
- Getting count with multiple fields
- JDBC deadlock on unrelated records
- Replacing SELECT with a value in an OUTER JOIN
- Massive delete in DB
- Escape characters
- Regular Expression?
- select * from table where column = @AllValues?
- Problem with case statement
- Reporting Services - Crystal to SSRS
- brain teaser - stagger the order of the results
- Double quotes replacement
- How do I find the highest Unique Identifier?
- Question about Service Pack
- Slow Query Through Cold Fusion
- osql doesn't work - SOLVED
- osql doesn't work
- Getting Avg to really ignore null values
- Problem expanding a Db table (SQL Server 2000)
- Counting Results in a field in SQL 2000
- Left Join Problem
- Update Table Column based on value from another table?
- Incorrect syntax in user-defined function
- 3rd party Backup Software and MSSQL 2000
- COUNT() Idiot
- ((cdate("1/1/2001")+30) as task_due_date (Not working)
- Joins in MSSQL
- View field content update when "real" table fields change
- Export Schema in SqlServer 2005
- Can I force printing?
- list of clustered index in the database
- Memory usage in SQL Server
- compond index and key faster/better?
- The select statement is in a field
- Syntax? - Searching combined columns
- SET ANSI_WARNINGS in Stored Procs - how to avoid recompilation bottleneck?
- SET ANSI_WARNINGS OFF in stored procs - how to avoid recompilation?
- convert ms access sql staement to oracle sql statement
- Assigning Foreign Key To New SQL Server Table
- restore problem about sql server
- Case Sensitive Pattern Match
- Can I access my private db through my web server?
- All records within x minutes of each other
- SMC violating Microsoft license agreements?
- Generating values as part of a compound key
- SQl server processors and threads
- Strange date/time anomaly, or am I just stoopid?
- How to "undo" a delete with cascades
- Why the performace differs?
- Installing SQLServer 2000 service packs on Clustered server
- Will SQL 2k 64bit ed dump files load on 32bit SQL2k?
- Can @@ROWCOUNT return NULL?
- Backup User - Server Role?
- Rewrite a WHERE clause
- SET IMPLICIT_TRANSACTIONS ON
- Memory usage\Performance problem
- MS SQL Server 7.0 SP4 on Windows 2003 Server.
- WTB:Visual Studio Tools for Office 2003
- Database file size question please
- need help with SQL Macro in MS Access
- Searching multiple entities at a time
- Convert float to char
- Datediff needs to deliver month AND days
- Indexes and UniqueIdentifier Fields
- Check Constraints or Triggers
- How to keep a running total
- Key and Index on Same Column?
- Query Analyzer Question
- What does schema mean?
- WHERE field=(select field from tables)??????
- Just being curious
- Select Distinct Keyword Problems...
- Login failed for user 'null'
- Show All Months in First Column of Stored Procedure
- Web Survey database design
- Application Roles for Cross-Database Joins
- Comparing time values
- Stored procedure error handling
- SQL bug?
- Bi-directional Transaction Replication
- bump
- SQL Reporting Services Passing parameters
- Select unique
- Managing ntext, text with a long text data
- Simple 3 table query failing.
- need help : SQL Server and Clear Case
- SQL Server Installation Failure
- Backup question
- Select statement for last and secondlast value
- File / table description.
- Protecting Database From Code Stealing and Installer Advice
- No results found for my search!
- Where to find the the allowed users of SQL2000
- How to find Sql Server properties programatically
- Exchange of login for database user
- DB Design / Custom Attributes
- certification question
- hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
- hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
- hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
- Strange database problem
- Problems with MOD-Function by accessing MS-Access Database via SQL in Delphi
- Droping and adding new user
- Way to create table of months?
- need help with query
- CrossTab
- wrong select or insert into ?
- Pull data from Two tables
- dbo qualified name problem w/Access 2003
- Just starting to learn it . . .
- static/dynamic/embedded SQL distinctions
- Select where uniqueidentifier = 0x hex?
- SQL Server 2005 : Is odbc bulkcopy available?
- 60 GB IPOD deal found
- ODBC SQL Server database reconnect questions
- test
- Help With Query
- how many char's in varchar record
- TSQL Help
- When should I to wrap DML to transaction
- When should I to wrap DML to transaction
- mssql: insert into syntax
- Message: Error Enumerating Data Servers - One solution
- How to find SQL SERVER ?
- Like vs =
- Slow DTS
- Replication
- XML and Reporting Service in 2005
- Need help on a select statement using MYSQL ^.^
- SQL Server - Access synchronization
- Architecture question -- grouping different kinds of stuff...
- ok to delete c:\SQL2KSP4 ?
- DTSRun Utility Won't
- should be easy query question
- Tricky questions.
- count only records from left table ROLLUP or CUBE
- count only records from left table ROLLUP or CUBE
- Access running on TS
- ROWTERMINATOR in bulk insert query.
- Tripling end results of a query
- MSSQL SELECT error
- SQL Server -- how do I retrieve mail?
- HELP! Case insensitive database on case sensitive server
- Columns & rowns interchage on string the data
- "for" loop
- query help
- One table link breaks every time
- DTS Import wizard does not fire triggers
- Can't get SProc to work
- SP won't run as job
- Freaking column names
- SQL Server Software on cluster: local drive other than C:?
- parameterised Queries
- Insert into #temp Exec sproc not working
- Microsoft SQL Server 2005 install problem.........
- how to check does some database exist ?
- What are common indexes?
- View from a table
- Updateable vuew
- ISQL call problem
- Last Entry in a Log
- SQL query
- Help getting multiple listings
- using own functions
- EXEC keyword
- converting string to date
- How do I change the Type of a Stored Procedure from User to System?
- How to LIMIT results in an html php/sql query?
- GROUP BY column-name problem (need expression)
- JOINS to Sub-Queries -vs- JOINS to Tables
- SQL Security related
- Calling DTS From Stored Procedure
- last time someone connected to a database
- Linked Server Trouble to Oracle
- Installation of SQL Server 2005 on the partition disk drive
- HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?
- XML to Database
- Using one single-application connection vs. one connection for every operation to SQL-Server via ADO.NET
- Backup failure Error Log Messages
- executing querys from a batch file
- Copy permissions
- Help with trigger
- Development - Production Data Access
- DB Design Question & Performance in MSSQL
- MAC Address attribute
- Phone # question
- alter table #TempTable problem
- BCP Troubles
- Select with aliases, please help
- Select with aliases, please help
- Dynamic Variables?
- dbo.dtproperties information
- How to get a job current_status in Stored Procedure
- How can I synchronize tables?
- Choosing Compression Utilities for Database Backups
- SQL Server Instances
- 256 table limit for partitioned views
- Ansi Nulls and quoted identified
- How to know a Job Status from Stored Procedure
- How to know a Job Status from Stored Procedure
- How to obtain constraint (key) info
- How to obtain constraint info
- SQL select records NOT in both tables
- Triiger -vs- Constraint
- Adobe GoLive 5.0
- Clustered index and varchar
- Meta Data Catalogue
- For XML: create elements using cell values
- Functions and Execution Plan
- The process could not log conflict information
- Stored Proc Question
- Importing multiple files to SQL
- Difficult SQL-JOIN/UNION-Problem
- Too many sa failed logins
- Does MS SQLServer support auditing in the way that you can for Sybase?
- index bloat?
- Failed insert query
- Line 1: Incorrect syntax near '='
- Configuring SQL MAIL
- Concurrency in Transaction
- Help with a list variable
- Moving the distribution database
- general Q about formulae
- Downgrade SQL Server edition
- Performance-String searching
- change not null to null, default value to empty
- self join or stored procedure
- DateTime in UTC
- Query Question
- Help with "IN" in stored procedure.
- Shameless self promotion
- Convert Foreign Key to Foreign Key with Delete Cascade
- TSQL DEVELOPERS/ C TO H/ ATL
- Table structure of Linked server
- How to get table list from a db? Thanks!
- Difficult SQL-Problem
- Non-US address
- Which is a Good SQL Server Editor
- Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7
- Insert or update into a Image column causes data to double in size
- Problem > 1 GB memory
- Migrade Oracle data to SQL Server 2000
- Upsizing questions
- backup location
- All Roads Lead to Rome but which One is Most Desirable?
- My design - where did I go wrong?
- MIcrosft SQLServer Best Practices document on securing SQLServer
- Retrieving metadata
- why do generated script begin with empty transactions ?
- IF ELSE with WHERE, AND, OR
- n00b question: Connecting to SQL Server at ISP?
- recreate system tables
- Msg 512 but no duplicates!?!
- 1
- 2006-07-26 00:00:00
- identity, plus pk?
- general network error
- Scheduling a script
- Aggregate column comparison in sql server sql ?
- Report query
- Yukon XQuery question
- Need help with SQL query. Keyword matching.
- Easy question on UPDATE
- Scheduled Job Sometimes Error Sometimes Not
- Hardware configuration help for MS SQL server
- Anything that you find in SQL object scripts, you can also find them in system tables?
- OSQL Unicode Insert of ^F (Hex 06) from Registry Multi-String Value is Duplicating in DB
- Help with SQL Query
- MS SQL Reporting Service in Windows 2003 Server
- Users advice seeked
- Very slow distinct select
- Question: Sun-developed SQL 'proxy'
- RowCount VS TOP
- Using CASE .. WHEN to have 'dynamic' sort
- Help on creating a user function.
- Upgradation Of Service Pack from 3 to 4.
- Use SQL-DMO, ADO or ADO.NET?
- How to check the last modifys in database
- view vs. function vs. procedure - really basic question
- security of mssql database?
- How can I shrink my TempDB Databse?
- Check constraint - SQL problem
- Performance Condition Alert Type
- Sql Problem
- Convert month name, year range to mm/dd/yy
- Linking SQL Server 2000 to DB2 Connect 8.x
- Flat file to QUASI-Relational ?
- Update queries using more than one table
- Stored Proceedures
- Using Month Year Table
- How to query by keyword for image field.
- Massive amoutns of Reading
- How to find how a record was deleted
- Verifying Connection to 3rd Party Application
- Auditing user and security related activities in SQLServer
- WHAT DO I USE TO MAKE A TODAY DATE QUERY?
- WHAT DO I USE TO MAKE A TODAY DATE QUERY
- ADODB connection with SQL2000SP3
- Use of set xact_abort on/off
- YellowFin
- mmx.exe as encountered a problem and as to close
- I wish to Avoid ...
- Using NOT EXISTS in an INSERT procedure
- comp.databases , comp.databases.theory , comp.databases.ms-sqlserver
- Why can't I load my DTS job using sp_OAMethod
- How to service data for multiple customers
- mssql lacks
- sp_ExecuteSQL in User Defined Function
- Export to Excel in MS Access
- Code for 1st day & the Last day of the Previous Month
- reporting services excel export
- Make changes to a production database!
- Query with single quotes using OPENROWSET
- SQLServer and network shares
- Query Critique
- SQL Login audit log
- Port security question
- Writing code to compare database schemas
- empty status of a variable
- Time Out Problem
- easily editting fields with more than 1024 characters
- Trigger For DateTime
- Advance Update Statement Sql Server
- temp table name
- duplicate rows but no key on the tables
- problem about right aligned data when using bcp
- OpenRowSet BUG?
- Query Help Please
- Verify phase fails on SQL Cluster on Win 2003 Server
- False error when trying to return data in datagrid
- Delete records not matching Top25 in GroupBy
- THE SELECT STATEMENT
- Delete all records in tblA not matching in tblB
- Using stored procedure result set in another stored procedure
- SQL Server 2000 ODBC related issues...
- sql statement
- Insert Into with Select
- Is it a good to replace SQL script files with XML files?
- I want to avoid using a cursor, please!
- Synchronized Versions
- backup error - error 112
- importing chinese text
- Left Outer Join vs. pkey in (...
- Database User Privilege Report
- Suspect msdb database
- sp_ActiveDirectory_Start problem
- Connecting to MSDE
- Strange SP Problem
- OPENXML question
- Creating a Group By without functions -- possible?
- Is it possible to export a View to Excel in MS SQL 2000 ?
- msaccess to mssql server query parser/convertor
- SQL Server Licensing
- Stored Procedure HELP!
- Need help with Importing XML data to a table
- Query Help Please - Consecutive Dates
- IIS 6.0: How to backup IIS 6.0 and How to restore it after it crashes?
- rsErrorOpeningConnection with oracle
- Bug in Enterprise Manager?
- How to Passing Multi Value Parameter in SQL Query
- How to convert binary trace data
- Selecting from different tables
- need help with SQL query
- Error Notification from User Defined Function
- Basic "getting started" Info on MSDE 2000?
- SQL query
- Integrity between table and View
- Getting 2 SUMs from the same table
- uppercase trigger
- Dates prior to 1753-01-01
- counting field totals as a formula
- T-SQL SERVER DEVELOPERS/ ATL
- Timestamp via Java
- Table Lock
- strange problem with dates
- SQL Replication Question
- Method of providing standby
- SQL Forum
- T-SQL how to deal with results from stored proc
- Preventing Duplicate Rows on Insert
- Copy one row from tableA to tableB
- Good site for data mining resources
- Query error during runtime
- Replication Monitor
- use of 'index' as a field name
- SQL's equivalent of Excels VLOOKUP formula??
- Complicated query - select based on value
- Moving data for reporting
- Veritas SQL agent vs. SQL .bak
- backup from one server, restore to another
- STOP unexpected_kernel_mode_trap after installing SP4
- Descending Sort on index
- Is it a SQL Server 2000 bug
- Comparing two SQLServer databases
- T-SQL problem...selecting TOP 1 of each GROUP in GROUP BY?
- DATABASE EXPLORER, LOADER, REPORTS
- How to disable a warning message ?
- Oracle Stored Procedures VERSUS SQL Server Stored Procedures
- Erwin or Foglight
- Removing system replication tables.
- Insert query takes lot of time
- difference between FOR INSERT and AFTER INSERT triggers
- Select Top Alters Order
- Combining Stored Procedures
- Fulltext Search
- Why nested views are not recommended?
- Subqurey returns more than one value error HELP....
- Reading data from Navision to SQL Server: Date issues
- Problem with Hyphen in Full Text Catalog Search
- ##temp table already exists problem
- create table from another table
- Perot Systems Open House -- Plano Texas
- Audit Tables and triggers
- SharePoint Services Event ID 1007
- Send alert from job
- >> Can Google web search index the data in my database?
- simple select problem
- RenderStream fun!
- stored procedure question
- Rollback issue
- stored procs - specifying ORDER BY as a parameter
- Client EM produce OS "failed login errors"
- Can I use osql to known the database install on a server via 'guest' ?
- Diff between "LEFT OUTER JOIN" and " *= " when condition
- User defined data type used in stored procedure parameters
- For XML clause
- Service fails to start
- Explicitly fail a SQL Server Job in SQL Server 2000
- Trying to understand triggers
- Updating a large table: set @@rowcount versus explicit transactions
- Using CASE or IF with INSERT
- ?HLEP..Sql Server UPDATE INNER JOIN QUERY ?????..
- Can SQLServer produce Excel Spreadsheet output ?
- Connect to SQL Server dialog
- tempdb log full error with plenty of disk space available
- DTS Job - Suspend on fail?
- ACT Logins
- Performance Issues - Access 2000 Frontend SQL Server 2000 Backend
- Last Date Stored Proc Updated???
- Unique number/sequence
- SQL Installation Problem
- Get rows with duplicate values in certain columns
- Script to stop a SQL service
- Backup on network!
- cascaded select
- Need Query to Select VarChar Rows that can convert to Integer
- Deletion of Duplicate Row
- sql trouble
- Why is sp_helpdb and sysdatabases different
- how truncate scientific notation from Real?
- T-SQL create self-reference in depending table
- Related tables
- Insert Records From Table1 that do no exist in Table2
- Can SQL tools be installed from server install?
- DBCC DBREINDEX not working
- Why is it called Stored Procedure instead of Stored Sets?
- MSDE and SQL2000 on Win2k3
- Restoration From Network Drive
- Reporting Services 2000 Projects In Vis Studio 2003
- one to one relationship
- Log file size not reduce
- Exporting data to Excel from a DTS
- SQL queries that have parameters passed by user
- stupid SQL question on Where clause
- Use of user defined in SELECT clause
- Serializable transactions and insert.
- Setting permissions on master.dbo.syslogins
- Transaction not commited rollback?
- MSDASQL to NOTESSQL (odbc)
- Global temporary table and SP
- How to exec stored proc dynamically
- Sales of SQL Enterprise processor 2000 license
- The network path was not found
- ASP.NET Application - Migrating from Access 2000 to SQL Server 7
- Bizarre maintenance plan failure (db backup)
- T-SQL UPDATE .. FROM .. ORDER BY problem
- Member Key found in Fact Table but not in Dimension
- many tempdb locks?
- MS SQL 7 and 2000
- Comparing Log Tools
- Crystal 9 hyperlink text
- Replication or bcp or DTS?
- Distance Between Postal Codes
- Stored Procedure
- Sp_executesql Silly Error
- Database restore
- Deletion old data in replication environment
- Dynamic If Update() in Trigger - Urgent!
- Need your expertise in SQL Server and Windows Server 2003
- SQL 2000 and UTF-16 encoding
- How do I bring in a date which is in Integar form into a databse as a date form.
- best way to optimize certain tables
- timeout issues solved by recompilation
- INstalling SP4 for MS SQLServer 2000
- SQL 2000 Parallelism - is it worth it?
- Can't create table
- Unicode chars with like query statement problem
- question on index used by optimiser
- Restore databases to different server
- SQL Agent Mail Notifications
- Database design pointers (please!)
- SSL only works when ms sql server has "force encryption
- How to Change AutoNumber Not Start From 1
- Question regarding stored procs
- Query help - giving a date range given the start date, thanks!
- Copy objects Wizard - deleted data????
- Conditional -- ?
- Bulk Insert
- functional testing a database web app
- Multiple Insertions
- Linguring SPIDS
- Login failed for user null occurs after a period of time
- ADSI LDAP Query 1000 Record limit for MSSQLServer linked server
- AttribDescription as calculated field
- WAITFOR DELAY '000:00:05'