MS Sql Server

June 2004

Create Proc Permission
(30 Jun 2004 21:50:15)
Benchmarking SQL
(1 Jul 2004 16:0:55)
job interviews questions
(1 Jul 2004 0:7:43)
ANSI NULLS AND ANSI WARNINGS
(1 Jul 2004 16:26:20)
disk problems
(30 Jun 2004 19:40:7)
Replication design
(30 Jun 2004 16:53:34)
changing schema of replicated DB's
(30 Jun 2004 15:4:0)
Re: standby server[Scanned]
(30 Jun 2004 8:35:38)
"Timeout expired" error from query analyser
(30 Jun 2004 9:45:2)
Problem In Database REeplication In SQL 7.0
(30 Jun 2004 5:42:4)
MUM
(30 Jun 2004 0:32:29)
table update date
(30 Jun 2004 15:20:17)
getting current transaction ID
(29 Jun 2004 22:51:24)
Results Screen Buffer
(30 Jun 2004 8:10:36)
Device Activation Error
(29 Jun 2004 19:31:24)
SQL Server Enterprise manager "losing" registered servers?
(30 Jun 2004 7:17:9)
Sql Server Fail Over
(1 Jul 2004 15:23:31)
Re: Internet SQL Server Fail Over
(29 Jun 2004 16:5:47)
Performance monitoring
(1 Jul 2004 17:16:21)
Strange problem
(30 Jun 2004 13:10:6)
Databse In Suspect Mode
(30 Jun 2004 12:45:12)
DRA plans for SQLSERVER DB
(29 Jun 2004 10:19:3)
Re: big database to be backed up[Scanned]
(30 Jun 2004 11:15:51)
Thanks in advance for your help
(29 Jun 2004 6:5:8)
Simulating DEADLOCKS for Performance Tuning/Troubleshooting
(29 Jun 2004 12:44:40)
WHICH LOCK to KILL
(29 Jun 2004 0:40:53)
migration from SQLserver to Oracle
(29 Jun 2004 3:43:26)
User connections... and max worker threads
(29 Jun 2004 8:25:51)
Row counts in SQL 2000
(29 Jun 2004 12:46:3)
big database to be backed up
(29 Jun 2004 3:43:31)
Stored Procedure Performance
(29 Jun 2004 8:37:42)
Restore Problem
(28 Jun 2004 17:2:55)
sql mail issues
(28 Jun 2004 11:42:11)
standby database server congiguration
(26 Jun 2004 11:18:19)
Excel Macros
(25 Jun 2004 22:56:37)
Single Quote in Excel DTS Export
(25 Jun 2004 19:23:58)
copy tables and views
(25 Jun 2004 14:54:9)
Cube etc.
(25 Jun 2004 12:25:38)
Automated restore..
(25 Jun 2004 2:43:42)
Performance Tuning where to start
(25 Jun 2004 7:51:58)
need some help with Dates
(25 Jun 2004 7:44:38)
what is better
(25 Jun 2004 13:7:35)
Crosstab query (pivot table) , output from table to XML
(24 Jun 2004 18:53:43)
Maintenance Plan Issue
(24 Jun 2004 13:37:33)
Point in time recovery in SQL server 2000
(24 Jun 2004 11:33:51)
Is there an equivalent of PRINT in Oracle
(24 Jun 2004 15:16:10)
Ora-03113 need urgent help!!!!!!
(25 Jun 2004 17:24:30)
configuring the locks as DYNAMIC
(28 Jun 2004 6:50:19)
Truncate all table
(25 Jun 2004 7:37:48)
Sequence number generation
(24 Jun 2004 12:6:31)
Setting Up DNS
(24 Jun 2004 3:22:46)
Conditional Index
(24 Jun 2004 19:11:1)
Just curious ..
(24 Jun 2004 11:39:15)
fire hose error message
(24 Jun 2004 15:1:39)
Query question
(24 Jun 2004 0:18:50)
Isolation Level
(23 Jun 2004 16:6:10)
Backup & restoring databases
(23 Jun 2004 15:55:23)
Ebook for DTS - ActiveX Scripting
(23 Jun 2004 21:11:23)
DTS datatype mapping
(23 Jun 2004 9:8:45)
Backup a remote server from a local server
(22 Jun 2004 21:27:58)
Mystery Solved!
(22 Jun 2004 22:0:4)
Erwin\ Supra PDM\SQL why not.
(22 Jun 2004 17:47:21)
Error 7391 distributed transaction
(23 Jun 2004 8:31:53)
Service Status
(24 Jun 2004 14:45:45)
MS 2k Logs
(22 Jun 2004 15:16:21)
SAP
(23 Jun 2004 6:25:43)
'IF' STATEMENT FAILURE
(22 Jun 2004 13:58:14)
SAP Docs etc.
(22 Jun 2004 0:41:29)
Can I apply sql server 7 transaction log to sql 2k?
(22 Jun 2004 15:37:27)
DTS Export/Import
(21 Jun 2004 22:16:16)
MS-SQL to Oracle Migration
(21 Jun 2004 23:2:11)
Re: connection issue
(21 Jun 2004 21:31:10)
What do you recommend for maintenance of a full text search catalog?
(21 Jun 2004 21:16:59)
change sql server name
(22 Jun 2004 13:41:38)
Re: Spam:RE: DTS Error
(21 Jun 2004 13:16:17)
Re: Digest[Scanned]
(21 Jun 2004 9:53:2)
Digest
(22 Jun 2004 13:52:7)
Problem sending emails
(22 Jun 2004 8:22:41)
sp_runwebtask
(21 Jun 2004 6:14:1)
LicenseType = "Disabled"
(20 Jun 2004 18:44:48)
Table too big to drop
(22 Jun 2004 9:37:5)
execute long sql statement
(18 Jun 2004 17:52:47)
Calling BACKUP from a Procedure
(18 Jun 2004 18:58:1)
Re: SQL ERROR[Scanned]
(18 Jun 2004 16:44:28)
Creating a linked server
(18 Jun 2004 17:34:44)
SQL ERROR
(18 Jun 2004 19:10:49)
Only backup job fail
(18 Jun 2004 14:39:26)
Re: Run a script[Scanned]
(18 Jun 2004 14:1:23)
Run a script
(18 Jun 2004 17:8:15)
Java Error
(18 Jun 2004 13:19:18)
estimate backup times?
(19 Jun 2004 19:25:13)
Outer Join Query
(18 Jun 2004 12:58:23)
Notification on error
(18 Jun 2004 8:19:34)
LISTOWNER - LIST BACK TO NORMAL
(17 Jun 2004 22:43:40)
offlining or detaching a database
(17 Jun 2004 16:39:51)
()
Memory leak with DTS
(17 Jun 2004 4:59:48)
IN CLAUSE AND PERFORMANCE
(24 Jun 2004 0:49:31)
GroupWise as email service for SQL server
(17 Jun 2004 07:51:55)
Calling a Backup from an SPROC
(17 Jun 2004 00:47:22)
Schedule DTS job fails Urgent pls help!!!
(17 Jun 2004 16:40:24)
Cant restart sql2k after moving tempdb
(17 Jun 2004 00:02:20)
Best Way to Break into field
(16 Jun 2004 23:42:43)
Need to Take DataBase Offline
(17 Jun 2004 16:9:12)
Re: weird error
(16 Jun 2004 21:29:13)
wierd error
(16 Jun 2004 21:13:33)
Replace cursor logic in SQL Server
(16 Jun 2004 20:36:21)
layout for the 200GB SQL SERVER database
(16 Jun 2004 20:35:18)
Backup direct to tape NET backup without using native SQL backups
(16 Jun 2004 20:43:21)
Importing MainFrame txt files .... UPDATE..& another question
(16 Jun 2004 15:45:27)
backup and restore - scripting
(16 Jun 2004 11:24:15)
CheckDB process killed but refusing to go
(16 Jun 2004 16:08:56)
Circular Referance?
(15 Jun 2004 17:42:20)
SQL server 7 (date format)
(15 Jun 2004 10:43:38)
Oracle to MS-SQL or MS-SQL- Oracle tools
(15 Jun 2004 08:56:35)
Importing Data from MainFrame txt files into SQL Server
(16 Jun 2004 15:19:52)
Can't see "Current processes"
(15 Jun 2004 02:20:21)
SQL 2000 Alerts
(15 Jun 2004 12:29:24)
Re: moving backups over network[Scanned]
(14 Jun 2004 16:06:51)
moving backups over network
(14 Jun 2004 14:57:39)
I have added a date field to table
(14 Jun 2004 08:47:30)
Adding a salay into a table In sql
(14 Jun 2004 07:51:55)
SQL XML
(11 Jun 2004 19:29:45)
Generating Table Script
(11 Jun 2004 14:29:49)
Re: DTS export[Scanned]
(11 Jun 2004 16:45:46)
DTS export
(11 Jun 2004 14:20:57)
Capturing Stored Procedure Output in Variables
(11 Jun 2004 15:25:55)
date query
(11 Jun 2004 14:20:05)
Just Curios ... what is the N for
(11 Jun 2004 13:14:13)
Users controlled by database or by the middle-tier application ... ???
(11 Jun 2004 00:43:41)
Users controlled by database or by the middle-tier application ... just curious ???
(11 Jun 2004 00:48:23)
Reporting Services
(10 Jun 2004 22:10:37)
DTS Package Execution
(10 Jun 2004 22:15:30)
problems upgrading developer PCs to SP3a
(10 Jun 2004 19:59:17)
Stored Procedure Error
(10 Jun 2004 17:02:27)
date math
(10 Jun 2004 15:58:11)
table constraint question
(10 Jun 2004 15:29:42)
Unable to generate SQL Script
(10 Jun 2004 15:11:47)
User connections...
(10 Jun 2004 04:35:04)
query optimizer
(10 Jun 2004 03:31:04)
Access to SQL Jobs & Replication Info
(9 Jun 2004 23:02:41)
Copy - Import Database
(9 Jun 2004 20:17:54)
backup and restore
(9 Jun 2004 18:05:06)
Date Transformation
(10 Jun 2004 09:11:59)
showplan
(9 Jun 2004 17:08:09)
Change collations in many tables defined using COLLATE
(9 Jun 2004 17:07:40)
replication problems
(9 Jun 2004 15:55:09)
Date Functions
(10 Jun 2004 05:44:15)
Printing Table structure - Solved
(9 Jun 2004 10:14:34)
Printing Table Structure
(9 Jun 2004 22:19:12)
Count Function problem in SQL Query
(9 Jun 2004 15:06:31)
Need HELP IN DTS and Performing Backup
(9 Jun 2004 13:12:13)
Re: Finding out space usage
(9 Jun 2004 04:25:42)
copying a database
(9 Jun 2004 03:18:21)
question for fellow DBA's
(8 Jun 2004 22:43:42)
Re: How to kill process[Scanned]
(8 Jun 2004 15:29:39)
backup and recovery
(14 Jun 2004 23:56:03)
Problem with DB running out of space
(8 Jun 2004 15:01:09)
How to kill process
(8 Jun 2004 16:07:24)
Query question..
(8 Jun 2004 18:35:47)
ORA-12638 Credential retrieval failed
(8 Jun 2004 09:41:52)
Server Outage
(9 Jun 2004 01:34:45)
MCDBA and OCP Certification
(9 Jun 2004 21:12:39)
Query Time out in DTS Package
(8 Jun 2004 08:28:14)
Stored procedure ownership...
(9 Jun 2004 17:09:14)
SQL 2000 Generate full database script
(8 Jun 2004 17:52:57)
When to backup tlog
(8 Jun 2004 02:41:15)
wired query
(8 Jun 2004 13:50:43)
auto
(8 Jun 2004 02:46:26)
View oddity
(7 Jun 2004 17:13:34)
Insert query
(7 Jun 2004 14:42:29)
Scirpt in MSSQL
(6 Jun 2004 15:54:36)
loop in mssql
(7 Jun 2004 14:01:35)
Change Proceedure Type from System to User
(4 Jun 2004 20:42:53)
Table Access
(4 Jun 2004 19:52:23)
Re: Encrypted sprocs
(4 Jun 2004 19:42:40)
hardware scenario - what is your opinion
(10 Jun 2004 16:16:53)
DTS to send report
(4 Jun 2004 20:29:31)
version control for sql server
(4 Jun 2004 14:41:52)
Re: replication[Scanned]
(4 Jun 2004 13:36:46)
Important-Percent Change VAlue in Procedure
(4 Jun 2004 14:29:10)
LISTOWNER- Too Many Emails in your inbox?
(22 Jul 2004 13:0:2)
Error connecting to server
(4 Jun 2004 11:33:14)
Alternate to the VARRAY in ms-sql
(4 Jun 2004 08:13:39)
SQL Server memory usage
(4 Jun 2004 13:06:17)
% value
(4 Jun 2004 09:26:27)
Notes
(4 Jun 2004 14:09:36)
List ForeignKeys
(3 Jun 2004 23:39:57)
Which query is faster
(6 Jun 2004 14:16:56)
Query Performance
(4 Jun 2004 08:22:17)
Logging modifications to stored procedures
(4 Jun 2004 08:28:45)
Getting % Change of two fields
(3 Jun 2004 21:36:09)
Capture Info from SPROC into variables
(4 Jun 2004 13:32:11)
Creating Index
(3 Jun 2004 22:52:47)
How can I change a unicode comparison style in sql 7.0
(3 Jun 2004 19:38:38)
Selection of last row in a table in MS Sql Server
(4 Jun 2004 08:15:29)
Sarbanes Oxley & Data System Changes
(3 Jun 2004 19:22:15)
Migrating SQL 7.0 Databases to 2000 using Copy Database Wizard
(3 Jun 2004 21:34:00)
Re: Replication for Transaction DB[Scanned]
(3 Jun 2004 17:53:59)
Help With Query
(3 Jun 2004 14:58:25)
Replication for Transaction DB
(3 Jun 2004 14:48:09)
scale of numeric fields
(3 Jun 2004 12:51:27)
EXEC sp_changeobjectowner 'pritemview', 'dbo'
(3 Jun 2004 13:13:56)
Re: Inserting data into image column
(3 Jun 2004 14:41:45)
Sql transactional replication
(3 Jun 2004 08:06:11)
Re: DBA as developer/designer too[Scanned]
(3 Jun 2004 06:13:27)
Deadlock in MSSQL
(3 Jun 2004 17:08:56)
Deadlocks ...
(3 Jun 2004 03:28:19)
SQL REPORTING SERVICES
(2 Jun 2004 20:43:23)
T-SQL Statement to grant Update Permissions on a table's column
(3 Jun 2004 11:21:45)
Where Clause
(3 Jun 2004 15:59:34)
DTS and Access Memo
(3 Jun 2004 14:22:27)
Trigger not functionning properly.
(2 Jun 2004 16:47:32)
AdeptSQL vs Red Gate data compare
(2 Jun 2004 21:12:18)
storing SQL user password in script
(2 Jun 2004 16:08:24)
Just out of curiosity
(3 Jun 2004 13:15:33)
Purpose of sp_MStablespace
(2 Jun 2004 12:56:18)
Hi Need help VB6 + crystal report + sql 7.0
(2 Jun 2004 17:07:33)
Character set
(2 Jun 2004 14:23:09)
How to get the result set in Variables?
(2 Jun 2004 11:23:02)
create table dynamicaly
(2 Jun 2004 11:02:59)
CLOB
(2 Jun 2004 04:12:25)
How's your first day on the job ...
(5 Jun 2004 15:26:13)
DBA as developer/designer too
(2 Jun 2004 16:34:16)
Interview questions please if u don't mind
(1 Jun 2004 21:55:21)
System Summary Data:
(4 Jun 2004 16:30:58)
MS SQL Reporting Services
(3 Jun 2004 03:21:54)
SQL Server 2000 Reporting Services
(1 Jun 2004 21:50:52)
passwords for logins
(1 Jun 2004 21:34:19)
mssql dba's - best practice analyzer from microsoft
(1 Jun 2004 16:19:20)
Performance problems!!! Need an urgent help
(1 Jun 2004 19:10:50)
Re: Building reports from sql server
(2 Jun 2004 00:25:18)
Regarding Shrinking Transaction Log
(1 Jun 2004 19:13:43)
creating reports from sql to excel--plz reply urgent
(2 Jun 2004 06:01:13)
Where are my shortcuts
(1 Jun 2004 15:58:14)
Bulding reports from sql server
(2 Jun 2004 07:27:31)
Backup log failure
(1 Jun 2004 15:58:26)
How to change owner of tables from [user] to dbo
(1 Jun 2004 09:16:15)
How to restore MDF and LDF and match sysusers with syslogins
(1 Jun 2004 08:40:12)
LISTOWNER- EMAIL SHIELDING
(22 Jul 2004 13:0:4)
LISTOWNER MESSAGE NEW INFO -- how to manage mssqldba emails
(4 Jun 2004 09:22:03)
Testing
(9 Jun 2004 05:57:42)
DTS Error
(21 Jun 2004 12:54:36)
DTS Packages
(7 Jun 2004 22:02:27)
Linked server problem
(24 Jun 2004 14:10:0)
Query Help
(10 Jun 2004 06:57:48)
Stored Procedure
(30 Jun 2004 0:49:56)
Standby server
(30 Jun 2004 7:2:44)
Replication
(9 Jul 2004 16:56:5)
Database maintenance plan
(23 Jun 2004 20:54:19)
Transaction logs
(6 Jun 2004 15:19:10)
test
(1 Jun 2004 09:44:42)
sql lazydba home page