MS Sql Server

November 2005

Re: Licensing - Solved
(30 Nov 2005 22:48:46)
SQL Backup performance problems
(30 Nov 2005 22:32:19)
SQL Server 2000 Peformance issue
(30 Nov 2005 19:50:33)
A mystery...
(30 Nov 2005 19:48:30)
ActiveX Script Error
(30 Nov 2005 19:34:11)
Get an Error 5
(30 Nov 2005 18:30:5)
SSIS Scheduled Package Execution
(30 Nov 2005 18:12:30)
How to get the File Name
(30 Nov 2005 17:44:56)
Secure SQL in DMZ
(30 Nov 2005 16:42:26)
Trying to automate master restore
(30 Nov 2005 16:30:10)
regarding job in SQL server 2k
(30 Nov 2005 10:39:3)
Connecting thru using ASP application, Windows authentication on Active Directory
(30 Nov 2005 4:40:5)
FYI ... SAP/miniSAP
(30 Nov 2005 1:57:39)
2 ODBC driver error messages coming back from server
(30 Nov 2005 0:18:3)
Euro currency notation?
(30 Nov 2005 0:15:46)
IIS 6 w3wp.exe CPU 100%
(29 Nov 2005 23:41:35)
Listing All Rows That Have Only Numbers or Have Only Alphabets In It
(29 Nov 2005 18:18:48)
DTS Packages
(29 Nov 2005 17:52:42)
SQL 2000 performance counters may be missing on a cluster
(29 Nov 2005 17:48:36)
Help With Query
(29 Nov 2005 14:22:12)
SQL Debugger
(29 Nov 2005 14:22:6)
Listing all constraints with cascade delete
(29 Nov 2005 14:18:33)
SQL 2000 License mode change help!!
(29 Nov 2005 13:57:46)
SQL Server Log File Location
(29 Nov 2005 13:3:38)
PL/SQL code
(29 Nov 2005 12:50:38)
Number Format
(29 Nov 2005 12:48:23)
meanings of different clauses in index creation statements
(29 Nov 2005 12:24:1)
SQL 2000 SP4 and SharePoint 2003
(29 Nov 2005 9:15:8)
Archived/purged size dilemma
(29 Nov 2005 4:28:30)
Timeout expired
(29 Nov 2005 1:43:54)
connection pool
(28 Nov 2005 22:10:47)
Licensing
(28 Nov 2005 20:49:4)
Re: Shrink the Free space
(28 Nov 2005 19:49:8)
Error
(28 Nov 2005 17:40:9)
SQL Server 7.0 to SQL Server 2000 Migration issue
(28 Nov 2005 17:1:50)
Hi All one help urgent
(28 Nov 2005 14:41:6)
Recovering lost databaase
(28 Nov 2005 14:14:18)
Enterprise Manager Problem
(28 Nov 2005 12:15:41)
SQL Version
(28 Nov 2005 10:12:41)
Osql and collation prob
(28 Nov 2005 9:53:48)
XP_CMDSHELL
(27 Nov 2005 23:58:19)
LISTOWNER- EMAIL SHIELDING
(26 Nov 2005 14:0:3)
Re: Finding and deleting a duplicate record
(25 Nov 2005 17:29:1)
Update problem
(25 Nov 2005 13:16:27)
SMTP Mail task failure
(25 Nov 2005 11:57:43)
Data Query
(25 Nov 2005 10:17:55)
SQL Server 2000 version
(25 Nov 2005 6:36:8)
Get the job_id from within a currently running job.
(25 Nov 2005 2:54:14)
Clustered index rebuild
(25 Nov 2005 2:45:2)
Re: Set up SQL Mail
(24 Nov 2005 17:2:52)
List all triggers
(24 Nov 2005 16:40:9)
How to define replication agent order
(24 Nov 2005 16:17:40)
RE : Finding and deleting a duplicate record
(24 Nov 2005 13:54:21)
convert varchar to datetime
(24 Nov 2005 3:25:14)
Convert t Varchar to int
(24 Nov 2005 1:16:11)
DTS error message
(24 Nov 2005 0:15:3)
Cannot establish a connection to SQL Server 2K sp3a remotely
(24 Nov 2005 0:3:19)
Moving Tempdb
(23 Nov 2005 21:45:4)
Can alter table via EM cause a disabled trigger to be enabled
(23 Nov 2005 21:40:6)
Urgent LDAP Question
(23 Nov 2005 18:42:49)
Rebuild Production Server
(23 Nov 2005 18:12:28)
Re: [BULK] RE: another indexing question
(23 Nov 2005 16:33:2)
Restore DB
(23 Nov 2005 16:27:7)
another indexing question
(23 Nov 2005 15:59:14)
Error 7399
(23 Nov 2005 15:28:56)
Re: Error 7399: OLE DB provider 'MSDAORA' reported an error."The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installa
(23 Nov 2005 14:46:0)
Error 7399: OLE DB provider 'MSDAORA' reported an error."The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation"
(23 Nov 2005 12:22:5)
Collations problem
(23 Nov 2005 12:18:31)
Create table with date in name
(23 Nov 2005 12:7:0)
copy users & permissions
(23 Nov 2005 9:23:7)
Re: [BULK] RE: Set up SQL Mail
(23 Nov 2005 9:1:55)
the default DATEFORMAT on the server
(23 Nov 2005 6:48:35)
Indexing SQL Database
(23 Nov 2005 2:11:36)
Sql Problem
(22 Nov 2005 19:35:45)
SQL Server 2000 and MSA 1000 performance problems
(22 Nov 2005 15:22:46)
date settings
(22 Nov 2005 15:10:58)
RE : List of SQL Servers
(22 Nov 2005 14:56:43)
RE : RE : List of SQL Servers
(22 Nov 2005 14:56:17)
List of SQL Servers
(22 Nov 2005 14:42:30)
Best/right way for New instance Installation
(22 Nov 2005 13:36:34)
Transaction Log Backup Maintenance job fails on named instances of SQL Server 2000 with Error 22029
(22 Nov 2005 13:19:54)
All Servers in Network
(22 Nov 2005 12:33:51)
Index removal
(22 Nov 2005 10:40:9)
kill process
(22 Nov 2005 8:44:34)
SQL Server Agent
(22 Nov 2005 7:56:36)
DTS Package
(21 Nov 2005 22:17:11)
Seeking Other SQL Servers on Network
(21 Nov 2005 18:44:8)
Fine tuning databases
(21 Nov 2005 18:8:33)
2005 SSMS
(21 Nov 2005 17:49:30)
SQL Server DTS package
(21 Nov 2005 16:28:20)
Crosstab Queries/Datagrids
(21 Nov 2005 16:21:10)
SQL 2005 Express
(21 Nov 2005 15:17:15)
change log file location
(21 Nov 2005 15:16:33)
Address of Listener.
(21 Nov 2005 15:16:26)
Trouble with (nasty) Query...18-Nov-2005
(21 Nov 2005 13:53:10)
reg Scheduling
(21 Nov 2005 13:45:49)
Please Help!!!
(21 Nov 2005 12:45:57)
Reg distinct query
(21 Nov 2005 8:8:10)
removing a table from merge replication
(21 Nov 2005 7:44:35)
Re: [oracle_champions] Re: get back data from a previous installation
(21 Nov 2005 6:33:51)
Unix SQlPlus Help
(19 Nov 2005 7:39:27)
Cannot Restore ?
(18 Nov 2005 21:42:46)
Just like to run this by ya'll if you don't mind
(18 Nov 2005 19:0:34)
SQL Server error '80040e0c
(18 Nov 2005 15:47:9)
Users & Group Permissions
(18 Nov 2005 15:18:35)
help with installing SQL 2000 Sp3
(18 Nov 2005 12:48:41)
Log shippin monitor not updating
(18 Nov 2005 12:25:18)
PAGEIOLATCH_EX
(18 Nov 2005 9:25:23)
Advice - How to Set up Staging Environment with Production Databa ses
(18 Nov 2005 8:54:10)
delete duplicate
(18 Nov 2005 7:22:5)
delete duplicate record from query analyzer
(18 Nov 2005 4:58:31)
Help with a Query Corrected
(18 Nov 2005 4:47:56)
Help with a Query
(17 Nov 2005 22:48:43)
Changing the server Name in the .dts file
(17 Nov 2005 18:27:16)
indexed view
(17 Nov 2005 17:38:4)
Re: Catching a DTS error (captured it)
(17 Nov 2005 16:34:17)
Renaming an Existing SQL 2000 database.
(17 Nov 2005 16:34:10)
Catching a DTS error
(17 Nov 2005 16:18:15)
Problems with Maint Plan
(17 Nov 2005 16:8:3)
Weird db shrink
(17 Nov 2005 15:52:56)
Delete query
(17 Nov 2005 14:49:36)
Scheduled jobs across domains
(17 Nov 2005 7:43:3)
Msg 18542: Login failed
(17 Nov 2005 7:37:40)
object's last update dateandtime
(17 Nov 2005 7:2:42)
RI across SQL Server Databases
(16 Nov 2005 20:29:33)
Script Database
(16 Nov 2005 20:7:16)
Tools
(16 Nov 2005 19:59:54)
Stored procs called by ado
(16 Nov 2005 19:50:55)
Can Someone explain this Stored Proc and DTS Issue?
(16 Nov 2005 18:37:40)
Log Shipping Resources and overhead
(16 Nov 2005 18:30:48)
Log Shipping Error
(16 Nov 2005 17:53:50)
Log Shipping Stand By DB assuming Primary
(16 Nov 2005 17:44:6)
Problem with Reporting Services and Windows 2003
(16 Nov 2005 17:6:45)
Doubt reg text column
(16 Nov 2005 16:49:35)
Converting SQL Database Date Time format in Excel
(16 Nov 2005 16:2:30)
function to calculate business days
(16 Nov 2005 14:3:55)
Reg Arabic data
(16 Nov 2005 12:38:19)
DTS jobs
(16 Nov 2005 9:47:16)
how to find SQL changes carried out by pro c batches
(16 Nov 2005 6:51:15)
Full text search
(16 Nov 2005 1:32:7)
2nd Request --> Advice - How to Set up Staging Environment with P roduction Databases
(16 Nov 2005 1:28:56)
Re: Spam:RE: function to calculate business days
(15 Nov 2005 22:31:0)
report
(15 Nov 2005 21:7:20)
Restoring a Table
(15 Nov 2005 19:11:34)
Allocation Errors in tempdb
(15 Nov 2005 19:3:17)
Proc defaults with cached plans
(15 Nov 2005 17:18:42)
Restoring Play database
(15 Nov 2005 15:51:47)
Problem with Cursor inserting to many rows.
(15 Nov 2005 13:21:16)
List All Occurrences of a Character and the Number of Times it Occurs in a SQL Server Table Column
(15 Nov 2005 11:16:58)
anyone using SQL server 2005?
(15 Nov 2005 9:46:59)
agent who run continuously
(15 Nov 2005 7:45:41)
Winrar Prob
(15 Nov 2005 7:28:20)
[Maybe spam] RE: Winrar Prob
(15 Nov 2005 7:22:32)
SQL Server SP4
(15 Nov 2005 5:19:23)
Linked Server
(15 Nov 2005 4:40:19)
How to tuning SQL SERVER 2000 database
(15 Nov 2005 4:6:55)
About SQL Server 2000 Database Turning
(15 Nov 2005 3:56:41)
awe
(15 Nov 2005 1:29:49)
Foreign Key Constraints - Follow Up Question
(14 Nov 2005 21:40:55)
Performance problem
(14 Nov 2005 20:3:49)
Re: Log File
(14 Nov 2005 19:51:54)
Timing Question
(14 Nov 2005 19:13:38)
round float
(14 Nov 2005 17:29:49)
help in estimating disk space used by a table
(14 Nov 2005 17:27:31)
SQL Newby - Help!
(14 Nov 2005 16:50:45)
view unique Constraing Details
(14 Nov 2005 16:30:9)
DTS Export Dynamic Filename Problems
(14 Nov 2005 16:25:56)
Re: [BULK] performance problem
(14 Nov 2005 15:48:37)
Re: [BULK] Shrink database - Log file full
(14 Nov 2005 14:38:29)
Shrink database - Log file full
(14 Nov 2005 14:14:49)
Update query
(14 Nov 2005 13:59:34)
Re: All Our MS SQL Servers (11), have slowed down in same time at once :(
(14 Nov 2005 13:39:55)
How do you allocate memory and cpu power per each SQL database?
(14 Nov 2005 13:19:0)
MS SQL structure
(13 Nov 2005 8:11:2)
[help with] RAISERROR could not locate entry for...
(12 Nov 2005 22:47:24)
Migration from Oracle To SQL Server 2000
(12 Nov 2005 13:23:47)
Service pack 4 - SQL SERVER 2000
(12 Nov 2005 6:4:42)
Transactions / Second
(11 Nov 2005 20:58:53)
Header OFF
(11 Nov 2005 19:25:29)
Re: [SPAM ] All Our MS SQL Servers (11), have slowed down in same time at once :|
(11 Nov 2005 18:40:2)
Backups urgent
(11 Nov 2005 18:14:51)
Concise Job Schedule List script, version 2 - natural time formats
(11 Nov 2005 18:7:40)
All Our MS SQL Servers (11), have slowed down in same time at once :|
(11 Nov 2005 17:43:23)
Copy a databse
(11 Nov 2005 16:41:54)
General Reporting Services question
(11 Nov 2005 16:40:7)
Backups- Urgent
(11 Nov 2005 15:2:3)
DTS Package Hangs
(11 Nov 2005 14:53:37)
Help for oracle dba with crash course in Windows/MSSql!
(11 Nov 2005 14:30:3)
HELP!!! Bad block in the .mdf file!!!!
(11 Nov 2005 13:46:5)
SQL Profiler
(11 Nov 2005 13:44:11)
How to Use String Query or Stored Procedure in UDF
(11 Nov 2005 13:42:6)
Detaching Attaching Database
(11 Nov 2005 13:32:44)
Dynamic vs Static ports for SQL Server
(11 Nov 2005 13:3:45)
Re: [BULK] RE: Client side cursors
(11 Nov 2005 12:24:8)
Extended properties on Constraints
(10 Nov 2005 20:16:54)
MS SQL DBA TRAINING
(10 Nov 2005 19:52:48)
Client side cursors
(10 Nov 2005 18:33:17)
date table new request
(10 Nov 2005 17:5:22)
CRC check
(10 Nov 2005 16:1:45)
doubt unresolved pls
(10 Nov 2005 15:39:58)
Automate database restore with log shipping
(10 Nov 2005 14:25:22)
Restore a Table in SQL Server
(10 Nov 2005 11:30:5)
Foreign Key Constraints
(10 Nov 2005 9:15:17)
Trigger
(10 Nov 2005 6:12:23)
Corrected subject: Decoding bitmapped values in sysjobschedules
(10 Nov 2005 2:38:42)
Script to produce a concise listing of jobs and schedule descriptions.
(10 Nov 2005 2:29:26)
Return character question
(9 Nov 2005 16:36:36)
some doubts
(9 Nov 2005 13:44:21)
Help I do not understand how to do this.
(9 Nov 2005 13:28:19)
Date Table in SQL 2000
(9 Nov 2005 13:4:59)
SQL Performance issues
(9 Nov 2005 0:49:35)
Re: [SPAM ] RE: Date Conversion Syntax Help
(9 Nov 2005 0:35:37)
Date Conversion Syntax Help
(9 Nov 2005 0:8:32)
Re: Spam:RE: SQL not recognizing TOP clause
(8 Nov 2005 21:47:49)
Sql Interview
(8 Nov 2005 21:40:1)
SQL not recognizing TOP clause
(8 Nov 2005 21:36:11)
SQL Interview ...
(8 Nov 2005 20:43:19)
Re: [Potential Spam] I hope somebody out there has something that can accomplish this
(8 Nov 2005 20:10:12)
Windows XP Pro
(8 Nov 2005 18:50:29)
The TSQL subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended).
(8 Nov 2005 15:34:56)
Prob with XP
(8 Nov 2005 15:3:16)
reg timeout
(8 Nov 2005 14:2:32)
Overlapping & Redundant indexes
(8 Nov 2005 12:36:24)
equivalent of oracle SGA in SQL server 2000
(8 Nov 2005 7:19:43)
Blob vs. Text
(8 Nov 2005 6:4:26)
Auto recompile stored procedure
(8 Nov 2005 5:58:7)
I hope somebody out there has something that can accomplish this
(7 Nov 2005 22:48:24)
Starting a job via cmd line
(7 Nov 2005 16:0:47)
No items under databases in SQLServer
(7 Nov 2005 15:57:29)
Re: [BULK] RE: No items under databases in SQLServer
(7 Nov 2005 15:11:45)
Oracle Worm Voyager
(7 Nov 2005 10:48:17)
Urg's Dilemma
(7 Nov 2005 10:24:2)
Version Control
(7 Nov 2005 5:19:1)
GUID performance with Inserts
(5 Nov 2005 23:30:31)
LDAP and SQL
(4 Nov 2005 20:13:36)
Performance of a Query in QA
(4 Nov 2005 16:59:39)
Reindex/Reorg
(4 Nov 2005 15:38:22)
Line break in email
(4 Nov 2005 15:22:58)
Getting to the point where I can use query analzyer
(4 Nov 2005 15:7:41)
Stored Procedures
(4 Nov 2005 13:22:7)
Hi...Reg views
(4 Nov 2005 12:46:39)
Request for comments ... SQL 2000 SP4: Any problems observed after application?
(4 Nov 2005 8:47:22)
Cross Server Queries.
(3 Nov 2005 23:31:6)
Installing SQL Server on a rebuilt node in an existing SQL Server cluster
(3 Nov 2005 22:47:2)
Clustering Hardware
(3 Nov 2005 22:22:11)
multiple insert triggers
(3 Nov 2005 21:48:41)
Packet Errors Issues
(3 Nov 2005 21:6:15)
Job history
(3 Nov 2005 20:11:4)
Can't run checkdb - Not in single user mode !!!!????
(3 Nov 2005 16:12:49)
Re: Database question (spotting unused tables)
(3 Nov 2005 15:12:11)
I get a question about synonym in MS-SQL Server
(3 Nov 2005 14:44:20)
service pack version
(3 Nov 2005 13:47:47)
Pb when trying to open Databases panel through EM
(3 Nov 2005 10:34:22)
Database question
(3 Nov 2005 9:10:18)
Database Create Message
(3 Nov 2005 2:0:13)
Query Analyzer
(2 Nov 2005 19:15:32)
Re: IndexDefrag / ReIndex ( plus script to analyze )
(2 Nov 2005 19:9:33)
Text change on multiple tables / multiple fields
(2 Nov 2005 18:51:16)
84gb ldf..
(2 Nov 2005 18:41:51)
Track connections to SQL Server
(2 Nov 2005 17:50:58)
Re: [BULK] Track connections to SQL Server
(2 Nov 2005 17:29:20)
Re: Spam:Re: 84gb ldf..
(2 Nov 2005 17:16:58)
number conversion
(2 Nov 2005 16:17:0)
DTS question
(2 Nov 2005 15:23:16)
SQL Memory Size Error in Server Log
(2 Nov 2005 14:32:56)
Not For Replication Optin
(2 Nov 2005 7:22:18)
IndexDefrag / ReIndex
(2 Nov 2005 0:15:15)
Force index on a Select
(1 Nov 2005 19:58:23)
storing more than ten job histories for auditing
(1 Nov 2005 17:25:40)
Linked Server to Oracle 9.2
(1 Nov 2005 17:17:20)
DTS and Sharepoint Portal
(1 Nov 2005 17:8:39)
scripting assistance please
(1 Nov 2005 16:53:11)
Delete "best practice" question
(1 Nov 2005 15:48:14)
[Maybe spam] RE: Capturing 2 DateParts
(1 Nov 2005 14:40:53)
Capturing 2 DateParts
(1 Nov 2005 14:40:31)
TLOGBackup.BAK file is larger than the Fullback up
(1 Nov 2005 14:34:5)
Proc to write Trigger
(1 Nov 2005 13:15:43)
SQL2005 - general question
(1 Nov 2005 10:36:39)
sql lazydba home page