MS Sql Server

November 2004

Backup Recommendations
(30 Nov 2004 21:41:55)
Problem with Copy Database Wizard
(30 Nov 2004 20:10:15)
Changing authentication mode via query analyzer
(30 Nov 2004 19:54:28)
tempdb full?
(30 Nov 2004 19:11:20)
Log Shipping Alternative
(30 Nov 2004 16:54:48)
Using local temp tables in DTS
(30 Nov 2004 15:45:45)
Re: _SUSPECT: Problem with Copy Database Wizard
(30 Nov 2004 15:16:18)
Lach Error
(30 Nov 2004 15:13:8)
Re: mailing from sqlserver[Scanned]
(30 Nov 2004 13:28:49)
mailing from sqlserver
(30 Nov 2004 13:25:41)
DBLINK PROBLEM
(30 Nov 2004 5:22:30)
SQL 2005 Beta
(30 Nov 2004 1:16:37)
Calling a file from stored procedure
(29 Nov 2004 17:59:10)
SQL Migration and Migration Rollback scripts
(29 Nov 2004 17:4:29)
Re: SUSPECT: CONVERTING ORACLE DATE TO SQL SERVER DATE FORMAT
(29 Nov 2004 16:12:22)
security login event id 537
(29 Nov 2004 15:47:22)
intercept any errors durring the DBCC command
(29 Nov 2004 15:11:15)
CONVERTING ORACLE DATE TO SQL SERVER DATE FORMAT
(29 Nov 2004 11:15:47)
Query for Columns in a Table
(29 Nov 2004 10:22:37)
SQL-DMO object model question
(29 Nov 2004 10:15:52)
Re: Query for Columns in a Table[Scanned]
(29 Nov 2004 9:44:58)
SQL ERROR!!!
(29 Nov 2004 9:40:25)
SQL ERROR
(29 Nov 2004 6:35:54)
LISTOWNER- EMAIL SHIELDING
(27 Nov 2004 14:0:1)
Re: SUSPECT: backing up 50 databases to another locatin
(26 Nov 2004 15:24:52)
Re: SUSPECT: replication on a very sensitive sql server
(26 Nov 2004 15:11:10)
Re: SUSPECT: RE: new p[roblem
(26 Nov 2004 14:11:55)
Re: _SUSPECT: Unknown token received from SQL Server
(26 Nov 2004 14:5:50)
Selecting Oracle date variables through linked server problem
(26 Nov 2004 13:58:51)
backing up 50 databases to another locatin
(26 Nov 2004 13:10:18)
Unknown token received from SQL Server
(26 Nov 2004 12:58:1)
unable to start sql server
(26 Nov 2004 12:47:58)
replication on a very sensitive sql server
(26 Nov 2004 8:17:59)
new p[roblem
(26 Nov 2004 8:10:28)
Re: SUSPECT: RE: Output as HTML
(25 Nov 2004 15:46:49)
Problems with DTSRun
(25 Nov 2004 14:27:49)
Executing Oracle Procedure from SQL Server (Linked Server)
(25 Nov 2004 14:5:8)
Application Role
(25 Nov 2004 11:36:41)
Re: Problems with DTSRun[Scanned]
(25 Nov 2004 11:27:6)
Sql server Functions !!
(25 Nov 2004 8:59:34)
Thanksgiving Day
(25 Nov 2004 8:58:8)
Hardware recommendation!!!
(25 Nov 2004 8:31:41)
Output as HTML
(25 Nov 2004 3:50:16)
Re: SUSPECT: Transaction log backup
(24 Nov 2004 18:45:56)
Transaction Log Backup
(24 Nov 2004 17:56:9)
Error 22528
(24 Nov 2004 17:52:41)
problem with distinct...
(24 Nov 2004 17:31:25)
Re: SUSPECT: RE: Cannot sort a row of size 240
(24 Nov 2004 17:24:20)
kill process
(24 Nov 2004 17:16:3)
Re: SUSPECT: Unused Objects
(24 Nov 2004 14:20:58)
Error trapping in TSQL
(24 Nov 2004 12:18:31)
Number of tasks run in parallel in a DTS
(24 Nov 2004 10:56:55)
SQL Install Failure
(23 Nov 2004 22:11:33)
Multiple columns into 1
(23 Nov 2004 21:19:38)
index drop create questions
(23 Nov 2004 21:6:58)
Update first record of group
(23 Nov 2004 20:58:44)
Newbie Question
(23 Nov 2004 18:24:31)
conversion dates in INSERT
(23 Nov 2004 17:3:19)
QUICK question and answer
(23 Nov 2004 7:48:8)
Sql 2000 server name change
(23 Nov 2004 7:30:54)
YUKON features..
(22 Nov 2004 23:48:1)
Re: SUSPECT: conversion dates in INSERT
(22 Nov 2004 17:20:33)
Re: SUSPECT: dos batch files to copy the .BAK file from Server1 to Server2
(22 Nov 2004 16:17:1)
dos batch files to copy the .BAK file from Server1 to Server2
(22 Nov 2004 15:31:57)
Update Statement
(22 Nov 2004 10:0:17)
Re: DTS transfer incrementally[Scanned]
(21 Nov 2004 19:31:16)
DTS transfer incrementally
(21 Nov 2004 18:53:46)
Unused Objects
(19 Nov 2004 22:17:29)
Explain plan variation for a query
(19 Nov 2004 21:0:3)
Re: SUSPECT: sql server quickest way
(19 Nov 2004 20:23:54)
Statistcal Anlysis
(19 Nov 2004 19:15:24)
Re: SUSPECT: RE: SUSPECT: index drop create questions
(19 Nov 2004 18:56:1)
Re: SUSPECT: index drop create questions
(19 Nov 2004 18:42:34)
Re: SUSPECT: Re: strange question about closing connections
(19 Nov 2004 17:6:45)
strange question about closing connections
(19 Nov 2004 17:1:29)
sql server quickest way
(19 Nov 2004 16:19:15)
Table Defrag Script for SQL7.0
(19 Nov 2004 16:2:46)
How to display binary column
(19 Nov 2004 13:27:50)
SQL result into text file
(19 Nov 2004 13:25:32)
defragging hdd
(19 Nov 2004 6:13:51)
Creating tables on specific filegroup
(19 Nov 2004 1:41:14)
SQL Server connection to Active Directory
(18 Nov 2004 21:2:45)
Re: SUSPECT: rpc, dct i think.
(18 Nov 2004 19:46:4)
rpc, dct i think.
(18 Nov 2004 17:1:37)
SQL statement
(18 Nov 2004 16:9:9)
Re: SUSPECT: RE: SQL statement
(18 Nov 2004 15:40:30)
Re: SUSPECT: RE: SUSPECT: RE: SQL statement
(18 Nov 2004 15:19:28)
Backup HELP!
(18 Nov 2004 14:15:50)
PROBLEM WITH MSDTC in windows 2003 cluster
(18 Nov 2004 13:51:37)
[HELP] a group question
(18 Nov 2004 10:44:27)
Re: SUSPECT: SQL Reboots
(18 Nov 2004 2:26:20)
sql edition?
(17 Nov 2004 20:34:27)
Database Users And Roles
(17 Nov 2004 20:13:46)
Hierarchies: Is there another way besides cursors ?
(17 Nov 2004 19:5:18)
ActiveX script objects and VB code
(17 Nov 2004 18:58:54)
Export error following Oracle upgrade to version 9.2.0.5
(17 Nov 2004 18:26:51)
SQL Reboots
(17 Nov 2004 18:19:46)
SYNONYM in SQL Server?
(17 Nov 2004 16:36:48)
Re: setting up email notifictaion for backup failure---sql2000 cl uster[Scanned]
(17 Nov 2004 11:11:47)
Re: setting up email notification for backup failure---sql2000 cl uster
(17 Nov 2004 10:20:2)
setting up email notifictaion for backup failure---sql2000 cluster
(17 Nov 2004 10:9:26)
moving system and tempdb
(17 Nov 2004 0:50:54)
book info
(16 Nov 2004 21:25:8)
Server memory
(16 Nov 2004 20:38:51)
Backup to current hour -2
(16 Nov 2004 19:56:21)
Re: SUSPECT: RE: Backup HELP!
(16 Nov 2004 17:37:8)
Re: SUSPECT: RE: Server memory
(16 Nov 2004 15:58:44)
Re: SUSPECT: copying files across a network
(16 Nov 2004 15:8:9)
copying files across a network
(16 Nov 2004 14:55:54)
Re: SUSPECT: Server memory
(16 Nov 2004 14:26:40)
Replicated database size
(16 Nov 2004 13:40:1)
db_owner question
(16 Nov 2004 0:43:18)
Field Manipulation
(15 Nov 2004 18:41:32)
Ecommerce logins lasting awful long time
(15 Nov 2004 17:30:11)
MCDBA-2005 ?
(15 Nov 2004 15:20:38)
Re: Rounding Error[Scanned]
(15 Nov 2004 15:8:25)
Rounding Error
(15 Nov 2004 14:36:32)
Moving Databases
(15 Nov 2004 12:1:50)
Renaming login
(15 Nov 2004 10:26:11)
Profiler trace questions
(14 Nov 2004 19:8:30)
I'm in need of some monitoring tips
(13 Nov 2004 23:11:28)
DTS logging
(12 Nov 2004 20:42:48)
Creating and deleting tables on a remote server
(12 Nov 2004 20:13:42)
DTS package permissions
(12 Nov 2004 18:59:10)
sql server error message
(12 Nov 2004 18:39:24)
Linking servers
(12 Nov 2004 18:29:18)
Problem with error Checking
(12 Nov 2004 17:52:39)
Wild card a column in a update
(12 Nov 2004 17:8:22)
forced index in tables with full qualified name
(12 Nov 2004 16:54:32)
transactional log truncates
(12 Nov 2004 15:40:2)
DTS Package
(11 Nov 2004 17:2:52)
DTS / Analysis Services
(11 Nov 2004 13:14:58)
aggregates and updates
(11 Nov 2004 9:43:54)
Running a DTS package as a Scheduled Job
(11 Nov 2004 2:22:14)
lazy question
(10 Nov 2004 18:2:31)
Re: [Maybe Spam] aggregates and updates
(10 Nov 2004 16:27:20)
Re: SUSPECT: aggregates and updates
(10 Nov 2004 16:19:41)
Re: FTP from a DTS package or job[Scanned]
(10 Nov 2004 15:50:34)
FTP from a DTS package or job
(10 Nov 2004 15:39:39)
List Folder Contents
(10 Nov 2004 14:32:44)
Link SQL 2k DB2 7.1
(10 Nov 2004 13:1:15)
oracle release 9.2.0.4
(10 Nov 2004 11:34:50)
Roles
(10 Nov 2004 11:0:56)
Question regarding SQL 2k Linked Server authentication using AD Groups
(10 Nov 2004 0:13:46)
SQL Server Security validation.
(9 Nov 2004 21:0:37)
Re: SUSPECT: RE: SQL Server Security validation.
(9 Nov 2004 20:20:51)
Help needed with DTS Operation::: Urgent
(9 Nov 2004 19:14:21)
More just for laughs
(9 Nov 2004 17:57:39)
Splitting a varchar
(9 Nov 2004 17:31:1)
tables with 0 rows
(9 Nov 2004 16:32:42)
What is wrong with this code? How can it be better?
(9 Nov 2004 16:18:24)
deleted data base files
(9 Nov 2004 16:13:46)
Re: SUSPECT: RE: What is wrong with this code? How can it be better?
(9 Nov 2004 16:1:20)
Raid0 vs Raid5
(9 Nov 2004 13:55:17)
Re: SUSPECT: tables with 0 rows
(9 Nov 2004 13:54:39)
Writing inserted records primary key into a text file using tsql
(9 Nov 2004 11:24:49)
Can't delete job
(8 Nov 2004 20:44:28)
Re: SUSPECT: DBCC TraceOn
(8 Nov 2004 19:29:16)
DBCC TRACEON
(8 Nov 2004 19:1:59)
Re: Log ship : error restoring logs[Scanned]
(8 Nov 2004 17:44:43)
For any hardware experts we have out here....
(8 Nov 2004 15:48:45)
Log ship : error restoring logs
(8 Nov 2004 15:42:18)
looking for suggestions....
(8 Nov 2004 15:17:38)
Re: SUSPECT: RE: SUSPECT: Re-Normalise
(8 Nov 2004 14:0:43)
Re: Select statement to pick up MAX
(8 Nov 2004 12:0:38)
Re: SUSPECT: Re-Normalise
(8 Nov 2004 8:34:24)
Select statment to pick up MAX
(8 Nov 2004 4:11:57)
Filtering data
(6 Nov 2004 19:11:41)
Single user mode- DB DOA
(5 Nov 2004 22:50:55)
What do multiple "Starting up database" messages mean?
(5 Nov 2004 22:42:52)
Scripting a command for each database
(5 Nov 2004 22:16:37)
Can Log Shipping cause a database to hang?
(5 Nov 2004 16:24:40)
Re: SUSPECT: Scripting a command for each database
(5 Nov 2004 15:29:52)
Register Failed for Login account
(5 Nov 2004 14:22:22)
Clear data on selected tables
(5 Nov 2004 13:57:40)
Errors Restoring Database
(5 Nov 2004 12:32:45)
Re-Normalise
(5 Nov 2004 11:53:4)
SQL Server Memory Full
(5 Nov 2004 11:34:13)
Re: licence info
(5 Nov 2004 9:55:6)
Two Connections needed?
(5 Nov 2004 8:52:10)
Error 651
(5 Nov 2004 2:1:23)
Querying distributed Sql Databases *Challenging Task*
(4 Nov 2004 23:54:24)
Rights needed to view metadata??
(4 Nov 2004 22:25:19)
Files export
(4 Nov 2004 21:23:48)
SQL Jobs view
(4 Nov 2004 20:56:30)
Re: SUSPECT: RE: Rename role
(4 Nov 2004 19:12:56)
Rename role
(4 Nov 2004 17:35:53)
Re: SUSPECT: Clustered Server Naming Convention within a SQL statement
(4 Nov 2004 16:40:45)
Clustered Server Naming Convention within a SQL statement
(4 Nov 2004 16:33:13)
sqlserver timeout / troubleshooting tips
(4 Nov 2004 16:25:6)
need for a query help
(4 Nov 2004 15:21:43)
parallel execution of query
(3 Nov 2004 23:28:29)
usage of IN in LIKE
(3 Nov 2004 23:19:33)
help needed
(3 Nov 2004 21:57:3)
View Permissions
(3 Nov 2004 20:18:48)
SQL reporting
(3 Nov 2004 17:17:8)
What is minimum security required to execute xp_cmdshell?
(3 Nov 2004 17:16:6)
Help need in reindexing of Database
(3 Nov 2004 17:0:18)
Re: sqlserver timeout / troubleshooting tips[Scanned]
(3 Nov 2004 15:43:37)
Database MOVE
(3 Nov 2004 15:36:40)
sqll performance
(3 Nov 2004 15:32:29)
SQL Server Monitoring and Tuning for Altiris and eXpress
(3 Nov 2004 15:11:59)
Updateable Partitioned View Not Working
(3 Nov 2004 13:35:53)
Grouping on Date Parts
(3 Nov 2004 11:44:3)
Re: class not registered error (parsedisplayname failed)...
(3 Nov 2004 9:32:51)
Help to removing error
(3 Nov 2004 8:57:56)
SQL Server Monitoring
(2 Nov 2004 23:50:58)
BII Sample
(2 Nov 2004 22:33:55)
Re: What is minimum security required to execute xp_cmdshell? - - I FORGOT TO SAY SOMETHING
(2 Nov 2004 21:53:41)
Index Fill Factor suddenly changes to 5% by itself
(2 Nov 2004 20:22:47)
Hung in Loading.....
(2 Nov 2004 20:5:42)
Attaching Corrupt MDF File
(2 Nov 2004 16:28:31)
Dynamic Where with IN Clause
(2 Nov 2004 16:3:34)
Language Issue
(2 Nov 2004 15:3:45)
DTS package question.
(2 Nov 2004 13:59:50)
why does one criteria work and other doesn't?
(2 Nov 2004 12:52:53)
Ecommerce application has choked, seems to be lots of sleeping Process IDs
(2 Nov 2004 4:39:18)
Quick Question
(2 Nov 2004 2:41:46)
[HELP]What should to do after changed IP address of database server in ASE? Thank you
(2 Nov 2004 1:20:29)
lisence info
(1 Nov 2004 17:41:38)
Re: Dynamic Where with IN Clause[Scanned]
(1 Nov 2004 15:31:5)
Re: Storage/Backup Problem
(1 Nov 2004 14:26:30)
Help Needed Urgently
(1 Nov 2004 14:19:36)
Just for laughs
(1 Nov 2004 10:56:43)
Exporting data to CSV
(1 Nov 2004 10:33:13)
Problem in Row Size
(1 Nov 2004 9:59:49)
Online Table Space
(1 Nov 2004 7:13:11)
sql lazydba home page