MS Sql Server

June 2006

Error during configuring distribution wizard
(30 Jun 2006 23:2:17)
Error in SQLAGENT output !!!
(30 Jun 2006 22:45:48)
INTERSECT?
(30 Jun 2006 21:20:54)
Report Manager Subscription Failed
(30 Jun 2006 21:6:19)
Anyone know how to transfer SQL 2000 jobs to SQL 2005 ?
(30 Jun 2006 20:37:56)
Error 823
(30 Jun 2006 20:6:33)
non-aggregate error when indexing view
(30 Jun 2006 17:45:21)
SQLServer Performance ...
(30 Jun 2006 17:34:3)
Database Mail
(30 Jun 2006 17:31:6)
automated stopping and restarting of sql services in 2000.
(30 Jun 2006 17:21:38)
[SQLSTATE 42000] (Error 22029)
(30 Jun 2006 13:6:42)
Want to shrink !!!
(29 Jun 2006 22:43:8)
Object Owner
(29 Jun 2006 20:7:50)
Restoring Master
(29 Jun 2006 17:48:52)
Re: [SPAM-3.1]- RE: Want to shrink !!!
(29 Jun 2006 17:24:54)
Transaction Replication
(29 Jun 2006 17:24:25)
Re: SPAM-LOW: RE: Want to shrink !!!
(29 Jun 2006 16:59:3)
Table Locked... (Releasing a locked table??)
(29 Jun 2006 16:5:25)
Degrading database performance !!!!
(29 Jun 2006 16:2:59)
SQL MAIL through SMTP
(29 Jun 2006 14:40:11)
MS DTC not work
(29 Jun 2006 14:16:6)
Opinions (and I know you have 'em)
(29 Jun 2006 14:16:0)
view transaction log data
(29 Jun 2006 14:12:31)
New Microssoft certification resources
(29 Jun 2006 9:4:46)
index on datetime column
(29 Jun 2006 7:35:9)
Linked server error
(28 Jun 2006 22:19:38)
Reduce the initial sizes !!!
(28 Jun 2006 22:12:28)
Database shrinking
(28 Jun 2006 20:32:21)
Memory usage and management
(28 Jun 2006 19:51:6)
Urgency: Primary filegroup is FULL !!
(28 Jun 2006 19:48:24)
Waiting for some answers !!
(28 Jun 2006 18:1:25)
Best Way to Deliver a DTS Package
(28 Jun 2006 17:17:29)
xp_sendemail
(28 Jun 2006 17:12:36)
How to run file in SQL server
(28 Jun 2006 15:34:3)
Primary filegroup ?? (urgent)
(28 Jun 2006 15:28:11)
Russian character column on UK server
(28 Jun 2006 14:47:2)
DTS package templates
(28 Jun 2006 14:4:29)
2 Million Records, Duplicate and SubString Removal
(28 Jun 2006 12:41:10)
Monitoring Activities
(28 Jun 2006 11:54:24)
nested jobs
(28 Jun 2006 10:10:56)
is it possilbe in excel.
(28 Jun 2006 8:45:30)
Jobs run after one completed
(28 Jun 2006 8:27:56)
Re: Log File
(28 Jun 2006 0:1:28)
SQL 2005 Report Server
(27 Jun 2006 23:21:30)
SQL Server keeps aborting
(27 Jun 2006 21:10:19)
Wildcard parameter in Stored procedure
(27 Jun 2006 20:7:39)
Recall: xp_sendemail
(27 Jun 2006 16:35:52)
Slow running query
(27 Jun 2006 16:0:47)
how can i make Data Model
(27 Jun 2006 15:18:16)
SQL Server Recovery
(27 Jun 2006 15:17:2)
Urgent for a solution
(27 Jun 2006 15:9:49)
Meaning/responsebility o fL2, L3 & L4 Support
(27 Jun 2006 7:32:16)
Integrated Services Install error
(26 Jun 2006 20:11:20)
Adding a named instance to an existing installation on a cluster
(26 Jun 2006 18:11:0)
SQL Server Datatypes
(26 Jun 2006 15:47:22)
export only column name of the tables.
(26 Jun 2006 15:42:53)
Output on two tables when one table may not have rows
(26 Jun 2006 15:37:17)
Re: Memory usage and management - THANKS ALL
(26 Jun 2006 15:35:14)
automated script for license
(26 Jun 2006 15:5:6)
How to Change the type of constraint
(26 Jun 2006 7:33:28)
public role
(26 Jun 2006 7:33:7)
Concatenate fields of many rows into one row
(25 Jun 2006 20:14:36)
LISTOWNER- EMAIL SHIELDING
(24 Jun 2006 13:0:2)
Joins in more than 3 tables.
(24 Jun 2006 6:45:44)
Import of Excel data seemed OK, however...
(24 Jun 2006 4:34:32)
Data Transfer
(23 Jun 2006 19:57:0)
Easy way to move all indexes to a new file group in SQL 2005
(23 Jun 2006 19:43:30)
SQL.Log
(23 Jun 2006 19:15:30)
ignore errors in job
(23 Jun 2006 18:53:37)
SSIS issue
(23 Jun 2006 18:44:26)
Re: SQL Server 2000 Problems running Stored Procedure
(23 Jun 2006 18:35:2)
altering tables using xml
(23 Jun 2006 18:19:0)
DTS Packages
(23 Jun 2006 16:46:30)
Linked Server failed
(23 Jun 2006 15:13:10)
About LSN
(23 Jun 2006 13:40:15)
database and log defaults
(23 Jun 2006 13:40:11)
SQL Server 2005 cluster install
(23 Jun 2006 13:25:56)
DTS Package move
(23 Jun 2006 8:24:44)
shrink tempdb
(23 Jun 2006 4:9:50)
How do you determine and then validate stored objects in SQL Server 2000
(23 Jun 2006 4:6:8)
Email notification
(23 Jun 2006 1:55:54)
Permissions to do a profile trace
(23 Jun 2006 1:4:37)
Report Server error
(23 Jun 2006 0:19:24)
DTS Transformation Task
(22 Jun 2006 19:10:54)
tsql date functions
(22 Jun 2006 18:1:21)
compare two tables
(22 Jun 2006 17:41:29)
Great Pains
(22 Jun 2006 17:27:17)
Tail-Log Backups - SQL SERVER 2005
(22 Jun 2006 16:23:13)
Database is locked
(22 Jun 2006 15:33:41)
How to set up queray time
(22 Jun 2006 15:0:36)
Finding a step name inside the ActiveX VBScript
(22 Jun 2006 14:56:38)
xp_readmail
(22 Jun 2006 14:26:38)
SQL Server error msg.
(22 Jun 2006 14:6:36)
Log files full and out of disk space.
(22 Jun 2006 13:39:42)
Using DNS entries as ODBC pointers
(22 Jun 2006 7:53:27)
Re: TPN POSSIBLE SPAM:Log files full and out of disk space.
(21 Jun 2006 22:35:9)
Audit trigger code
(21 Jun 2006 21:52:22)
data warehousing
(21 Jun 2006 21:43:13)
Re: ***SPAM*** RE: tsql date functions
(21 Jun 2006 20:55:43)
Using Case
(21 Jun 2006 20:48:38)
INDEXES
(21 Jun 2006 19:25:32)
What could be the problems?
(21 Jun 2006 19:22:1)
Linked Server
(21 Jun 2006 19:7:46)
Using BCP
(21 Jun 2006 18:6:21)
Return 0 if null
(21 Jun 2006 17:18:50)
OPENQUERY to Oracle9i
(21 Jun 2006 15:59:41)
How to go back to the default settings
(21 Jun 2006 15:49:33)
PORTUGAL ;)
(21 Jun 2006 14:25:40)
no.of connections
(21 Jun 2006 14:7:45)
SQL Server 2005 Books
(21 Jun 2006 13:43:39)
SQL slow down....
(21 Jun 2006 13:41:36)
SQL Server 2005 (New function: View available permissions)
(21 Jun 2006 12:9:18)
Re: [BULK] RE: Dell vs HP
(20 Jun 2006 22:35:56)
alter table
(20 Jun 2006 20:34:6)
Joining mysteries
(20 Jun 2006 20:19:58)
Too Much XML ?
(20 Jun 2006 19:55:19)
SQL 2005 SSIS issue
(20 Jun 2006 19:54:48)
Restore MSDE database question
(20 Jun 2006 19:41:39)
Dell vs HP
(20 Jun 2006 19:23:24)
A security conundrum
(20 Jun 2006 15:49:38)
Challenge of the day
(20 Jun 2006 15:43:23)
Job suddenly stopped working
(20 Jun 2006 15:21:46)
deleting from big table
(20 Jun 2006 15:12:58)
Re: [Spam] public role
(20 Jun 2006 15:1:1)
Re: [***SPAM*** Score/Req: 4.5/3.5] RE: Challenge of the day
(20 Jun 2006 12:5:25)
SQL
(20 Jun 2006 10:36:2)
Maintenance Plans
(20 Jun 2006 7:33:26)
HELP! Upgrading to SQL Server 2000
(19 Jun 2006 17:35:13)
Replication
(19 Jun 2006 15:21:49)
Re: SQL SERVER FAILOVER TOOLS
(19 Jun 2006 15:7:44)
SQL Server 2005 - Renaming Objects
(19 Jun 2006 14:55:20)
BACKUP and TRANSACTION FILES
(19 Jun 2006 12:55:31)
DTS Execute Process Task
(19 Jun 2006 12:28:40)
Connecting to an Oracle Database from SQL
(19 Jun 2006 12:25:42)
Spoolsv.exe
(19 Jun 2006 11:15:36)
SQL Server 2005
(19 Jun 2006 9:51:15)
Documets for the sql server database,security, DR and Backup Policy
(17 Jun 2006 15:32:34)
Export users
(16 Jun 2006 19:37:29)
Row size
(16 Jun 2006 19:29:31)
Recycle the services in SQL Server 2000
(16 Jun 2006 18:56:54)
SQL 2000 scheduled task monitoring
(16 Jun 2006 18:9:36)
.NET requirement
(16 Jun 2006 16:48:23)
Differential backup restore
(16 Jun 2006 16:39:22)
sp debuging rights
(16 Jun 2006 16:25:46)
Export
(16 Jun 2006 15:34:42)
Search and replace text on al tables...never mind
(16 Jun 2006 14:33:21)
Re: [Spam] Errors encountered during save process...
(16 Jun 2006 14:0:13)
Search and replace text on al tables...
(16 Jun 2006 13:58:47)
xp_loginconfig
(16 Jun 2006 13:58:7)
SQL 2005 clustering
(16 Jun 2006 13:40:52)
List History
(16 Jun 2006 13:27:0)
SQL Server 2000 Enterprise Edition Evaluation Software
(16 Jun 2006 11:42:44)
Backup of DB on two drive.
(16 Jun 2006 11:24:42)
today is my Friday
(16 Jun 2006 9:50:41)
Log Shipping failures
(16 Jun 2006 0:28:10)
Server 'server name' is not configured for DATA ACCESS
(15 Jun 2006 19:33:51)
Error Source: Microsoft OLE DB Provider for SQL Server
(15 Jun 2006 16:14:21)
Upgrading SQL Server 2000
(15 Jun 2006 12:12:7)
Views in SQL 2005
(14 Jun 2006 23:55:26)
Memory
(14 Jun 2006 18:6:57)
Creating Excel Worksheets
(14 Jun 2006 18:2:40)
Recovery Model T-SQL
(14 Jun 2006 17:9:4)
Force User to Change Password
(14 Jun 2006 15:53:36)
DTS ActiveX problems
(14 Jun 2006 15:35:1)
Errors encountered during save process...
(14 Jun 2006 15:9:32)
SQL 2005 Activity Monitor
(14 Jun 2006 14:34:45)
Point in Time Recovery
(14 Jun 2006 13:0:16)
How to look up service account of an SQL2005 instance
(14 Jun 2006 2:43:45)
Using the same field in two instances in query
(13 Jun 2006 18:58:39)
Re: ***SPAM*** RE: Using the same field in two instances in query
(13 Jun 2006 17:3:43)
Design Question
(13 Jun 2006 14:57:59)
SQL Server 2000 Log Shipping Error 14261
(12 Jun 2006 19:48:52)
Trusted Security and NULL SUSER_SNAME(SID) values
(12 Jun 2006 18:49:43)
Exporting Queries to Excel
(12 Jun 2006 18:18:10)
trans log backup locked
(12 Jun 2006 18:4:28)
problem with a where clause
(12 Jun 2006 17:35:2)
SQL 2005 Link Server to Pervasive SQL v8.6
(12 Jun 2006 16:10:2)
How to import data from excel
(12 Jun 2006 15:54:44)
Recommended Books on 2005 Integration Services?
(12 Jun 2006 15:42:58)
System vs. User SP's
(12 Jun 2006 15:22:11)
rebbrui.rll is missing
(12 Jun 2006 15:9:39)
Support Logix server
(12 Jun 2006 13:54:22)
DTS question
(12 Jun 2006 12:29:22)
Strange DTS behaviour
(11 Jun 2006 8:28:22)
Re: [ ] - Could not find stored procedure 'sp_MSins_tablename' - Number of numbers in MIME From exceeds maximum threshold
(10 Jun 2006 12:37:53)
Could not find stored procedure 'sp_MSins_tablename'
(10 Jun 2006 12:32:30)
Dollar Sign in MSSQL Directory name
(9 Jun 2006 22:0:31)
DTS problem
(9 Jun 2006 19:13:23)
Creating a Linked Server Connection to SalesLogix
(9 Jun 2006 18:50:35)
Anybody else use...
(9 Jun 2006 14:6:9)
Not able to configure Publisher(Trans Repl) on tables with no primary keys
(9 Jun 2006 13:38:15)
More Trouble with UNIONs
(9 Jun 2006 12:43:7)
Error Syntax Error Or Access violation
(9 Jun 2006 7:33:23)
How to transfre the table size 16 GB from one location to other.
(9 Jun 2006 6:24:21)
SQL Server Backup and restore
(9 Jun 2006 5:56:10)
Re: ***SPAM*** Trouble with UNIONs
(9 Jun 2006 5:9:43)
Trouble with UNIONs
(8 Jun 2006 21:25:58)
dymanic SQL
(8 Jun 2006 21:7:26)
Backup with retaindays=n
(8 Jun 2006 20:32:3)
Msg 4928:Cannot alter column 'addr1' because it is 'REPLICATED'
(8 Jun 2006 19:46:49)
Solution Explorer in Management Studio
(8 Jun 2006 19:6:40)
SQL 2005 schema migration
(8 Jun 2006 18:57:36)
MS SQL Server 7 e-book...
(8 Jun 2006 16:23:27)
rounding problem
(8 Jun 2006 15:24:38)
how to get DTS to skip an error
(8 Jun 2006 15:10:53)
UNIX Script for DBA Tasks
(8 Jun 2006 15:4:13)
Long IN clause
(8 Jun 2006 14:38:58)
A ver not so smart question
(8 Jun 2006 14:18:4)
Incorrect syntax
(8 Jun 2006 12:36:58)
interesting interview with Amazon guy
(7 Jun 2006 23:32:25)
How to Convert Oracle Database 9 to SQL Server 2000
(7 Jun 2006 20:49:23)
Tivoli Node configurations/settings
(7 Jun 2006 20:40:15)
Index in Table.
(7 Jun 2006 20:19:19)
SQL Server STATS
(7 Jun 2006 19:26:57)
Server Error Messages
(7 Jun 2006 18:51:43)
Other job openings I know of ...
(7 Jun 2006 18:27:1)
why is this logic wrong?
(7 Jun 2006 18:8:30)
Another sql dba job lead ...
(7 Jun 2006 17:24:15)
Looking for DataWarehouse consultants in the SoCal area...
(7 Jun 2006 17:10:35)
invalid date
(7 Jun 2006 16:45:4)
Pro SQL Server 2005
(7 Jun 2006 16:28:56)
BCP Format file
(7 Jun 2006 16:8:36)
Re: ***SPAM*** BCP Format file
(7 Jun 2006 15:40:5)
DTS
(7 Jun 2006 15:31:32)
Finding DTS name inside the ActiveX VBScript
(7 Jun 2006 15:2:42)
No Begin Transaction on Replication
(7 Jun 2006 14:3:19)
Linked Servers and DB2Connect
(7 Jun 2006 13:35:49)
What am I doing wrong?
(7 Jun 2006 13:30:53)
proc_exec/time_evt/xpsqlbot.dll/xpstar.dll
(7 Jun 2006 13:13:33)
Auto Growth
(7 Jun 2006 12:49:8)
Replication (again)
(7 Jun 2006 12:12:27)
DBO mapped to incorrect Login Name
(6 Jun 2006 20:26:29)
Just curious what you guys have to say ...
(6 Jun 2006 20:14:48)
Losing Records
(6 Jun 2006 19:29:4)
spid blocking itself
(6 Jun 2006 19:17:44)
Help! Red-Gate Backup
(6 Jun 2006 18:44:42)
Code to break down billing dates
(6 Jun 2006 18:26:16)
Turn off Temp Stored Procedures
(6 Jun 2006 17:40:34)
Re: sp_changedbowner question
(6 Jun 2006 17:40:26)
The pageaudit property is incorrect
(6 Jun 2006 16:27:22)
BCP formatting
(6 Jun 2006 15:35:3)
Error 22022
(6 Jun 2006 15:30:21)
Retrieving metadata information from SQL
(6 Jun 2006 15:27:28)
SQL agents jobs
(6 Jun 2006 10:58:46)
Re: SQL Server DBA/.NET
(6 Jun 2006 8:5:18)
SQL Server DBA/.NET Position
(6 Jun 2006 5:53:10)
Where are SSIS packages saved in 2005
(6 Jun 2006 4:53:32)
DTS package connecting to Oracle
(5 Jun 2006 23:4:6)
Log shipping
(5 Jun 2006 22:21:25)
How to echo the sql statement
(5 Jun 2006 19:7:48)
PosGres
(5 Jun 2006 18:50:17)
SSIS execution
(5 Jun 2006 18:33:11)
Linked Server is Oracle V.
(5 Jun 2006 18:29:45)
SQL Sentry
(5 Jun 2006 17:8:45)
How to skip a column in BCP
(5 Jun 2006 16:40:56)
dumb question
(5 Jun 2006 14:44:12)
DTS Error
(5 Jun 2006 13:45:45)
Need Help : TIMESTAMP
(5 Jun 2006 3:33:53)
How to Restore MSSQL ".bak " to SQL
(4 Jun 2006 16:42:19)
Time Function....
(4 Jun 2006 16:38:56)
On the subject of simple questions
(2 Jun 2006 22:51:23)
Check whether an Exchange email account exists
(2 Jun 2006 20:37:14)
translating an oracle simple oracle script.
(2 Jun 2006 20:32:52)
DTS syscall failure
(2 Jun 2006 19:42:51)
More DB2 scripting help please
(2 Jun 2006 18:33:51)
Compressing SQL Server (2000) backup files
(2 Jun 2006 18:15:42)
Bizarre error
(2 Jun 2006 16:58:49)
SQL Profiler
(2 Jun 2006 16:52:54)
Fixed widths
(2 Jun 2006 16:3:1)
Money vs. Decimal Data Type
(2 Jun 2006 15:17:12)
Indexing Views on Standard edition?
(2 Jun 2006 15:1:25)
Protecting Databases
(2 Jun 2006 12:34:40)
DBCC CLEANTABLE
(2 Jun 2006 12:1:31)
sysxlogin vs. syslogin
(2 Jun 2006 11:18:28)
Proactive Cahing in Analysis Services 2005 - MDX queries get stuck while partition is processed
(2 Jun 2006 10:57:14)
Job stopping user access
(2 Jun 2006 9:9:42)
Configuring an Oracle Publisher in SQL 2K5
(1 Jun 2006 23:46:15)
Another Simple Question
(1 Jun 2006 22:53:5)
ADP HRMS Autolink
(1 Jun 2006 18:44:9)
Export and Import - My Apologies If I've Offended Anyone
(1 Jun 2006 15:23:21)
LISTOWNER - stop flames and please return to "ontopic"
(1 Jun 2006 15:23:4)
Ingnorance
(1 Jun 2006 15:1:29)
SQL2005 Resources?
(1 Jun 2006 14:46:40)
BOL
(1 Jun 2006 14:45:49)
Linked Servers
(1 Jun 2006 14:36:28)
Permissions Question
(1 Jun 2006 13:7:36)
Error on switch of service logons
(1 Jun 2006 13:7:28)
mail session error
(1 Jun 2006 12:18:27)
MSDE and/or SQL2005 Express
(1 Jun 2006 8:3:14)
Server configuration
(1 Jun 2006 7:26:40)
SQL 2000 and SQL 2005
(1 Jun 2006 6:38:54)
Adding a new login
(1 Jun 2006 0:35:48)
sql lazydba home page