MS Sql Server

March 2007

LISTOWNER- EMAIL SHIELDING
(31 Mar 2007 14:0:2)
Differnece between Commit and Checkpoint
(31 Mar 2007 13:52:4)
Transaction Log filling very fast
(31 Mar 2007 13:3:19)
SQL Server Error Help Needed
(30 Mar 2007 18:25:49)
Next Number - Urgent
(30 Mar 2007 18:18:58)
Max Memory in SQL 2005
(30 Mar 2007 15:36:57)
data warehousing
(30 Mar 2007 10:47:9)
Restore options
(30 Mar 2007 10:43:30)
Cursor Issue
(30 Mar 2007 10:27:52)
Oracle10g Standard Edition Vs Standard Edition One
(30 Mar 2007 7:22:33)
shut down and restart
(30 Mar 2007 6:18:11)
site slow
(29 Mar 2007 22:45:12)
Replication Security
(29 Mar 2007 21:54:4)
View Recompile Script
(29 Mar 2007 21:47:37)
Removing 'BUILTIN\Administrators'
(29 Mar 2007 19:46:27)
Model database usage & recovery planning
(29 Mar 2007 19:26:13)
SQL 2005 Log Shipping
(29 Mar 2007 14:19:41)
Referential integrity
(29 Mar 2007 9:29:15)
Active directory Security Groups
(28 Mar 2007 22:47:26)
best practive TSQL question
(28 Mar 2007 22:32:11)
Indexing and DTS
(28 Mar 2007 20:43:53)
Exporting Data
(28 Mar 2007 19:34:10)
Passing a variable within an in statement
(28 Mar 2007 15:55:24)
t logs
(28 Mar 2007 13:11:16)
Log Shipping using SQL 2000 SP3a
(28 Mar 2007 13:0:52)
Identity_insert
(28 Mar 2007 12:57:20)
Passive node not seeing quorum drive
(27 Mar 2007 21:34:38)
How can this be?
(27 Mar 2007 20:14:47)
'dbo' problems - HELP
(27 Mar 2007 19:37:52)
Transaction Log
(27 Mar 2007 18:51:35)
Issues connecting to local server -Timeout expired
(27 Mar 2007 18:19:21)
shrink tables?
(27 Mar 2007 17:59:0)
Different response time same query different logins
(27 Mar 2007 17:13:47)
sysusers
(27 Mar 2007 17:0:51)
OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
(27 Mar 2007 16:35:47)
obtain the windows global group
(27 Mar 2007 15:57:32)
Log Shipping SQL 2000 Standard
(27 Mar 2007 15:10:6)
replication acting weird
(27 Mar 2007 15:2:56)
Output results to a file.
(27 Mar 2007 13:51:32)
Error in SQL log
(27 Mar 2007 13:31:29)
SQL Server Connection - SQL 2000
(27 Mar 2007 13:26:7)
Query
(27 Mar 2007 13:17:18)
Query Group by
(27 Mar 2007 7:18:50)
Query - Group by
(27 Mar 2007 6:49:19)
Excel To SQL 7.0
(27 Mar 2007 6:15:39)
working User defined data types
(27 Mar 2007 5:7:39)
SQL 2000 w/ 2005
(27 Mar 2007 4:45:30)
Re: How to "script out" SQL2000 logins and roles
(26 Mar 2007 19:0:25)
Bulk Insert Error
(26 Mar 2007 17:33:40)
local host on startup
(26 Mar 2007 16:56:36)
not exist
(26 Mar 2007 16:45:27)
Hierarchy of lock
(26 Mar 2007 16:37:10)
accessing oracle from sql server
(26 Mar 2007 16:31:13)
Checking last database use (2000)
(26 Mar 2007 16:15:44)
Re: Checking last database use (2000)[Scanned]
(26 Mar 2007 15:33:24)
Need one help
(26 Mar 2007 15:3:40)
how to read transaction log
(23 Mar 2007 21:24:23)
need help with db mail problems
(23 Mar 2007 19:29:37)
Does anyknow know...
(23 Mar 2007 19:6:6)
Re: Replication - adding columns to a table - followup
(23 Mar 2007 18:21:0)
ORDER BY error
(23 Mar 2007 16:43:4)
Script to change Agent logon password?
(23 Mar 2007 16:4:14)
SQLServerAgent: help!
(23 Mar 2007 15:51:50)
Replication - adding columns to a table
(23 Mar 2007 13:8:59)
Stored Procdedure and SQL Job
(23 Mar 2007 12:40:12)
Re: How to "script out" SQL2000 logins and roles?[Scanned]
(23 Mar 2007 12:29:43)
How to "script out" SQL2000 logins and roles?
(23 Mar 2007 11:45:58)
SQL 2000 Reports of Users by DB, and DBs by Users
(23 Mar 2007 9:24:57)
Re: Log Shipping setup question - SQL Server 2000[Scanned]
(23 Mar 2007 1:39:13)
SQL Mail Agent
(22 Mar 2007 22:41:20)
Microsoft Office SharePoint 2007
(22 Mar 2007 22:3:28)
bcp inquiry
(22 Mar 2007 21:34:59)
Virtual Servers
(22 Mar 2007 21:12:14)
Clustering woes...
(22 Mar 2007 20:58:13)
Best way to script this sp
(22 Mar 2007 20:38:57)
logs
(22 Mar 2007 20:4:16)
bcp bulk insert anomoly
(22 Mar 2007 19:41:5)
retro question : Can I connect to MSDE (v7) via SQL2K Ent Mgr?
(22 Mar 2007 18:55:9)
I/O error 23(Data error (cyclic redundancy check).)
(22 Mar 2007 16:49:34)
How to change 100 views to point at different database
(22 Mar 2007 16:30:5)
Log Shipping setup question - SQL Server 2000
(22 Mar 2007 15:42:20)
How to set Cost Threshold for Parallelism
(22 Mar 2007 15:28:21)
dbo.xp_delete_file
(22 Mar 2007 15:16:36)
Migration: Executing scripts of SQL2000 DTS packages in SQL2005
(22 Mar 2007 13:40:9)
SQL 2005 sys.columns / syscolumns ?
(22 Mar 2007 11:56:33)
Log Shipping and Permissions
(22 Mar 2007 11:52:21)
Continuous Transactional Replication in SQL 2000 Environment
(22 Mar 2007 11:34:41)
using BCP to replicate staging and dev environments
(21 Mar 2007 22:57:29)
Joining 2 tables
(21 Mar 2007 22:33:20)
Re: [BULK] How to change 100 views to point at different database
(21 Mar 2007 20:41:27)
SQL2005 backup cleanup
(21 Mar 2007 16:59:1)
Re: How do I re-insert user dbo? - fixed
(21 Mar 2007 16:32:59)
How do I re-insert user dbo?
(21 Mar 2007 15:37:5)
How many files should TEMPDB has to improve performance
(21 Mar 2007 15:26:11)
A query with a view
(21 Mar 2007 14:32:57)
Linked server problem
(21 Mar 2007 14:27:47)
Database Design
(21 Mar 2007 12:1:49)
Linked Server to Access stopped working
(21 Mar 2007 11:59:16)
sysjobhistory resize
(21 Mar 2007 11:44:33)
Performance Analysis TSQL
(20 Mar 2007 22:29:6)
DTS jobs
(20 Mar 2007 22:17:32)
Index Tuning Wizard
(20 Mar 2007 21:5:55)
SQL2000 vs 2005 (why upgrade)?
(20 Mar 2007 20:17:10)
2005 User report showing permissiona
(20 Mar 2007 19:40:39)
Users and permissions
(20 Mar 2007 18:22:31)
SQL Error 21776 'dbo' not found in users collection - help
(20 Mar 2007 17:19:2)
Sychronisation of Jobs - Help Please
(20 Mar 2007 16:1:6)
Steps under a Jobs to be under transaction
(20 Mar 2007 15:21:26)
sql 2005 roles
(20 Mar 2007 14:16:24)
sql 2005
(20 Mar 2007 13:40:35)
Failover Clustering Setup for SQL Server 2000 SP4 on Windows 2003 Enterprise Edition
(20 Mar 2007 12:21:58)
Order by
(20 Mar 2007 5:52:48)
Looking at past performance
(20 Mar 2007 5:10:35)
Voilaion of unique key error (urgent pls)
(20 Mar 2007 4:44:3)
deadlock issues
(19 Mar 2007 18:18:29)
SPID!
(19 Mar 2007 15:31:0)
replication - adding article
(19 Mar 2007 13:45:45)
Inserted Scan
(19 Mar 2007 10:57:21)
.ldf log file shrink
(16 Mar 2007 19:59:22)
Connecting To A Database on SQLServer 2005 *EXPRESS*
(16 Mar 2007 19:32:55)
How to migrate the DB@ onto Sql server
(16 Mar 2007 17:44:7)
Delete from table
(16 Mar 2007 16:36:27)
Query Plan Question (index hints)
(16 Mar 2007 16:15:3)
Install SQL 2000 on Window 2003 64 bits AMD
(16 Mar 2007 16:13:26)
trans repl question
(16 Mar 2007 15:52:32)
Server Build
(16 Mar 2007 15:8:48)
Is it advisable to add trigger in highly transactional and big table
(16 Mar 2007 14:52:19)
differences on how TLOG backups behave
(16 Mar 2007 14:28:45)
SQL Server Reporting Services help needed!
(16 Mar 2007 5:25:59)
DTS Job problem...
(16 Mar 2007 5:21:50)
Reporting Services Guru's (SQL Server 2000)
(16 Mar 2007 5:18:13)
Is Advisable to Add Trigger in Big Tables
(15 Mar 2007 21:47:58)
SQL Server 2005 Installation
(15 Mar 2007 21:31:21)
Re: update
(15 Mar 2007 21:7:21)
finding rererences in UDFs
(15 Mar 2007 20:16:15)
Re: finding references in UDFs
(15 Mar 2007 20:11:10)
Question regarding temptables
(15 Mar 2007 19:57:58)
Determinining Primary key programatically.
(15 Mar 2007 19:49:54)
Determine start and end dates for series of events.
(15 Mar 2007 18:40:32)
SQL 2000 SP3a
(15 Mar 2007 18:18:27)
System databases in SQL Server 2005
(15 Mar 2007 18:17:55)
Exclusive access to only one view
(15 Mar 2007 16:28:1)
Update Statement: Correct Format
(15 Mar 2007 16:18:41)
Update Statement
(15 Mar 2007 16:16:49)
SQL Server 2000 Name Instance - Urgent
(15 Mar 2007 15:50:5)
Re: Pass data from SQL query into a sp_
(15 Mar 2007 15:5:45)
Easy One
(15 Mar 2007 15:3:42)
Deadlock victim Report (Trace flag)
(15 Mar 2007 14:57:36)
MS Access to SQL Server 2005 Conversion
(15 Mar 2007 13:15:10)
Help on Audit Level Queries
(15 Mar 2007 12:25:0)
Deleting temporary indexes
(15 Mar 2007 12:23:40)
getting control of SQL code
(15 Mar 2007 11:4:54)
replication, from a backup
(15 Mar 2007 11:0:20)
SQL 2005 Maint. Plan Problem
(15 Mar 2007 9:59:3)
Re: getting control of SQL code[Scanned]
(14 Mar 2007 19:35:25)
2005 AUTHENT PROBLM
(14 Mar 2007 18:34:1)
Change TCP\IP and Name Pipes Language Settings
(14 Mar 2007 16:59:29)
dictionary
(14 Mar 2007 15:42:14)
Indexing TempDB
(14 Mar 2007 15:15:29)
Change the login name for dbo
(14 Mar 2007 14:38:12)
BRIO Tool.
(14 Mar 2007 12:41:17)
Problem with VB
(14 Mar 2007 11:41:24)
Re: Help Archiving sql 2000 DB
(14 Mar 2007 10:34:17)
In search of slow query help
(14 Mar 2007 8:57:50)
INFORMATION_SCHEMA Catalogs
(13 Mar 2007 19:28:56)
Pass data from a view into a sp_
(13 Mar 2007 19:13:41)
SQL Server 2005 - Disable NUMA?
(13 Mar 2007 19:7:40)
Help with unzipping a .gz archive
(13 Mar 2007 19:1:33)
Huh?
(13 Mar 2007 18:47:34)
Index Tuning Wizard for SQL Server 2000
(13 Mar 2007 17:48:25)
SQL SERVER 2005 Linked to 2000 Cluster
(13 Mar 2007 16:32:0)
Error while installing MSSQL 2005 cluster
(13 Mar 2007 16:9:23)
Clustering on blades (2005)
(13 Mar 2007 16:1:38)
Shape of a (UN) pivot table
(13 Mar 2007 14:21:29)
Cannot generate SSPI Content error - SQL Server 2000
(13 Mar 2007 13:51:29)
SQL Server 2000 Block Analysis
(13 Mar 2007 13:46:45)
Can we upgrade sqlexpress to sql enterprise?
(13 Mar 2007 13:29:26)
force order in cursor
(13 Mar 2007 13:17:33)
SQL2005 sp2 experiences
(13 Mar 2007 13:10:39)
Could not continue scan with NOLOCK due to data movement
(13 Mar 2007 12:33:25)
Help Ftping files via 2005
(13 Mar 2007 12:10:27)
Clustering SQL Server 2005
(13 Mar 2007 11:53:17)
SQL Server 2005 SP1
(13 Mar 2007 9:3:56)
Transaction log file created in wrong place
(13 Mar 2007 3:59:8)
Connection timeout in SQlExpress edition
(13 Mar 2007 1:25:59)
Re: Help Ftping files via 2005[Scanned]
(13 Mar 2007 1:19:8)
User defined type in table variable
(12 Mar 2007 20:53:56)
SQL 2005 SP1
(12 Mar 2007 18:13:49)
SPid block itself
(12 Mar 2007 14:11:40)
How to convert a Index Scan to Index Seek
(12 Mar 2007 13:29:48)
Copy DTS Packages and Database without data
(12 Mar 2007 11:47:0)
Re: Copy DTS Packages and Database without data[Scanned]
(12 Mar 2007 10:1:3)
UNION AND UNION ALL
(12 Mar 2007 4:7:17)
Timeouts
(11 Mar 2007 3:56:44)
Revised _ Shrinking data file and transaction log file growth
(9 Mar 2007 22:49:32)
Unrestricted Growth Log file
(9 Mar 2007 15:28:1)
SQL2005 sp2 Maintenance plans failing
(9 Mar 2007 13:4:21)
Can SQL Reporting 2005 write to a WebDAV sharepoint?
(9 Mar 2007 12:41:42)
server roles
(8 Mar 2007 23:20:59)
SQL Server connection from Oracle
(8 Mar 2007 22:30:5)
ASP .NET Question
(8 Mar 2007 22:22:11)
2005 Bulk Insert Network share
(8 Mar 2007 19:33:57)
Re: Move data and Logs to D[Scanned]
(8 Mar 2007 18:13:48)
Re: ***SPAM*** score: 4.7 SQL2005 sp2 Maintenance plans failing
(8 Mar 2007 18:7:52)
Re: ***SPAM*** score: 4.3 ***SPAM*** score: 4.3 Re: How much should I run sp_msdistribution_cleanup.
(8 Mar 2007 17:59:27)
Database in transition
(8 Mar 2007 17:53:46)
Move data and Logs to D
(8 Mar 2007 17:17:57)
Advanced Windowing Extensions AWE
(8 Mar 2007 16:34:49)
SQL Server 2000 Maint. Plan Reporting
(8 Mar 2007 15:18:12)
What's the Best way to connect to SQL Server from Linux
(8 Mar 2007 13:48:2)
SQL Server 2005 (Some System Views and Functions)
(8 Mar 2007 13:44:48)
DBCC CHECKDB Errors
(8 Mar 2007 13:40:11)
Help on a Switchboard in Microsoft Access 2003
(8 Mar 2007 13:23:36)
How much should I run sp_msdistribution_cleanup.
(8 Mar 2007 13:22:20)
Merge in SQL Server 2005
(8 Mar 2007 13:21:15)
Log shipping
(8 Mar 2007 12:53:3)
Table Scans in 2005
(8 Mar 2007 12:13:3)
Template change in c2 audit
(8 Mar 2007 10:59:55)
Any query out there to find out blocking
(8 Mar 2007 9:21:17)
Which format of stored proc is better ( .prc or .sql)??? CAROL GREEN PLZ HELP !!!
(8 Mar 2007 7:43:35)
Programmatically Changing Service Password
(7 Mar 2007 23:13:19)
Shrinking data file and transaction log file growth
(7 Mar 2007 22:15:15)
Help w/ backup message
(7 Mar 2007 18:27:34)
Ecommerce
(7 Mar 2007 17:6:39)
Help Urgent SSIS package problem
(7 Mar 2007 16:45:44)
View jobs permissions for SQL 2005
(7 Mar 2007 15:26:59)
Problem with Index tuning wizard
(7 Mar 2007 8:58:19)
Help:SQL Server 2005 Windows Auth.
(6 Mar 2007 18:2:7)
SQL REPORTING SERVICES
(6 Mar 2007 17:54:53)
Email Accounts
(6 Mar 2007 17:0:49)
Logins
(6 Mar 2007 16:42:15)
changing user IDs
(6 Mar 2007 16:18:51)
How to Update system tables in SQL Server 2005
(6 Mar 2007 15:20:47)
My SQL Server is 'starting' for a very-very long time
(6 Mar 2007 14:23:11)
Very Large data files HELP??
(6 Mar 2007 9:6:55)
URGENT !! DST fix for SQL Server
(5 Mar 2007 22:45:5)
problem resolved - Thanks! RE: I want to break up a path and load each part into a temp table - what am I doing wrong?
(5 Mar 2007 19:41:45)
I want to break up a path and load each part into a temp table - what am I doing wrong?
(5 Mar 2007 18:54:6)
Unusual Errors Fixed by Recreating Table and Reloading data
(5 Mar 2007 17:15:24)
Unusual Insert Behavior
(5 Mar 2007 16:22:44)
Bii Utility Version V1.0-1 for SQL Server 2000
(5 Mar 2007 15:40:30)
Migration to SQL Server 2005
(5 Mar 2007 14:6:18)
SUBSTRING
(3 Mar 2007 0:40:20)
Crossdb Perf Question
(2 Mar 2007 22:2:59)
Re: [Spam] I am unable to bcp using fixed format file
(2 Mar 2007 21:59:6)
Linked server error
(2 Mar 2007 19:5:25)
sql 2000 to 2005 performance data
(2 Mar 2007 18:41:2)
Re: xp_cmdshell and permission
(2 Mar 2007 17:51:58)
Job failed
(2 Mar 2007 15:54:32)
Getting all subscriptions from a publication
(2 Mar 2007 15:50:0)
DBCC SQLPERF(LOGSPACE)
(2 Mar 2007 15:34:33)
MAXDOP option....
(2 Mar 2007 13:16:24)
DB Tracker
(2 Mar 2007 12:0:59)
help on query.
(2 Mar 2007 7:43:54)
Query Analyzer
(2 Mar 2007 7:36:13)
Call msdb job from a stored procedure
(1 Mar 2007 19:30:12)
Multiple "starting up Database entries in MS SQL 2000
(1 Mar 2007 17:52:38)
Login problem
(1 Mar 2007 17:44:59)
DST changes for SQL SERVER 7
(1 Mar 2007 17:39:52)
SQL 2000 DTS - Newbie question
(1 Mar 2007 17:37:35)
xp_cmdshell and permissions
(1 Mar 2007 17:16:59)
Transaction Replication Question
(1 Mar 2007 16:57:38)
Access97 question
(1 Mar 2007 15:30:3)
Permission a User or Role to all stored procs in a database
(1 Mar 2007 9:57:7)
Table variable as output parameter?
(1 Mar 2007 8:34:47)
xml import urgent help
(1 Mar 2007 8:28:0)
sql lazydba home page