MS Sql Server

October 2005

Parse out XML in Column
(31 Oct 2005 21:56:56)
TLOGBackup.BAK file is larger than the Fullback up
(31 Oct 2005 21:36:57)
Proc to write Trigger
(31 Oct 2005 21:3:45)
SQL2005 - general question
(31 Oct 2005 20:50:29)
Recovery Plan
(31 Oct 2005 20:26:1)
Optimization / Integrity Checks
(31 Oct 2005 19:56:32)
Stop DB in Recovery mode?
(31 Oct 2005 19:43:22)
ERwin vs. ER/studio...
(31 Oct 2005 19:40:59)
Extreme Discomfort...
(31 Oct 2005 17:37:24)
SQL Server/Access view processing
(31 Oct 2005 17:22:0)
Recursion in a Stored Procedure
(31 Oct 2005 16:54:14)
SQL Server 2005
(31 Oct 2005 16:47:43)
ODCB Connection Error SQL Server Error: 18452
(31 Oct 2005 7:45:11)
LiveState
(31 Oct 2005 1:17:15)
LISTOWNER- EMAIL SHIELDING
(29 Oct 2005 13:0:14)
How to Select the Unique records
(28 Oct 2005 22:50:35)
Full Backups and Transaction Logs back up
(28 Oct 2005 20:14:41)
Big Problem changing datatype in Tables with Many Rows
(28 Oct 2005 19:8:7)
SP4
(28 Oct 2005 16:40:43)
win2k3 sp1 vs. DTS package
(28 Oct 2005 15:12:43)
SP4 (again)
(28 Oct 2005 15:2:27)
Find a object
(28 Oct 2005 14:50:58)
Duplicate checking
(28 Oct 2005 14:33:8)
Sql Registration Failed
(28 Oct 2005 13:44:25)
Moving Datafile Problem
(28 Oct 2005 10:24:3)
Deploy OLAP on Intranet
(28 Oct 2005 9:14:45)
DB Datafile size script for each database on server ...
(27 Oct 2005 23:39:2)
MSDE Install
(27 Oct 2005 19:52:44)
SQL 2000 - Application role - Help!!!
(27 Oct 2005 15:11:50)
SQL Server 2005 System Tables
(27 Oct 2005 14:15:31)
Cache Hit Ratio
(27 Oct 2005 12:19:38)
disable autocommit
(27 Oct 2005 11:1:14)
Email Validation
(27 Oct 2005 10:43:29)
MySQL 5.0 and SQLServer 2000 on same machine?
(27 Oct 2005 10:27:53)
service pack version
(27 Oct 2005 8:52:7)
Re: Spam:Re: Regarding clustering
(27 Oct 2005 0:36:52)
please help
(26 Oct 2005 19:6:53)
SQL Profiler Object Name / Object Type
(26 Oct 2005 17:11:43)
Assertion Errors
(26 Oct 2005 15:42:34)
CPU hit
(26 Oct 2005 14:45:7)
DTS and Sharepoint Portal
(26 Oct 2005 13:36:40)
List all sql server users and database access
(26 Oct 2005 13:21:19)
Help with ActiveX script in a DTS package
(26 Oct 2005 12:57:13)
Error while restoring DB
(26 Oct 2005 12:31:25)
Regarding clustering
(26 Oct 2005 6:46:41)
Cheap way to generate ERD?
(26 Oct 2005 0:0:42)
Syntax Help on Nested Case Statement - please
(25 Oct 2005 22:44:30)
Socket programming through SQL DB
(25 Oct 2005 22:31:16)
Re: sql server 2000 "convert standard time" to military time
(25 Oct 2005 19:46:41)
JTDS Question
(25 Oct 2005 19:34:29)
single vs multiple DB's
(25 Oct 2005 18:55:22)
Graphic tool to monitor database health
(25 Oct 2005 18:48:12)
Could not create an instance of OLE DB provider 'STREAM'.
(25 Oct 2005 18:18:58)
Split the indexes and data into separate .mdf files?
(25 Oct 2005 18:3:56)
DBCC reindex vs. Drop/Create
(25 Oct 2005 18:0:17)
SQL ERROR
(25 Oct 2005 17:49:10)
number conversion
(25 Oct 2005 17:32:19)
Re: Odd Stored Proc compile error
(25 Oct 2005 15:58:0)
How to?
(25 Oct 2005 14:59:30)
OLAP Cube. 2 fact tables
(25 Oct 2005 14:29:24)
OLAP / analysis service / cubes etc..?
(25 Oct 2005 14:4:56)
generate a field from other fields
(25 Oct 2005 13:57:26)
Connecting to MS SQL Server from oracle
(25 Oct 2005 13:48:33)
Restored Database Thinks it's Replicated but it's Not
(25 Oct 2005 12:56:14)
datawarehousing and reports
(25 Oct 2005 10:54:25)
Copying the database,
(24 Oct 2005 22:42:42)
I am pulling my hair out.
(24 Oct 2005 19:23:5)
Query Help
(24 Oct 2005 15:4:6)
Help me
(24 Oct 2005 14:6:4)
Help I can't figure it out.
(24 Oct 2005 13:56:56)
How to find Child record
(24 Oct 2005 13:8:31)
Running Sum
(24 Oct 2005 7:39:42)
Friday reading
(21 Oct 2005 21:51:43)
Lock request time out
(21 Oct 2005 19:32:47)
Query TimeOut and Connections
(21 Oct 2005 18:49:56)
SQL Backup
(21 Oct 2005 17:27:1)
Proper syntax for SQL Server connection in Query statement
(21 Oct 2005 16:2:36)
Re: JOINS
(21 Oct 2005 15:53:5)
Clustered SQL Server
(21 Oct 2005 15:19:11)
Quoted identifiers
(21 Oct 2005 14:53:54)
Access to SQL
(21 Oct 2005 14:2:4)
SQL Server 2005 Options
(21 Oct 2005 13:57:28)
question on stored procedures
(21 Oct 2005 12:3:1)
How do you secure your database that is offsite
(21 Oct 2005 11:45:24)
Formating number in output
(21 Oct 2005 11:30:34)
Recall: Joins
(21 Oct 2005 11:21:43)
Converting from Oracle and DB2 to SQL Server
(21 Oct 2005 9:46:1)
DTS HELP
(21 Oct 2005 8:15:48)
BCP error - anyone ever seen this one?
(20 Oct 2005 23:15:40)
sp_MSforeachtable
(20 Oct 2005 22:45:58)
Best Practice for defrag
(20 Oct 2005 21:10:42)
Re: [SPAM ] Re: Formatting number in output
(20 Oct 2005 19:41:55)
ROLLBACK TRAN
(20 Oct 2005 19:10:52)
Re: [SPAM ] Re: Formating number in output
(20 Oct 2005 18:19:39)
Re: Formatting number in output
(20 Oct 2005 18:15:16)
Find All Occurrences of a Comma in a Column
(20 Oct 2005 18:11:2)
DTS
(20 Oct 2005 16:39:22)
What is E Fail Status?
(20 Oct 2005 12:56:58)
Script around Cascade bug
(20 Oct 2005 12:54:46)
Users & Permissions
(20 Oct 2005 10:55:38)
R: Database in Suspect Mode
(20 Oct 2005 9:30:23)
I want to send mail after backup failure
(20 Oct 2005 9:13:41)
Trigger
(20 Oct 2005 6:50:3)
database in suspect mode
(20 Oct 2005 5:49:7)
Updating all columns in a database
(19 Oct 2005 23:13:38)
Re: Update question
(19 Oct 2005 20:20:28)
Insert and Selects
(19 Oct 2005 18:17:28)
Re: Query Causes Stack Dump.
(19 Oct 2005 16:26:7)
Cursor Threshold Option - what does small mean?
(19 Oct 2005 15:17:24)
XML
(19 Oct 2005 14:35:0)
BCP out image data
(19 Oct 2005 13:44:57)
Re: [BULK] RE: Web Services
(19 Oct 2005 12:35:26)
Linked server to DB2 OS/390
(19 Oct 2005 12:17:21)
Text to HTML
(19 Oct 2005 9:10:11)
Re: Text to HTML--don't shoot me!
(18 Oct 2005 21:5:38)
Shrink Database - DBCC SHRINKFILE
(18 Oct 2005 19:6:3)
pRODUCTION db ACCESS
(18 Oct 2005 19:3:38)
Trigger Help
(18 Oct 2005 18:30:19)
Re: [BULK] Shrink Database - DBCC SHRINKFILE
(18 Oct 2005 18:16:30)
How to run SQL server stored procedure through JAVA?
(18 Oct 2005 15:13:47)
Regarding Joins,
(18 Oct 2005 14:32:15)
Re: [Potential Spam] Re: Replication Monitor
(18 Oct 2005 12:9:58)
Web Services
(18 Oct 2005 2:46:18)
SET/SELECT
(18 Oct 2005 0:6:5)
Replication Monitor
(17 Oct 2005 20:56:20)
permissions to create DTS packages
(17 Oct 2005 20:8:56)
Re: Automating SQL Profiler to monitor DBs
(17 Oct 2005 14:20:24)
R: Cannot resolve collation conflict for equal to operation.
(17 Oct 2005 13:28:15)
SQL Profiler
(17 Oct 2005 13:3:34)
Cannot resolve collation conflict for equal to operation.
(17 Oct 2005 8:45:16)
SQL Service manager not starting
(17 Oct 2005 8:42:58)
Sitll Error with Insert Query While entring & Sign
(16 Oct 2005 6:55:42)
Update query
(15 Oct 2005 3:55:59)
Database access via Excel and Access
(14 Oct 2005 21:50:20)
Thanks for the replies ---- RE: Stopping Error Messages Appearing
(14 Oct 2005 21:13:17)
Changing Service Account Passwords
(14 Oct 2005 21:12:29)
Stopping Error Messages Appearing
(14 Oct 2005 20:29:23)
Row number on the fly?
(14 Oct 2005 16:5:34)
Query Analyzer / SQL server user issue
(14 Oct 2005 15:39:34)
Export DB to MS Access
(14 Oct 2005 15:33:36)
SQL Debugging and How to Edit Long text
(14 Oct 2005 15:26:23)
Using an .ini file in dts pkgs
(14 Oct 2005 15:9:34)
Index information in general
(14 Oct 2005 14:45:19)
Need Case In-sensitive Index
(14 Oct 2005 13:13:56)
GUID conversion
(14 Oct 2005 12:29:42)
SQL Express on Win XP
(14 Oct 2005 10:32:2)
Raid Failue now sql server will not start
(14 Oct 2005 10:31:30)
SQL Server 2000 sp_databases
(14 Oct 2005 9:19:51)
Help me!
(14 Oct 2005 8:45:32)
how to delete existing merge subscription?
(14 Oct 2005 3:57:0)
SQL 2K sp3a on WIN 2K Adv Server SP4 cannot use 3Gb of RAM
(14 Oct 2005 3:10:12)
Help On Procedure
(13 Oct 2005 23:29:50)
leading blank in isql/osql output
(13 Oct 2005 18:59:36)
Another Full Log File
(13 Oct 2005 18:49:12)
Need help
(13 Oct 2005 17:51:1)
Query Analyzer
(13 Oct 2005 17:18:33)
concatenate
(13 Oct 2005 17:12:33)
Error while inserting & sign in Insert Query
(13 Oct 2005 16:55:2)
Re: ID on Results using Table Var
(13 Oct 2005 15:29:1)
ID on Results
(13 Oct 2005 14:27:28)
Re: Spam:RE: SQL 2K sp3a on WIN 2K Adv Server SP4 cannot use 3Gb of RAM
(13 Oct 2005 13:1:22)
Error with Insert Query
(13 Oct 2005 7:22:43)
Long running transaction - open transaction ( dbcc opentran)
(13 Oct 2005 2:43:22)
sql 2005 defncopy
(12 Oct 2005 20:15:24)
Query question
(12 Oct 2005 20:1:22)
Using OpenXML for multiple rows,
(12 Oct 2005 19:50:42)
please assist
(12 Oct 2005 19:26:35)
set column lengths
(12 Oct 2005 19:10:51)
Need to find out number of days between two dates.
(12 Oct 2005 19:8:2)
Rebuild index
(12 Oct 2005 18:57:11)
Restore failure
(12 Oct 2005 18:14:26)
License
(12 Oct 2005 16:54:46)
Re: Strip Unwanted Characters
(12 Oct 2005 16:5:9)
Re: Spam:RE: License
(12 Oct 2005 15:41:58)
Reindexing failure leads to no backups or maintenance
(12 Oct 2005 15:9:57)
Dates
(12 Oct 2005 14:45:43)
Recall: DATES
(12 Oct 2005 13:40:36)
Statistics on SQL DB
(12 Oct 2005 13:17:56)
SQL 2k
(12 Oct 2005 10:29:16)
alternative to CASE in view
(11 Oct 2005 20:42:20)
how to do EM for not so powerful user
(11 Oct 2005 17:21:50)
Re: [SPAM:HEADER] - how to do EM for not so powerful user - Numbe r of numbers in MIME From exceeds maximum threshold
(11 Oct 2005 16:34:7)
Database Mirroring
(11 Oct 2005 14:13:42)
people and property
(11 Oct 2005 14:10:45)
Truncate Logs
(11 Oct 2005 12:57:22)
Accessing SQL Server across the globe
(11 Oct 2005 12:55:7)
Backup / restore to different server
(11 Oct 2005 11:59:12)
Multiple listners i want to start on same server
(11 Oct 2005 7:35:52)
How to copy string in table
(10 Oct 2005 22:53:58)
Formatting SQL Output in View
(10 Oct 2005 19:38:59)
Transact SQL
(10 Oct 2005 19:6:39)
Joining tables on more than 1 criteria...
(10 Oct 2005 17:34:54)
Error while restoring
(10 Oct 2005 17:34:9)
SQL SP3a Upgrade
(10 Oct 2005 15:55:36)
Reads Writes and a Question
(10 Oct 2005 15:49:43)
Security Admin
(10 Oct 2005 14:40:57)
Boy and girls any ideas how I can slove this.
(10 Oct 2005 14:35:6)
db in suspect mode
(10 Oct 2005 13:23:23)
MDF & LDF Disk Defragging
(10 Oct 2005 11:26:42)
Transfer Data
(10 Oct 2005 11:21:6)
DTS package permissions
(10 Oct 2005 8:52:53)
sp_helpdb into a table?
(8 Oct 2005 2:11:44)
I just found out from a developer that MS offers free SQL 2005 ecourses.
(7 Oct 2005 20:32:3)
Changing default file locations
(7 Oct 2005 19:56:18)
How do you cahnge the collation name of a database
(7 Oct 2005 18:49:42)
Need help with a restore script.
(7 Oct 2005 17:25:32)
Copy parent child related data, elegant solution challenge
(7 Oct 2005 16:59:51)
looping through dates
(7 Oct 2005 16:18:18)
Need to store output of sp_helpdb into a table.
(7 Oct 2005 15:59:22)
Sql Replication
(7 Oct 2005 15:40:21)
BAckup job stuck in "Processing Completion operations"...
(7 Oct 2005 15:5:27)
Odd data problems.
(7 Oct 2005 14:44:8)
Point in Time Recovery
(7 Oct 2005 10:2:13)
Need a shell script to do exports on Linux (Red Hat) for oracle 9i
(7 Oct 2005 7:38:45)
Change DTS Package owner
(7 Oct 2005 7:3:25)
Numbers of DataSets
(6 Oct 2005 17:34:43)
Standard versus Enterprise license
(6 Oct 2005 15:51:54)
Can you place DBCC CHECKIDENT inside a job or DTS package within a transaction?
(6 Oct 2005 14:20:8)
SQL Group By question
(6 Oct 2005 14:11:22)
Busy Database?
(6 Oct 2005 12:47:43)
No of users Connected to SQL server .
(6 Oct 2005 12:42:13)
best practices
(6 Oct 2005 12:2:47)
Reg : Row level lock across transactions
(6 Oct 2005 8:33:4)
Reg : ROWLOCK in Sql Server 2000
(6 Oct 2005 6:28:27)
distmdl.ldf and distmdl.mdf
(6 Oct 2005 0:35:21)
Linking to Oracle 9i from MS SQL 2000
(6 Oct 2005 0:30:8)
Shrinking Database Data or Log Files in Stages
(5 Oct 2005 22:47:17)
Need to way to reclaim an Identity seeded value
(5 Oct 2005 22:25:15)
Immediate restore
(5 Oct 2005 20:9:18)
Change of Domain on SQL Server machine
(5 Oct 2005 19:38:26)
Job owner
(5 Oct 2005 19:31:48)
Qualifying function names
(5 Oct 2005 19:14:56)
Changing object owner
(5 Oct 2005 17:41:22)
Help w. Newly Failing Restore....
(5 Oct 2005 17:10:27)
Truncating the Transaction Log
(5 Oct 2005 16:43:14)
client network utility
(5 Oct 2005 16:0:48)
Best replication option...
(5 Oct 2005 15:8:24)
New Machine
(5 Oct 2005 14:50:46)
Really new some help with this !!!
(5 Oct 2005 14:0:34)
Porting SQL Server Databaase to Oracle 9i
(5 Oct 2005 13:58:23)
maintenance history
(5 Oct 2005 13:39:23)
Backup Script
(5 Oct 2005 12:54:51)
INCREMENTAL/DIFFERENTIAL backups ...
(5 Oct 2005 11:39:47)
SQL Server DB Owner(ship)
(5 Oct 2005 11:22:16)
Deleting duplicate records
(5 Oct 2005 6:29:27)
Re: Spam:Deleting duplicate records
(5 Oct 2005 6:24:27)
DateOrString
(4 Oct 2005 23:5:41)
Synonyms in SQL Server 2005
(4 Oct 2005 16:47:56)
SYSJOBSERVERS, SYSJOBSCHEDULES, SYSJOBHISTORY
(4 Oct 2005 16:29:53)
ALTER COLUMN
(4 Oct 2005 16:21:22)
Defragmenting all tables
(4 Oct 2005 16:9:52)
ANSI Padding after ALTER
(4 Oct 2005 15:40:23)
SQL Server Agent Will Not start
(4 Oct 2005 14:59:28)
Hi
(4 Oct 2005 14:46:48)
Re: [BULK] Deleting duplicate records
(4 Oct 2005 14:1:28)
Daily Backup
(4 Oct 2005 13:3:58)
Katrina!
(4 Oct 2005 12:46:53)
SQL Server Blockage
(4 Oct 2005 11:34:54)
Help needed in sql functions
(4 Oct 2005 11:26:31)
Re: Spam:RE: Spam:How to create and alter a temp table inside the stored procedure
(4 Oct 2005 11:24:15)
2k to 2005 upgrade - good/bad things
(4 Oct 2005 10:10:27)
Merge Replication between sites - Keeping hot backup servers ready
(4 Oct 2005 9:49:10)
Record and field comparison
(4 Oct 2005 9:12:40)
table update/insert question
(4 Oct 2005 8:38:31)
Log Shipping Status
(4 Oct 2005 8:32:55)
How to create and alter a temp table inside the stored procedure
(4 Oct 2005 7:59:34)
Question - best practices for index maintenance?
(4 Oct 2005 2:53:10)
Is win 2003 Server essential for a system to be a DB SERVER
(3 Oct 2005 22:38:53)
Double-Hop Authentication / AD 2003
(3 Oct 2005 22:30:10)
Re: Spam:How to create and alter a temp table inside the stored procedure
(3 Oct 2005 17:33:53)
defrag tool for large device files
(3 Oct 2005 17:8:44)
Re: Off-Topic, pt II??
(3 Oct 2005 16:38:11)
New York Yankees vs Boston Red Sox
(3 Oct 2005 15:40:15)
Multiple SELECTS in one stored procedure
(3 Oct 2005 15:38:41)
Problem with dtsrun
(3 Oct 2005 15:8:45)
LISTOWNER - Baseball thread
(3 Oct 2005 14:35:55)
Off-Topic ??
(3 Oct 2005 12:51:3)
Re: [SPAM ] RE: New York Yankees vs Boston Red Sox
(3 Oct 2005 12:2:57)
Install of SQL Server mistake
(3 Oct 2005 11:18:47)
Secondary SQL Instance
(3 Oct 2005 11:13:9)
Related to performance
(3 Oct 2005 9:51:33)
ODBC Connection Problem ANONYMOUS LOGON
(3 Oct 2005 8:8:53)
Need suggestions
(3 Oct 2005 4:59:5)
tempdb log full
(3 Oct 2005 0:50:20)
Import vs backup & restoring a database
(2 Oct 2005 1:59:1)
EM like tool for Oracle
(1 Oct 2005 6:55:11)
Restoring master & msdb on a log shipping destination server ...
(1 Oct 2005 4:20:54)
Sending email notifications from E-Commerce Web Site,
(1 Oct 2005 1:55:34)
sql lazydba home page