MS Sql Server

August 2006

curious about locked process
(31 Aug 2006 23:45:30)
Removing extended SP
(31 Aug 2006 23:38:48)
Convert Oracle SQL statement to MS SQL
(31 Aug 2006 23:25:54)
?
(31 Aug 2006 21:18:26)
Re: [Spam?] (4) RE: SQL Server and hyperthreading
(31 Aug 2006 20:56:1)
Global Variable
(31 Aug 2006 20:13:40)
SQL Collation Issue
(31 Aug 2006 20:9:48)
Stored Procedures
(31 Aug 2006 19:42:15)
Interesting Upgrade Path
(31 Aug 2006 19:42:15)
HI All.
(31 Aug 2006 18:38:13)
Performance Monitor
(31 Aug 2006 16:7:30)
Move SQL Server Logins to Other server!!!! - Urgent
(31 Aug 2006 15:13:11)
Deleting old backup files.
(31 Aug 2006 14:25:3)
How to save PerfMon data into a file?
(31 Aug 2006 14:24:8)
what are the valid sql server Tape format backup sets
(31 Aug 2006 14:24:2)
SQL Compatibility Level
(31 Aug 2006 12:54:32)
How to monitor CPU usage for a database in the Profiler?
(31 Aug 2006 12:26:31)
Stored Procedure...
(31 Aug 2006 12:3:54)
Clustering in sql server
(31 Aug 2006 6:39:24)
Can we create recursive cursor in SQL Server 2000
(31 Aug 2006 5:45:57)
Kinda urgent but not wanting to upset any lazies
(31 Aug 2006 2:2:7)
SQL Server and hyperthreading
(30 Aug 2006 20:45:8)
A Lazy DBA first for me
(30 Aug 2006 20:33:0)
Stored Procedure syntax for cursor
(30 Aug 2006 19:23:35)
case statement needs tweaking
(30 Aug 2006 18:6:54)
Help! How do I set up SQL Service Agent? It won't start anymore!
(30 Aug 2006 17:54:2)
IIS & SQL2005
(30 Aug 2006 14:43:41)
Error 33
(30 Aug 2006 13:50:26)
model db saying out of log space...
(30 Aug 2006 13:42:8)
Weird problems with DTS packages
(30 Aug 2006 13:33:38)
How to programmically determine owner of a database?
(30 Aug 2006 13:27:34)
SSIS - Version80 not supported [Object Tasks]
(30 Aug 2006 13:25:10)
DTSs
(30 Aug 2006 12:35:28)
Not Able To Execute This Query in SP
(30 Aug 2006 12:13:54)
please help
(30 Aug 2006 11:55:13)
Scripts for DB deletion
(30 Aug 2006 10:43:34)
Date and Time
(30 Aug 2006 6:40:5)
Migrate DTS
(29 Aug 2006 23:7:29)
How to manage deletes on a high transaction database?
(29 Aug 2006 21:28:4)
some query help
(29 Aug 2006 20:59:34)
Changing character set on MSDE.
(29 Aug 2006 18:47:19)
Integer Vs Numerics
(29 Aug 2006 18:44:17)
Transactional Replication
(29 Aug 2006 17:45:55)
Dynamic Column Mapping.
(29 Aug 2006 17:19:30)
Import options missing
(29 Aug 2006 17:9:5)
String Concatenate With Group By
(29 Aug 2006 16:5:32)
Ole db provider
(29 Aug 2006 15:50:14)
RPC-calls and EXECUTE in QA
(29 Aug 2006 15:6:51)
Primary Key vs Unique Key
(29 Aug 2006 14:46:31)
2005 Partitioned tables
(29 Aug 2006 14:45:31)
Triggers
(29 Aug 2006 14:16:48)
Creating a Job Having Parameterized Stored Procedure!!!!
(29 Aug 2006 14:11:10)
Bulk Insert Error
(29 Aug 2006 13:57:59)
Timestamp
(29 Aug 2006 13:10:44)
How to suppress sqlstate in output file
(29 Aug 2006 13:4:24)
SCRIPTS
(29 Aug 2006 12:51:59)
Hi
(29 Aug 2006 12:50:16)
Hi All,
(29 Aug 2006 12:34:14)
Last Update Time
(29 Aug 2006 11:32:21)
Null value
(29 Aug 2006 7:2:2)
Alter Table Type Variable
(29 Aug 2006 6:32:17)
Script to stop and restart SQL
(29 Aug 2006 4:26:16)
installing sql 2005 x64
(29 Aug 2006 3:41:6)
Replication conflicts and triggers
(28 Aug 2006 23:26:25)
Logging events in event viewer
(28 Aug 2006 20:26:32)
Re: Error 22272
(28 Aug 2006 18:31:51)
speaking of dates
(28 Aug 2006 15:47:7)
what is the deal with QUOTED_IDENTIFIER
(28 Aug 2006 15:35:21)
Column Encryption - Use Case Sensitive Collation !
(28 Aug 2006 15:12:37)
anybody there ??
(28 Aug 2006 15:2:36)
Delete file from T-SQL
(28 Aug 2006 13:39:47)
off line question
(28 Aug 2006 13:25:7)
Need
(28 Aug 2006 13:23:7)
row count not same
(28 Aug 2006 12:29:21)
Scripts For DB Growth Size
(28 Aug 2006 12:20:8)
Format Date
(28 Aug 2006 11:57:14)
change of location - SQL Server 2000
(28 Aug 2006 10:2:40)
db2 error handling in stored procedure
(28 Aug 2006 7:28:53)
Antwort: Format Date
(28 Aug 2006 7:14:33)
Does full backup clear transaction log?
(28 Aug 2006 5:31:3)
Re: [SPAM-4.2]- RE: A Lazy DBA first for me
(27 Aug 2006 23:26:56)
How to grab the single user connection on an instance on a SQL 20 00 cluster?
(27 Aug 2006 20:27:7)
LISTOWNER- EMAIL SHIELDING
(26 Aug 2006 13:0:1)
How can import data from a plain text file to a table without designing it?
(25 Aug 2006 22:5:17)
Replication Issue/Question
(25 Aug 2006 21:15:3)
File Extension Question
(25 Aug 2006 20:57:46)
problem converting from MySql to MSSQL
(25 Aug 2006 20:11:16)
DTS Import/Export vs SQL Server Business Intelligence Development.
(25 Aug 2006 19:35:5)
INSERT-UPDATE Column order & Performance
(25 Aug 2006 18:51:9)
inserting only current records to my table
(25 Aug 2006 18:2:35)
A little gem I found while looking into an issue
(25 Aug 2006 17:28:26)
Re: Help! SQL Server Job problems - still!
(25 Aug 2006 16:14:6)
disadvantages to setting transaction log file bigger than whatis needed
(25 Aug 2006 16:4:14)
Database in loading - RESTORE with RECOVER work?
(25 Aug 2006 15:30:13)
Not able to recover/reattach the database marked as suspect.
(25 Aug 2006 11:34:15)
Script system objects in sql server
(25 Aug 2006 10:12:15)
URGENT: Help! SQL Server Job problems - still!
(25 Aug 2006 8:26:54)
Backup Scripts !!!!
(25 Aug 2006 5:15:11)
functions and tem tables
(25 Aug 2006 2:10:40)
Hiring SQL Developer in Southern California (Irvine area)
(25 Aug 2006 0:32:57)
SQL server Memory issues
(24 Aug 2006 20:47:18)
MD5 File Hashing
(24 Aug 2006 19:48:55)
Capturing one procedure's output data stream in another procedure
(24 Aug 2006 19:20:42)
DTS package logs
(24 Aug 2006 18:34:29)
Statistics
(24 Aug 2006 18:30:51)
Tools for viewing transaction log
(24 Aug 2006 18:18:17)
Veredus Corporation-LAS VEGAS anyone???
(24 Aug 2006 18:11:11)
Migrate SQL jobs from one server to another
(24 Aug 2006 18:10:23)
Text to PDF's
(24 Aug 2006 18:3:0)
clustered servers
(24 Aug 2006 17:3:32)
SQL Server Database Encryption
(24 Aug 2006 15:33:1)
Declaring Variables
(24 Aug 2006 14:3:17)
SQL Server SP4 patch 2187
(24 Aug 2006 14:2:57)
script to find size of tables in my database
(24 Aug 2006 13:35:18)
Assign field name to variable
(24 Aug 2006 13:13:47)
DTS job flow
(24 Aug 2006 11:55:1)
script to drop + recreate constraints
(24 Aug 2006 10:47:34)
Quick question from Newbie
(24 Aug 2006 8:39:25)
SQL 7 restore database
(24 Aug 2006 7:31:41)
drop constraint
(24 Aug 2006 7:6:3)
getting this error during execution of job
(24 Aug 2006 6:57:4)
Linked server error during connecting for application
(24 Aug 2006 6:50:58)
Linked Server OPENQUERY
(24 Aug 2006 6:48:20)
Slow Query in Stored Procedure
(24 Aug 2006 6:46:15)
Re: Table Properties SQL Server 2000 Standard Edition
(24 Aug 2006 6:39:34)
Re: [SPAM-4.2]- RE: Capturing one procedure's output data stream in another procedure
(23 Aug 2006 21:31:3)
Re: [SPAM-4.2]- Assign field name to variable
(23 Aug 2006 20:11:4)
writing to a log file or event log from stored procedure
(23 Aug 2006 19:4:3)
Moving LDF Files
(23 Aug 2006 17:10:5)
Intermittent SQL Mail Problems
(23 Aug 2006 16:50:36)
ORPHANED USERS
(23 Aug 2006 16:41:5)
Re: How to determine the recovery mode for SQL Server 7?
(23 Aug 2006 16:32:50)
How to determine the recovery mode for SQL Servre 7?
(23 Aug 2006 16:21:42)
Transaction log growth with Reindex
(23 Aug 2006 16:19:31)
MSDTC service not available.
(23 Aug 2006 16:10:39)
MS SQL BACKUP RECOVERY SCRIPTS!!!!
(23 Aug 2006 12:49:49)
Restoring database using transaction LOG
(23 Aug 2006 11:32:9)
Size not reduced
(23 Aug 2006 10:26:19)
How to implement the Filegroups!!!
(23 Aug 2006 10:17:50)
How to restore logs!!!
(23 Aug 2006 7:4:3)
How to truncate log file manualyy in sql server 2000
(23 Aug 2006 5:52:20)
RETENTION PERIOD FOR BACKUP
()
Unable to drop the users tables
()
parsing strings
()
Re: query that will show active jobs
()
db recovery problem
()
Hosed server cannot rebuild master
()
Transaction Log File Size & Execution Plan!
()
Performance issues on cluster
()
Free space in datafiles in sql server
()
collation name
()
Invalid foreign key violation.
()
Need a Query
()
Failure in JOB
()
DTS package for monitoring database size ...
()
error while attaching data files
()
Question about IAM pages
()
Ram Disks, Ram San devices.
()
Good Replication reference?
()
INSERT Trigger Help
()
Startup parms
()
script issue - SQL BAK restore
()
Query is Slow...
()
SQL DBAs levels (L1, L2, L3 & L4)
()
SQL Job Error
()
Need help parsing a text field
()
Log Shipping Error
()
Math...I hate math
()
Backup location changes
()
backup and truncate trans log file
()
sql Agent
(18 Aug 2006 18:1:1)
T-SQL script
(18 Aug 2006 18:0:6)
Re: [SPAM-4.2]- RE: [SPAM-4.6]- RE: search for closest match
(18 Aug 2006 17:19:11)
Re: ***SPAM*** RE: T-SQL script
(18 Aug 2006 15:38:31)
SP4 and low performance
(18 Aug 2006 15:38:24)
Re: [SPAM-4.6]- RE: search for closest match
(18 Aug 2006 14:52:24)
TCP/IP - SQL Server Error
(18 Aug 2006 14:51:27)
search for closest match
(18 Aug 2006 13:57:5)
"Duplicating/Cloning" a database user
(18 Aug 2006 13:31:33)
Re: Can I delete my transaction log
(18 Aug 2006 12:25:34)
Outer Join??
(18 Aug 2006 9:28:11)
SQL Newbie - Performance Issues
(18 Aug 2006 7:44:50)
SQL job multiple schedules
(17 Aug 2006 19:11:27)
Re: ***SPAM*** RE: SQL job multiple schedules
(17 Aug 2006 19:4:45)
Transferring users
(17 Aug 2006 19:1:17)
TEXT TO PDF
(17 Aug 2006 18:23:30)
SQL dosk Space Script
(17 Aug 2006 15:20:7)
Permissions Question
(17 Aug 2006 13:58:1)
DBO Rights
(17 Aug 2006 13:11:46)
Update fails help.
(17 Aug 2006 13:4:22)
Updates from views
(17 Aug 2006 11:49:56)
SP returned field information
(17 Aug 2006 11:25:49)
Re: [BULK] RE: DBO Rights
(17 Aug 2006 9:34:39)
MS-SQL 2000 Replication Problem
(17 Aug 2006 9:14:34)
Automating a trace
(17 Aug 2006 7:30:47)
Scripting out DTS Packages
(17 Aug 2006 5:59:5)
where is data held?
(16 Aug 2006 23:16:14)
Backup over the Network
(16 Aug 2006 23:8:4)
shrinking log file when database is online
(16 Aug 2006 18:46:53)
dynamic properties task
(16 Aug 2006 18:17:9)
remote local server
(16 Aug 2006 17:35:31)
SYNTAX CHECK
(16 Aug 2006 16:25:16)
SQL Ghost Cleanup
(16 Aug 2006 13:55:12)
Getting Cluster awareness info from SQL
(16 Aug 2006 13:50:40)
Linking to Oracle from SQL Server
(16 Aug 2006 12:57:28)
Does a database need a TRN file if your database is on simple recovery?
(16 Aug 2006 12:41:18)
DB Backup
(15 Aug 2006 21:31:49)
Postgresql
(15 Aug 2006 20:16:11)
Query Question.
(15 Aug 2006 19:46:9)
Re: [POSIBLE SPAM] (60%) RE: Export to BCP
(15 Aug 2006 19:13:17)
Re: [SPAM-4.2]- RE: Export to BCP
(15 Aug 2006 17:13:58)
www.dbmaint.com utilities?
(15 Aug 2006 17:6:52)
Performance between MSSQL and Oracle (Linked Server)
(15 Aug 2006 16:8:46)
Diagrams
(15 Aug 2006 15:41:50)
Importing Data from SQL 2000 into Oracle
(15 Aug 2006 15:40:42)
who touched that table!
(15 Aug 2006 14:58:45)
Moving DTS Packages
(15 Aug 2006 14:19:55)
How to return proper SQL version
(15 Aug 2006 11:24:16)
Beginner Question about clustered index
(14 Aug 2006 21:24:9)
Which version of SP4 to download
(14 Aug 2006 19:43:32)
SQL 2005 Configuration Manager ports with a firewall
(14 Aug 2006 19:37:47)
DTS and dynamic properties
(14 Aug 2006 17:45:53)
BCP Question - Export Field names?
(14 Aug 2006 17:37:11)
DTS Packages
(14 Aug 2006 16:55:19)
SQL2000 Enterprise Manager error: An error 1051 - (A stop.....
(14 Aug 2006 14:1:56)
Memory leaks
(14 Aug 2006 13:41:5)
Query Help
(14 Aug 2006 8:7:8)
Re:DATA DICTIONARY
(12 Aug 2006 8:1:13)
Import numeric columns with NULLs
(11 Aug 2006 21:19:55)
Backup Preference
(11 Aug 2006 20:40:19)
Troubleshooting
(11 Aug 2006 20:15:45)
Server memory configuration
(11 Aug 2006 18:4:36)
Listing of Scheduled Jobs
(11 Aug 2006 16:50:47)
Linked Servers
(11 Aug 2006 14:52:50)
WITH TIES - what's the difference?
(11 Aug 2006 14:52:14)
Antwort: WITH TIES - what's the difference?
(11 Aug 2006 14:51:37)
Data Dictionary
(11 Aug 2006 14:45:3)
Generate CSV or XLS From Stored Procedure
(11 Aug 2006 14:37:30)
XACT_ABORT and IBMDA400
(11 Aug 2006 14:31:17)
CLR Assemblies
(11 Aug 2006 13:45:28)
Line Numbers
(11 Aug 2006 13:25:26)
Re: SQL Server Alert System: 'Demo: Sev. 21 Errors' occurred on \ \NTS-STRAD
(11 Aug 2006 12:20:11)
Crosstab Queries
(11 Aug 2006 11:48:36)
SQL 2000 error - Protocol error in TDS stream
(11 Aug 2006 11:19:1)
Is it possible to add file group of database in another database.
(11 Aug 2006 6:31:8)
can't cycle still might be worse than before
(10 Aug 2006 22:24:46)
Login failure!!!
(10 Aug 2006 21:33:12)
Cannot reuse name of renamed table
(10 Aug 2006 19:15:5)
An UFO in the error !!
(10 Aug 2006 19:0:4)
A mystery
(10 Aug 2006 18:25:29)
AWE memory - how much am I actually using?
(10 Aug 2006 15:45:47)
can cycle server
(10 Aug 2006 15:40:31)
MOVING A DTS PKG
(10 Aug 2006 15:29:49)
Query question
(10 Aug 2006 14:26:20)
Moving Tempdb to another disc.
(10 Aug 2006 14:22:47)
Can a non SQL System Administrator run SQL Agent Jobs?
(10 Aug 2006 14:20:11)
SQL 2005 to SQL Server 2000
(10 Aug 2006 14:11:48)
DTS Error
(10 Aug 2006 12:54:46)
Regarding Scripts for backup
(10 Aug 2006 6:38:17)
Search in SQL
(10 Aug 2006 6:33:7)
Database Performance????
(10 Aug 2006 6:5:50)
Offline backup...
(9 Aug 2006 21:36:46)
with (nolock) query hint
(9 Aug 2006 20:1:10)
backup Set Expire
(9 Aug 2006 19:18:30)
Re: MySQL SQL statistics
(9 Aug 2006 17:59:42)
SQL query with many counts
(9 Aug 2006 16:22:2)
How to find version
(9 Aug 2006 15:41:40)
SQL 2000 cluster with SQL 2005 cluster
(9 Aug 2006 15:19:22)
Sp_changeobjectowner error message
(9 Aug 2006 15:13:15)
Change Collation
(9 Aug 2006 15:4:18)
Re: [SPAM-4.2]- Change Collation
(9 Aug 2006 13:50:58)
Replication Nightmare
(9 Aug 2006 13:45:55)
Idera Products
(9 Aug 2006 13:24:47)
Select in SQL Server 2000
(9 Aug 2006 12:35:47)
Maximum connections
(9 Aug 2006 11:1:37)
AS400 To SQLServer 2000 Pull
(8 Aug 2006 19:32:40)
Awe Memory
(8 Aug 2006 18:42:31)
Table Activity
(8 Aug 2006 18:0:31)
Qry to find the first space
(8 Aug 2006 17:37:57)
ADO Multiple Result Sets Per Procedure
(8 Aug 2006 16:23:19)
More DTS woes
(8 Aug 2006 15:21:54)
Can Data Files/ Transaction logs reside on OS volume?
(8 Aug 2006 13:35:53)
Transaction Log sizing
(8 Aug 2006 13:31:25)
no commited transactions
(8 Aug 2006 8:38:9)
DTS Hangs using UDL file
(7 Aug 2006 21:17:11)
Questions on Rebuilding Indexes
(7 Aug 2006 19:48:50)
BIN Database
(7 Aug 2006 19:27:32)
Table Indexing
(7 Aug 2006 18:49:19)
ALTER INDEX / DBCC INDEXDEFRAG for all tables in a db?
(7 Aug 2006 17:18:28)
DTS reports column too large for buffer size
(7 Aug 2006 16:27:52)
trivia
(7 Aug 2006 15:54:58)
Re: *** RE: WHY? WHY? WHY?
(7 Aug 2006 12:14:40)
@@IDENTITY
(7 Aug 2006 11:42:31)
Error 21002
(5 Aug 2006 5:4:41)
8.00.2187
(4 Aug 2006 20:31:56)
2005 dts
(4 Aug 2006 19:28:49)
WHY? WHY? WHY?
(4 Aug 2006 18:30:46)
Push subscriptions in sql2005
(4 Aug 2006 16:34:57)
Ldf File Hogging up all space.
(4 Aug 2006 15:37:57)
SSIS Package running as a scheduled Job
(4 Aug 2006 14:41:20)
Partition and add file group
(4 Aug 2006 14:29:6)
How to access sql sever
(4 Aug 2006 11:36:53)
Query run behind DBREINDEX
(4 Aug 2006 10:43:54)
Regarding SQL Server 2000 Collation Altering
(4 Aug 2006 0:6:9)
Win2K3 Server Release 2 SQL 2005 installation issue
(4 Aug 2006 0:5:51)
10 small databases vs. 1 big database with 10 schemas
(3 Aug 2006 22:24:59)
Trigger Issue
(3 Aug 2006 20:21:14)
SP Parameter Problem
(3 Aug 2006 20:19:30)
Flat file vs. RDBMS.
(3 Aug 2006 20:16:3)
Export list of Tables with new tool?
(3 Aug 2006 18:32:40)
How to check sql server users/login password
(3 Aug 2006 18:12:32)
Merge Replication Problem
(3 Aug 2006 17:55:1)
DTS phun...
(3 Aug 2006 16:41:41)
SQL qry to find recently modified objects
(3 Aug 2006 9:19:32)
extracting a range from a zipcode field in a customer database
(3 Aug 2006 1:31:7)
Report definition
(3 Aug 2006 1:29:27)
SQL Server 2005 High Availability
(3 Aug 2006 1:15:43)
Audit Logout event takes 24 minutes
(2 Aug 2006 19:16:14)
Does anyone out there ...
(2 Aug 2006 18:8:14)
confused about T-log backups
(2 Aug 2006 17:15:52)
How to check password of a user (urgent)
(2 Aug 2006 16:11:43)
Re: [SPAM-4.2]- RE: Trigger syntax
(2 Aug 2006 15:6:55)
Replication error
(2 Aug 2006 15:2:8)
DTS security
(2 Aug 2006 14:59:10)
DB2 Syntax (Help)
(2 Aug 2006 13:38:52)
How To Troubleshoot Timeouts
(2 Aug 2006 13:20:52)
2 dbs with different physical names, but same logical names
(2 Aug 2006 12:45:42)
SQL Server 2005 Reporting Services
(2 Aug 2006 12:44:6)
clustered indices & join question
(2 Aug 2006 12:37:37)
Required SQL Update Query
(2 Aug 2006 5:16:27)
Build a Query
(1 Aug 2006 20:6:6)
permissions to see DB diagrams in EM
(1 Aug 2006 18:59:6)
User Table selection
(1 Aug 2006 18:16:9)
why are 2 tables so much bigger?
(1 Aug 2006 16:18:3)
sql server 200 session limitation?
(1 Aug 2006 15:56:40)
Triggers and Transactions
(1 Aug 2006 12:20:48)
interview questions
(1 Aug 2006 10:30:24)
Trigger for two tables
(1 Aug 2006 5:10:33)
sql lazydba home page