MS Sql Server

January 2007

SQL Trace at start-up SQL 2005
(31 Jan 2007 23:41:52)
Backup
(31 Jan 2007 21:33:11)
Question on ActiveX Updates
(31 Jan 2007 19:11:5)
Archiving on sybase version 12.5
(31 Jan 2007 18:56:32)
Upgrade Oracle 8.1.7.4 to 10g release 2
(31 Jan 2007 17:47:46)
Script Database
(31 Jan 2007 17:39:14)
seeking advice on potential concurreny issue
(31 Jan 2007 17:14:53)
URGENT: Linked Server
(31 Jan 2007 16:20:52)
changing tempdb collation
(31 Jan 2007 15:48:21)
How to format text output?
(31 Jan 2007 14:47:57)
what is bypass recovery mode.
(31 Jan 2007 13:3:17)
Kill spids automatically
(31 Jan 2007 12:33:4)
How can I attach a SQL2000 database that only has .MDF file
(31 Jan 2007 11:20:27)
Constraint
(31 Jan 2007 11:17:29)
Question about logic and stored procs
(31 Jan 2007 11:7:37)
attach 200db in 2005
(31 Jan 2007 9:51:8)
Need to exec long SQL string
(31 Jan 2007 5:4:39)
SQL Server Service not starting
(31 Jan 2007 4:40:21)
SQL Server Time to Epoch
(31 Jan 2007 0:58:6)
ODBC driver for 2005
(30 Jan 2007 22:44:53)
Memo to INT
(30 Jan 2007 21:41:49)
Right server architecture for SQL Server 2005
(30 Jan 2007 20:40:58)
"SQL Server 2000 DTS Designer Components for SQL Server 2005" on a 64 bit (non-Itanium) box
(30 Jan 2007 19:20:38)
Connection to Sybase from Sql server 2005
(30 Jan 2007 18:5:25)
Scripting of DTS packages for MSSQL 2000
(30 Jan 2007 15:5:8)
Deleted Trigger
(30 Jan 2007 14:54:44)
added memory - need to configure SQL Server 2000
(30 Jan 2007 14:53:35)
Job Status
(30 Jan 2007 12:32:20)
disbaling constraints,indexes and triggers
(30 Jan 2007 8:28:42)
Issue with DB
(30 Jan 2007 6:59:54)
SQL Cluster fail, rogue SQL exe running on old node
(30 Jan 2007 5:41:29)
View Oracle Data from SQL Server
(29 Jan 2007 20:28:31)
Change default db
(29 Jan 2007 19:29:58)
DBcc ShrinkFile Verses DBcc Shrink DataBase
(29 Jan 2007 18:15:22)
comparison of SQL 2000 and 2005...
(29 Jan 2007 18:5:47)
Client Access Version
(29 Jan 2007 18:3:7)
Re: Slooow Query-Thanx
(29 Jan 2007 17:55:52)
Slooow Query
(29 Jan 2007 17:44:22)
Log-Shiiping
(29 Jan 2007 16:51:19)
index fragmentaion levels
(29 Jan 2007 16:50:37)
I'm outa here.
(29 Jan 2007 15:34:47)
Restore sql server database using entreprise manager and tivoli data protection
(29 Jan 2007 10:22:58)
select * is faster!!?
(29 Jan 2007 9:30:53)
Selecting subset of a data from specific column
(29 Jan 2007 9:28:54)
Isqlplus - error message unable to open jar file
(29 Jan 2007 9:26:35)
using profiler
(29 Jan 2007 9:20:1)
Email Check
(29 Jan 2007 9:19:31)
is using dbcc updateusage have any impact on performance
(29 Jan 2007 5:50:58)
help with echo
(29 Jan 2007 5:38:19)
Fragmentation
(27 Jan 2007 17:48:48)
LISTOWNER- EMAIL SHIELDING
(27 Jan 2007 14:0:2)
float and real (dollars and cents)
(26 Jan 2007 23:25:57)
Database Corruption Issues
(26 Jan 2007 22:4:9)
HELP:Add blank rows to a table in a report
(26 Jan 2007 20:28:33)
Last Updated
(26 Jan 2007 20:25:42)
Dumb Question #1
(26 Jan 2007 20:21:40)
Insert 01/01/1700 into oracle from sqlserver
(26 Jan 2007 19:59:26)
Retrieving duplicates in one column
(26 Jan 2007 17:22:24)
Divide by zero
(26 Jan 2007 16:57:49)
SQL Server 2000 and 2005 Requirements
(26 Jan 2007 16:1:19)
Identity Columns and Column Order
(26 Jan 2007 12:57:51)
Log tool reader
(26 Jan 2007 8:33:7)
Service Broker error -- Pulling my hair out
(25 Jan 2007 23:11:21)
Sql Query
(25 Jan 2007 20:45:47)
query question - possible combinations from column value
(25 Jan 2007 18:16:19)
Size of Table
(25 Jan 2007 16:22:23)
SQL Server Loadbalancing
(25 Jan 2007 15:44:36)
create linked server across domain
(25 Jan 2007 15:42:49)
Two Questions on Running Multiple Instances on SQL 2005
(25 Jan 2007 15:41:13)
What is the Better Way To Shrink The DataBase
(25 Jan 2007 14:44:15)
drive size
(25 Jan 2007 14:40:35)
MSSQL 2000 Maintenance Jobs Hanging
(25 Jan 2007 14:9:55)
index question
(25 Jan 2007 14:0:3)
Langauge Issue
(25 Jan 2007 13:16:55)
Unused Space Is More Than Data Size
(25 Jan 2007 12:40:25)
Books on Sql Server 2005
(25 Jan 2007 6:12:16)
Issue in DBCC DBREINDEX
(25 Jan 2007 5:39:11)
How can enable AD Hoc on my server?
(25 Jan 2007 5:14:15)
compare list items with each other only once
(25 Jan 2007 4:15:44)
Reporting Services Email Subscription
(25 Jan 2007 3:29:34)
Scheduled Cmdshell job fails
(24 Jan 2007 23:18:9)
Fail-safe operator problem
(24 Jan 2007 22:46:6)
Heterogeneous queries error
(24 Jan 2007 22:15:1)
Data transformation into an xls file
(24 Jan 2007 22:10:50)
Enterprise Manager connection SQL2000 on same server as SQL2005
(24 Jan 2007 21:25:23)
need help on linked server
(24 Jan 2007 18:36:10)
xp_sendmail very slow
(24 Jan 2007 17:23:39)
Database drive size
(24 Jan 2007 17:21:48)
INSER TRIGGER
(24 Jan 2007 16:34:41)
Trigger question...
(24 Jan 2007 16:32:13)
Trigger Help!
(24 Jan 2007 14:29:9)
Corrupt MDF file
(24 Jan 2007 12:34:32)
Loading Event Logs
(24 Jan 2007 6:57:4)
Help[ - suspect database
(24 Jan 2007 6:55:23)
Performance question--urgent
(24 Jan 2007 4:38:49)
accessing active dirctory
(24 Jan 2007 0:29:30)
How to move nonclustered indexes in SQL Server 2005
(23 Jan 2007 21:17:27)
How to avoid truncating the string after the &
(23 Jan 2007 17:32:22)
Maintenance Plan
(23 Jan 2007 17:21:57)
IMPACT OF TRUNCATE TABLE
(23 Jan 2007 17:0:16)
Automatically going into single user mode!
(23 Jan 2007 15:41:31)
How to Monitor Sql Server Service (Urgent)
(23 Jan 2007 15:23:8)
Windows script (.cmd) to delete aged files
(23 Jan 2007 10:26:10)
Execution Plan
(23 Jan 2007 3:26:25)
SQL 2005 bulk update of XML data type
(22 Jan 2007 23:25:20)
SalesLogix Postgresql
(22 Jan 2007 21:34:4)
ActiveX problems...help!
(22 Jan 2007 19:50:30)
SalesLogix
(22 Jan 2007 19:1:34)
SQL Server restarting on it's own!
(22 Jan 2007 16:49:2)
textcopy
(22 Jan 2007 16:33:19)
Backup Failed
(22 Jan 2007 14:50:54)
Looking for maintenance job which run the backup of full and diferential backups
(22 Jan 2007 14:45:14)
relicated database donot alow to make any change in its table structure (urgent pls help )
(22 Jan 2007 14:10:41)
replicated database donot alow to make any change in its table structure (urgent pls help )
(22 Jan 2007 13:2:12)
Error 15405
(22 Jan 2007 8:51:19)
Help on linked server?
(21 Jan 2007 20:56:48)
Job Opportunity
(20 Jan 2007 18:29:53)
Question on updating SQL-86 joins.
(20 Jan 2007 14:4:5)
index tunning wizard shows negative results
(20 Jan 2007 5:56:35)
HELP UNINSTALL 2000 on CLUSTERED NODE
(20 Jan 2007 5:14:27)
Re: Suspected Spam: SQL 2005 SP2
(19 Jan 2007 22:41:27)
SQL 2005 Admin Tools
(19 Jan 2007 20:54:58)
Replication again....
(19 Jan 2007 18:6:22)
polite way to...kill
(18 Jan 2007 19:14:11)
Long distance query problem (not lag)
(18 Jan 2007 17:46:35)
SQL 2005 SP2
(18 Jan 2007 16:47:19)
Off the cuff CPU querying.
(18 Jan 2007 15:34:58)
Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
(18 Jan 2007 14:9:18)
DTS to alert when a query doesn't retrieve any records
(18 Jan 2007 12:28:24)
RTRIM question for outputting to a text file
(18 Jan 2007 12:4:50)
index size
(18 Jan 2007 11:56:2)
HELP!!! Different results on replicated databases
(18 Jan 2007 9:12:23)
Select * VS Select col1,col2...
(17 Jan 2007 22:53:8)
Re: [BULK] Permissions problem after db migration
(17 Jan 2007 21:41:21)
SQL 2005 SP 1 BUG
(17 Jan 2007 21:34:56)
database delete notification
(17 Jan 2007 20:49:10)
Re: Select * VS Select col1,col2.
(17 Jan 2007 19:48:45)
set recovery in 6.5
(17 Jan 2007 19:47:18)
Opinion on torn page detection option
(17 Jan 2007 18:55:22)
Parsing a string
(17 Jan 2007 18:15:20)
Migrate from sql server 2000 32bits to sql server 64bits
(17 Jan 2007 17:33:45)
SSIS Import Wizard
(17 Jan 2007 17:25:24)
DATABASE MAINTENANCE
(17 Jan 2007 15:37:10)
T-SQL (Urgent!)
(17 Jan 2007 15:3:49)
noob question.
(17 Jan 2007 13:51:53)
Adding an image file to table
(17 Jan 2007 0:13:16)
Permissions problem after db migration
(17 Jan 2007 0:6:0)
DTS Package Issue
(16 Jan 2007 21:29:35)
Odd parrallelism Error
(16 Jan 2007 21:26:39)
SQL 2005 Database Maintenance
(16 Jan 2007 19:32:41)
memory usage matrix
(16 Jan 2007 19:29:57)
Can you or Should you move constraints to a different filegroup t han the data
(16 Jan 2007 19:22:19)
Windows 2003 SP1.
(16 Jan 2007 18:36:46)
Autoincrement column
(16 Jan 2007 18:8:18)
SQLH2 Problems
(16 Jan 2007 17:54:10)
How to implement a backup strategy with full and incremental
(16 Jan 2007 16:17:13)
renaming
(16 Jan 2007 15:54:40)
SQL MCDBA
(16 Jan 2007 15:1:58)
SQL Server - How to Change Login Name from Local to Windows Authentication?
(16 Jan 2007 14:38:27)
getdate
(16 Jan 2007 14:4:25)
replication problems
(16 Jan 2007 13:58:20)
Implicit conversion...
(16 Jan 2007 13:49:0)
BI and Warehousing
(16 Jan 2007 13:48:22)
SQLAgent Running
(16 Jan 2007 11:42:1)
Gaps in IDENTITY enabled table..
(16 Jan 2007 8:20:32)
SQL Server + Crystal Report - Urgent
(16 Jan 2007 7:14:53)
Store procedure content
(16 Jan 2007 7:4:40)
Removing identity attribute on a table
(16 Jan 2007 7:4:33)
nhibernate
(15 Jan 2007 22:39:6)
Re: Suspected Spam: How to Find Current execution Sql Query : URGENT
(15 Jan 2007 21:53:54)
Re: Assigning Rights to a Database
(15 Jan 2007 21:39:27)
Re: Suspected Spam: RE: Relate Data Across Databases
(15 Jan 2007 21:33:46)
Relate Data Across Databases
(15 Jan 2007 20:11:59)
Is there a way to save a column name in a script as a file name?
(15 Jan 2007 15:46:36)
Re: SQL Collation
(15 Jan 2007 14:24:28)
How can i get row id of particular row
(15 Jan 2007 14:19:58)
Get the Index of Row
(15 Jan 2007 13:23:37)
Re: Version of sql server installed(32bits or 64 bits) (Open)
(15 Jan 2007 12:7:49)
Version of sql server installed(32bits or 64 bits)
(15 Jan 2007 10:54:15)
How to Find Current execution Sql Query : URGENT
(15 Jan 2007 9:38:56)
Security policy for each Windows user on sql server
(15 Jan 2007 9:7:50)
Sql Query for IO usage
(15 Jan 2007 6:48:5)
SQL Query - Urgent
(13 Jan 2007 12:5:44)
Can't edit this celýl...
(13 Jan 2007 8:29:55)
Maybe a case statement?
(12 Jan 2007 18:45:41)
monitor linked server connection
(12 Jan 2007 17:41:57)
IN DBCC INPUTBUFFER only first 255 char shows
(12 Jan 2007 16:4:34)
OT : Coupon
(12 Jan 2007 15:59:37)
Bulk insert problem
(12 Jan 2007 15:15:28)
Active/Active Setup
(12 Jan 2007 13:49:57)
Permission Question
(12 Jan 2007 13:32:29)
Ending a DTS package
(12 Jan 2007 13:19:29)
Temp Tables
(12 Jan 2007 6:25:48)
table name from page id
(11 Jan 2007 23:39:38)
Default for Function Parameter
(11 Jan 2007 22:36:45)
Data type incompatibility in SSIS package
(11 Jan 2007 15:59:5)
SQL Server - How to calculate the groth of databases during a period of time
(11 Jan 2007 14:5:21)
Re: Restore transaction log file after truncate log file
(11 Jan 2007 13:12:0)
Escape character
(11 Jan 2007 9:26:36)
Why put an N before a quoted value?
(11 Jan 2007 2:10:1)
Scripting Triggers?
(10 Jan 2007 21:33:48)
code to extract numeric portion from a string
(10 Jan 2007 19:52:23)
distinct UNION
(10 Jan 2007 19:33:10)
2005 Replication
(10 Jan 2007 16:10:5)
Reporting Services in a windows app
(10 Jan 2007 15:14:50)
How to build an array from Sql Server 2005 table data??
(10 Jan 2007 14:17:40)
NOLOCK issue
(10 Jan 2007 13:28:22)
Transaction Isolation Levels
(10 Jan 2007 13:23:19)
Restore tarnsaction log file after truncate log file
(10 Jan 2007 12:52:32)
query completed with errors
(10 Jan 2007 9:59:25)
Weird results......
(10 Jan 2007 7:13:54)
Error Deleting SQL Job
(9 Jan 2007 23:17:44)
Assign NIC Card to INSTANCE
(9 Jan 2007 21:8:24)
Runaway optimization job and database size
(9 Jan 2007 20:33:19)
Printing an .ER1 file without ERWin
(9 Jan 2007 20:27:17)
/Oracle1 and /Oracle4
(9 Jan 2007 17:49:31)
Help with variables in SSIS
(9 Jan 2007 16:42:31)
Importing Flat Files - SSIS
(9 Jan 2007 15:11:14)
Replication
(9 Jan 2007 15:1:51)
International Address Consideration
(9 Jan 2007 14:59:42)
Re: truncating transaction log (Private)
(9 Jan 2007 9:39:18)
Update statistics
(8 Jan 2007 22:28:48)
truncating transaction log
(8 Jan 2007 21:51:15)
need some help with mapping a table
(8 Jan 2007 21:50:33)
Variable type incompatable in SSIS
(8 Jan 2007 21:48:57)
Automating DML statement
(8 Jan 2007 21:48:2)
Re: Possible Spam: truncating transaction log
(8 Jan 2007 20:40:36)
Killing an optimization job
(8 Jan 2007 20:12:51)
Re: Suspected Spam: Groups for Users in SQL
(8 Jan 2007 19:48:55)
Groups for Users in SQL
(8 Jan 2007 18:32:5)
XML data type, XSD and other X-files: Is the truth out there?
(8 Jan 2007 18:16:15)
Cursor read-only, but only sometimes...
(8 Jan 2007 16:31:15)
@@who variable
(8 Jan 2007 13:34:9)
SQLServer2005 Studio. How to limit database list.
(8 Jan 2007 13:3:52)
Transactionlog backup failure
(8 Jan 2007 12:10:26)
DBERRORS WEBSERVICE Message: Could not find server 'IceSystem' in sysservers.
(8 Jan 2007 10:16:8)
Seeing a lot of 17883 Errors lately on various clusters
(7 Jan 2007 0:8:50)
Disk Usage Per Table...
(6 Jan 2007 0:2:55)
Restore DB Job
(5 Jan 2007 22:7:10)
Re: Suspected Spam: moving SQL Server 2000 install to a different drive on same server
(5 Jan 2007 21:31:2)
Question: How to read values from a flat file into sql variables
(5 Jan 2007 21:11:37)
differences between being DBO and having DBO privilages
(5 Jan 2007 21:5:19)
moving SQL Server 2000 install to a different drive on same server
(5 Jan 2007 19:57:42)
datatype size in bye -- urgent
(5 Jan 2007 16:33:38)
SQL LiteSpeed
(5 Jan 2007 16:21:29)
Escalated Permissions Unexplained ?
(5 Jan 2007 13:46:28)
RE:Still looking for help - Linked Servers Issues using DTS DDQ Task
(5 Jan 2007 12:43:12)
Re: Manually grow db (Private)
(5 Jan 2007 10:23:0)
Manually grow db
(5 Jan 2007 10:15:56)
Appending Data DTS Packages
(5 Jan 2007 9:37:22)
SQL 6.5 Cannot Alter Table
(5 Jan 2007 5:19:27)
Conversion from Oracle Stored Procedure to SQL Server stored procedure
(5 Jan 2007 3:19:40)
Re: Finding Index Hints
(5 Jan 2007 0:54:42)
Linked Servers Issues using DTS DDQ Task
(4 Jan 2007 20:19:15)
DB space and transactionlog space
(4 Jan 2007 20:1:4)
MSSQLSERVER2000 Clustering Books
(4 Jan 2007 16:33:35)
SSIS Packages using SQL Authentication
(4 Jan 2007 16:30:1)
What is the impact of running server-side trace in sql 2000...
(4 Jan 2007 15:29:30)
User having problem accessing application
(4 Jan 2007 15:20:55)
Partitioned View
(4 Jan 2007 15:19:27)
Issue with View
(4 Jan 2007 14:47:9)
Re: creating format file -- please help.
(4 Jan 2007 6:30:20)
Need help
(4 Jan 2007 5:30:44)
creating format file
(4 Jan 2007 4:35:30)
Olap
(4 Jan 2007 0:26:17)
Report Services
(3 Jan 2007 22:28:6)
SSIS packages
(3 Jan 2007 21:13:20)
Functions and Missing Parameters
(3 Jan 2007 21:4:4)
SQL 2000 Permissions
(3 Jan 2007 20:19:47)
Insert calculated values into a column based on a join condition
(3 Jan 2007 18:48:28)
Defaults Only???
(3 Jan 2007 18:24:5)
Server does not exist or access denied
(3 Jan 2007 16:33:54)
SPIDs
(3 Jan 2007 16:29:51)
Fast Count of Rows in a Big Table?
(3 Jan 2007 15:58:11)
Re: Reporting Services and citrix
(3 Jan 2007 15:57:32)
IDENT_CURRENT returns last value + 1 in SQL 2005 instead of just last value
(3 Jan 2007 15:3:13)
SQL Documentation Tools
(3 Jan 2007 11:51:6)
if the total rows of a table exceeds 2147483647 in SQL 2000?
(3 Jan 2007 10:15:19)
Sql Replication
(2 Jan 2007 23:25:50)
How to update only part of a columns data?
(2 Jan 2007 21:50:41)
Newbie: Criteria for new instances
(2 Jan 2007 18:30:31)
Archiving data without filling up Transaction log
(2 Jan 2007 17:18:1)
Re: security account delegation repost
(2 Jan 2007 16:23:39)
SQL Backup
(2 Jan 2007 13:5:38)
sql lazydba home page