MS Sql Server

April 2005

LISTOWNER- EMAIL SHIELDING
(30 Apr 2005 13:0:18)
Sequential Number Creation
(29 Apr 2005 23:18:29)
How hard is it to FTP using DTS?
(29 Apr 2005 21:11:45)
Restrict access using Enterprise Manager
(29 Apr 2005 16:15:15)
single quote problem
(29 Apr 2005 15:59:35)
Getting TOP 10 from Large Group
(29 Apr 2005 15:40:44)
ISPALUSER
(29 Apr 2005 15:33:44)
MSDE Install root directory
(29 Apr 2005 14:35:24)
Restore to different database name
(29 Apr 2005 14:3:32)
Re: Linked Server Errors
(29 Apr 2005 12:39:59)
system t-log errors out
(29 Apr 2005 12:39:18)
Crystal Reports and SQL
(29 Apr 2005 7:42:34)
Epoch time to SQL datetime conversion
(29 Apr 2005 1:4:7)
DTS Packages & Workflow
(29 Apr 2005 0:6:42)
DTS package local or on server
(28 Apr 2005 23:42:44)
Profiler question
(28 Apr 2005 19:17:57)
SQL Server TransLog Restore from Appended BackupSet
(28 Apr 2005 17:50:14)
SQLActivity Log Files
(28 Apr 2005 16:54:34)
RAISERROR
(28 Apr 2005 16:16:39)
Solution Required
(28 Apr 2005 14:22:31)
Urgent !!
(28 Apr 2005 13:16:32)
DTS editing using VS.NET
(28 Apr 2005 12:47:49)
Capture Statement Passed From Crystal Reports
(28 Apr 2005 12:46:56)
Data & Log File Sizes in SQL Server 2000
(28 Apr 2005 12:31:51)
Rollbacks of selection in query analyser
(28 Apr 2005 12:23:40)
Maintenance Plan error message "'QUOTED_IDENTIFIER, ARITHABORT"
(28 Apr 2005 11:21:34)
SAVED DTS package file with multiple versions
(28 Apr 2005 11:20:35)
SQL Error 615...
(28 Apr 2005 7:11:35)
Drop database
(27 Apr 2005 22:18:43)
Context switching monitoring
(27 Apr 2005 17:27:42)
Prune Old Records
(27 Apr 2005 17:14:0)
Re: Link server: DB2 connect vs Host integration
(27 Apr 2005 14:16:3)
How to configure the Notification for Sql Jobs
(27 Apr 2005 8:23:7)
How will i know that which DTS packages, connection object has se t the sa password ?
(27 Apr 2005 2:7:34)
How do you restore to a new server with different drives?
(26 Apr 2005 20:33:54)
Execution Plan
(26 Apr 2005 20:12:29)
Running DTS pkgs
(26 Apr 2005 15:29:27)
Passing Machine Name / IP address to the trigger
(26 Apr 2005 15:19:46)
DBCC SHOWCONTIG
(26 Apr 2005 13:45:12)
Merge Replication - Your Inputs Needed
(26 Apr 2005 12:34:10)
command to find out the current sql server version??
(26 Apr 2005 11:31:38)
Why DTS?
(25 Apr 2005 22:49:39)
LTRIM, RTRIM, REPLACE?
(25 Apr 2005 20:7:50)
ODBC connections
(25 Apr 2005 16:11:48)
Stored Procedure Problem
(25 Apr 2005 16:7:52)
Re: SQL Server stored procedure errors
(25 Apr 2005 15:55:23)
Microsoft SQl 2000 32 Bit versus 64 Bit
(25 Apr 2005 15:50:31)
and where
(25 Apr 2005 15:31:3)
How to determine first business day of month
(25 Apr 2005 15:30:19)
How a stored procedure differs from an open session of query analyser
(25 Apr 2005 15:12:29)
How do you shrink Log file???
(25 Apr 2005 12:19:9)
job which will run once a perticular day.
(25 Apr 2005 10:24:1)
Re: [ASSP SPAM] RE: Query Output to Email Message
(24 Apr 2005 2:31:49)
Killed but still running
(23 Apr 2005 19:14:45)
SQL Server memory tunning
(22 Apr 2005 18:38:11)
How to monitor a job.. Need to know what is doing
(22 Apr 2005 17:55:38)
Query Output to Email Message
(22 Apr 2005 16:32:47)
Query timeout
(22 Apr 2005 16:32:38)
Sysobjects at Server Level
(22 Apr 2005 15:29:39)
Difference between Differential backup file and full backup file
(22 Apr 2005 7:49:51)
LOG SHIPPING MONITORING SERVER
(22 Apr 2005 7:47:33)
Database Comparison
(22 Apr 2005 7:43:52)
Re: Invisible table info
(22 Apr 2005 1:0:10)
SQL Tips and Tricks
(21 Apr 2005 19:41:30)
SQL Compare Software
(21 Apr 2005 19:25:0)
Job disabled
(21 Apr 2005 18:7:43)
Two query analyzer questions:Trace on Query analyzer grayed out, and sp debug tools greyed out
(21 Apr 2005 17:52:58)
How to tell a statistic from an index
(21 Apr 2005 15:39:3)
SQL Query Updating All Records instead of only records listed in another table
(21 Apr 2005 15:29:11)
local VarChar Not enough
(21 Apr 2005 15:14:39)
Database Maintenance Plans...
(21 Apr 2005 13:53:24)
SQL-DMO and extended stored procedures ...
(21 Apr 2005 13:10:59)
Starting jobs
(21 Apr 2005 12:53:35)
Web Application - SQL Server 2000 - SqlDataReader Error
(21 Apr 2005 11:31:54)
Table modification date
(21 Apr 2005 10:53:21)
how to get the user previlage from query analyzer
(21 Apr 2005 6:55:3)
Select Random!
(21 Apr 2005 3:24:37)
long running ops
(20 Apr 2005 21:23:22)
index on sql 2000
(20 Apr 2005 20:22:51)
data length in a column.
(20 Apr 2005 15:47:2)
Load Balancing SQL Server
(20 Apr 2005 15:31:21)
three-node load-balancing cluster
(20 Apr 2005 14:58:25)
Permissions needed to view job info/history
(20 Apr 2005 14:8:21)
Re: [RMX:#] RE: local VarChar Not enough
(20 Apr 2005 14:2:35)
Database Access
(20 Apr 2005 14:0:31)
Is there a tempory location where the result of the previous query is stored
(20 Apr 2005 6:54:24)
Refreshing LIVE database
(19 Apr 2005 20:21:0)
Log Shipping Restore SUSPECT Standby
(19 Apr 2005 18:59:38)
computer name
(19 Apr 2005 17:46:16)
OSQL Detach Database
(19 Apr 2005 15:51:23)
Grand Total
(19 Apr 2005 15:40:9)
SQL Scripts by Schedule
(19 Apr 2005 14:4:31)
3rd party monitor...
(19 Apr 2005 8:1:6)
Need help !!!
(19 Apr 2005 6:36:54)
shrink transaction log only
(18 Apr 2005 20:18:52)
Re: Problem with Stored Procedure
(18 Apr 2005 20:3:29)
Sysdatabase trigger?
(18 Apr 2005 18:58:46)
BCP like Results in text
(18 Apr 2005 16:55:50)
database collation
(18 Apr 2005 14:1:28)
Task View
(18 Apr 2005 13:51:13)
Re: Need help on replacing table with added column!
(18 Apr 2005 12:54:48)
At last, the answer to many a shared server admins problems
(18 Apr 2005 11:15:4)
DTS
(17 Apr 2005 22:49:13)
Please Explain!
(17 Apr 2005 22:46:59)
DB monitoring script ...
(16 Apr 2005 10:49:13)
dts transformation
(15 Apr 2005 19:48:18)
Complicated DTS question
(15 Apr 2005 19:0:31)
Script to ftp files onto a remote server
(15 Apr 2005 17:29:32)
Primary key in systables???
(15 Apr 2005 15:26:2)
Need Help !!
(15 Apr 2005 7:0:12)
DTS to import a xls file with number/character mixed column
(14 Apr 2005 22:14:11)
DTS to load xls file with number/character mixed column
(14 Apr 2005 22:5:54)
Moving non-clustered SQL_Server databases to a Cluster Server
(14 Apr 2005 20:18:55)
Re: Last Modified date on SQL SERVER
(14 Apr 2005 18:34:7)
Using NetAPP NAS with iSCSI
(14 Apr 2005 18:8:23)
Grant DB Access different database
(14 Apr 2005 17:46:43)
Moving log file to raid 1
(14 Apr 2005 17:3:13)
DB2 to SQL date conversion
(14 Apr 2005 15:38:10)
Create database with owner other than dbo
(14 Apr 2005 15:20:53)
Log Entries
(14 Apr 2005 15:18:6)
deleting relationships
(14 Apr 2005 13:30:25)
Tell sid to watch it
(14 Apr 2005 11:27:46)
cannot delete job
(14 Apr 2005 9:31:58)
Relocate log files
(14 Apr 2005 0:43:22)
Security ?
(13 Apr 2005 17:29:31)
Moving Logins & database users accross servers
(13 Apr 2005 16:53:50)
Slow SQL after migration
(13 Apr 2005 15:50:49)
Granting exec permissions on xp_cmdshell to non-sysadmin users
(13 Apr 2005 15:28:9)
IDENT_CURRENT does not work for me
(13 Apr 2005 14:6:53)
Selecting a range of rows from a table
(13 Apr 2005 11:50:14)
Device and File Backups
(13 Apr 2005 9:15:22)
How to connect to the remote server from stored procedure and fro m osql utility?
(13 Apr 2005 8:24:33)
SQL Mail
(12 Apr 2005 22:34:50)
Linked Server Rights --
(12 Apr 2005 19:48:23)
Space in field
(12 Apr 2005 13:10:26)
Little function problems
(12 Apr 2005 13:1:33)
Enable Log Readers in Replication Monitor
(12 Apr 2005 12:54:20)
Useful script to check for the database with the most locks
(12 Apr 2005 12:52:1)
backing up my jobs and backup plans
(12 Apr 2005 12:18:16)
Migrating DTS packages
(12 Apr 2005 10:31:44)
Re: Incrementing suffix for unique id - Solution
(12 Apr 2005 7:24:2)
Re: [RMX:##] RE: Space in field
(12 Apr 2005 5:28:44)
error in job schedule
(12 Apr 2005 3:14:22)
Application Log is Full
(11 Apr 2005 18:21:21)
SQL 2000
(11 Apr 2005 16:40:53)
Full Text Index
(11 Apr 2005 15:59:50)
Lots of images
(11 Apr 2005 15:8:36)
Is it possible to start a job from another job?
(11 Apr 2005 15:7:41)
shared memory provider.
(11 Apr 2005 14:49:58)
Cannot resolve collation conflict for equal to operation.
(11 Apr 2005 14:4:0)
easy one - getdate() question
(11 Apr 2005 13:8:36)
Rename MSDE Installed instance
(11 Apr 2005 13:2:49)
How to trace which DTS package was run on the scheduled job
(11 Apr 2005 12:33:55)
Incrementing suffix for unique id
(11 Apr 2005 8:55:17)
Recovery mode stored where?
(11 Apr 2005 7:13:14)
max memory of sql 2000 enterprise verion on win 2003 enterprise server
(11 Apr 2005 3:26:6)
Regarding the max memory supported by sql server 2000 enterprise edition on windows 2003 enterprise edition
(11 Apr 2005 1:50:38)
db backup error on event viewer
(11 Apr 2005 0:45:28)
Which is better?
(9 Apr 2005 17:6:26)
SQL for checking FOREIGN/PRIMARY KEY RELATIONSHIPS/DEPENDENCIES
(9 Apr 2005 15:13:34)
How to get a command output into a variable?
(8 Apr 2005 19:57:58)
Midnight
(8 Apr 2005 19:49:57)
TEMPDB Spiral out of Control
(8 Apr 2005 18:43:32)
Newbie - SQL Server to Oracle Data Insert
(8 Apr 2005 14:2:12)
How to alter a unnamed check constraint
(8 Apr 2005 13:35:18)
SuperSocket info: (SpnRegister) : Error 8235
(8 Apr 2005 13:19:30)
Can a job Export and restore about 8 hours later
(8 Apr 2005 12:34:25)
Strange behaviour in EM while setting up Maintenance plans
(8 Apr 2005 12:28:10)
IDENTITY insert column, where is it?
(8 Apr 2005 10:31:46)
How to relocate the data files
(8 Apr 2005 8:23:34)
help with alter column default
(8 Apr 2005 6:3:35)
how to delete unwanted snapshot agent
(8 Apr 2005 4:53:7)
Backup
(8 Apr 2005 0:7:11)
Windows 2000 hung process help
(8 Apr 2005 0:3:1)
Stop sending the EMails to me
(7 Apr 2005 17:54:4)
Select in SQL Server 2000
(7 Apr 2005 16:9:20)
Re: RAID 1 and RAID 5
(7 Apr 2005 15:47:39)
Detecting unavailable Linked Server
(7 Apr 2005 12:27:13)
CHANGING MAX MEMORY CONFIGURATION ..
(7 Apr 2005 11:41:54)
Renaming a SQLServer instance
(7 Apr 2005 11:12:45)
Insert Statement
(7 Apr 2005 10:55:43)
Help Please
(7 Apr 2005 9:2:8)
Restore
(7 Apr 2005 0:18:15)
should you back up master, model and msdb
(6 Apr 2005 22:5:2)
OPENXML syntax error help
(6 Apr 2005 21:54:7)
Creating SP and Views From Script
(6 Apr 2005 17:41:59)
Cannot Generate SSPI context error
(6 Apr 2005 16:19:20)
Inserting a Field
(6 Apr 2005 15:30:37)
SPANISH and ENGLISH
(6 Apr 2005 15:10:14)
Constraint Names Problem
(6 Apr 2005 12:54:45)
Who did it?
(6 Apr 2005 12:15:20)
PERFORMANCE/LOAD/STRESS EVALUATION SOFTWARE
(6 Apr 2005 11:25:30)
Importing Data with Where condition
(6 Apr 2005 9:40:19)
Log shipping vs. replication
(6 Apr 2005 7:54:12)
Restore from Enterprises to Standard
(6 Apr 2005 5:34:17)
Many Queries
(5 Apr 2005 23:11:16)
Event logging, calling alerts
(5 Apr 2005 18:57:40)
Is transaction completed
(5 Apr 2005 18:10:40)
How to Run This Script Correctly
(5 Apr 2005 16:28:32)
Impact Analysis on DTS Packages
(5 Apr 2005 16:25:34)
Starting up database
(5 Apr 2005 12:46:1)
Transaction isolation levels.
(5 Apr 2005 11:44:36)
Sql 2000 Error
(5 Apr 2005 7:34:59)
triggers using linkedservers
(5 Apr 2005 7:6:57)
Question about running a DOS batch file...
(5 Apr 2005 6:36:5)
Re: Buffer overflow, limit
(5 Apr 2005 6:33:39)
Re: Constraint Names
(5 Apr 2005 4:29:25)
Where is column name of primary key in Sysobjects or syscolumns???
(4 Apr 2005 18:36:41)
Single user mode
(4 Apr 2005 12:39:15)
Problem in restoring
(4 Apr 2005 10:17:34)
SQL Timeout value
(4 Apr 2005 8:13:2)
Identity key question
(4 Apr 2005 6:10:4)
date query
(3 Apr 2005 14:54:55)
SOS - Database Size
(3 Apr 2005 8:20:5)
cursor problem.
(1 Apr 2005 12:36:52)
Log shipping
(1 Apr 2005 12:9:31)
Query
(1 Apr 2005 8:26:7)
sql lazydba home page