MS Sql Server

August 2005

Recycle of SQL server Logs
(31 Aug 2005 22:11:1)
ODBC quick to connect EM, QA like a dog
(31 Aug 2005 21:15:48)
MS SQL extended value list
(31 Aug 2005 19:30:26)
elusive performance issues
(31 Aug 2005 18:59:25)
How Do I Decode The Password
(31 Aug 2005 17:45:25)
XP_CMDSHELL
(31 Aug 2005 17:32:47)
Re: [BULK] Database Development
(31 Aug 2005 17:22:42)
Starting jobs
(31 Aug 2005 17:2:27)
DTS - exporting tables to several databases
(31 Aug 2005 15:41:30)
shrink database waits for a long time??
(31 Aug 2005 14:6:48)
Performance issue
(31 Aug 2005 14:6:22)
Backup not writing to log
(31 Aug 2005 11:51:39)
Log Shipping Error
(31 Aug 2005 10:53:33)
Moving Database Servers
(31 Aug 2005 0:27:12)
Update w/ conditional value
(30 Aug 2005 22:37:13)
RAID
(30 Aug 2005 20:25:50)
Privileges required
(30 Aug 2005 19:41:40)
Triggers
(30 Aug 2005 19:9:50)
How to get rid of Single user mode?
(30 Aug 2005 17:23:11)
For XML
(30 Aug 2005 17:17:15)
Linked Server
(30 Aug 2005 16:44:13)
Creating a unique index of a column that can have NULL's
(30 Aug 2005 15:59:40)
Quickshift product
(30 Aug 2005 13:27:42)
Database Development
(30 Aug 2005 13:0:18)
Dynamically calculate variable?
(30 Aug 2005 9:59:47)
Check copy status
(30 Aug 2005 7:36:37)
Server: Msg 4866, Level 17, State 66, Line 1
(30 Aug 2005 6:50:7)
where are database names stored (beyond sysdatabases)
(29 Aug 2005 21:47:5)
MS SQL Server version of ALL_CONS_COLUMNS in Oracle
(29 Aug 2005 19:19:50)
Query on multiple servers
(29 Aug 2005 19:2:15)
Adding an IMAGE column to an existing Table
(29 Aug 2005 19:1:49)
Lost SA Password
(29 Aug 2005 18:18:53)
Any way to find unauthorized user
(29 Aug 2005 13:29:49)
Re: Help with Log Shipping Bug
(29 Aug 2005 13:13:5)
Logshipping compression
(29 Aug 2005 11:29:50)
Important Objects In Oracle
(29 Aug 2005 8:26:19)
LISTOWNER- EMAIL SHIELDING
(27 Aug 2005 13:0:2)
Re: varchar field 32500 in length
(27 Aug 2005 3:40:13)
Getting error running dts package
(26 Aug 2005 21:18:18)
Re: [Posible SPAM] Getting error running dts package
(26 Aug 2005 20:56:35)
XACT_ABORT question
(26 Aug 2005 20:4:49)
Re: Error on Insert Select
(26 Aug 2005 18:51:12)
Errorlevels not propagated on nested triggers...
(26 Aug 2005 18:32:31)
DB Shrink: Time span?
(26 Aug 2005 18:21:30)
Re: [Posible SPAM] DB Shrink: Time span?
(26 Aug 2005 16:8:23)
New Server instance
(26 Aug 2005 15:58:38)
Re: SQL And VB
(26 Aug 2005 13:2:47)
Re: [Potential Spam] Script to generate object grants
(26 Aug 2005 10:52:32)
Data import w/o headings
(26 Aug 2005 9:6:26)
SIZE vs. SPACE AVAILABLE
(26 Aug 2005 0:25:47)
Inconsistent behaviour of SQL
(25 Aug 2005 23:23:33)
Re: [Posible SPAM] SIZE vs. SPACE AVAILABLE
(25 Aug 2005 22:37:3)
Insert value in timestamp ?
(25 Aug 2005 21:7:17)
Script to generate object grants
(25 Aug 2005 20:32:26)
Re: [ Probably SPAM ] Out of Space: Options for reducing DB size
(25 Aug 2005 20:28:51)
Re: [BULK] Out of Space: Options for reducing DB size
(25 Aug 2005 20:25:10)
FOR XML.
(25 Aug 2005 19:57:6)
Out of Space: Options for reducing DB size
(25 Aug 2005 19:30:31)
quickest way to find out if a record exists
(25 Aug 2005 17:16:53)
Creating Multiple Views
(25 Aug 2005 15:47:41)
Records Affected
(25 Aug 2005 15:2:20)
Query Analyzer
(25 Aug 2005 14:6:23)
Re: [Potential Spam] RE: Creating Multiple Views
(25 Aug 2005 13:52:55)
Good links For Oracle And Teradata
(25 Aug 2005 4:58:54)
How to get the results of a proc into a table?
(24 Aug 2005 20:59:13)
How to copy privileges from one user to another
(24 Aug 2005 17:35:17)
Re: SQL Database Owner - Paste in QA
(24 Aug 2005 16:16:2)
integration services
(24 Aug 2005 15:21:43)
Unused columns
(24 Aug 2005 15:9:35)
Foreign Keys -vs- Performance
(24 Aug 2005 14:6:5)
Failure during rule firing(s)
(24 Aug 2005 9:9:49)
SQL Database Owner
(24 Aug 2005 9:8:32)
(3) SQL SERVER 2005: INSERT Images/Pictures FROM a FOLDER to my Table/Field with Data type Image
(24 Aug 2005 6:47:28)
Question about sysprocesses
(24 Aug 2005 0:22:23)
Re: Full Outer Join with Where Clause
(24 Aug 2005 0:6:23)
I have a problem too....
(23 Aug 2005 21:32:29)
I have a big problem
(23 Aug 2005 21:11:45)
(5) SQL SERVER 2005: INSERT Images/Pictures FROM a FOLDER to my Table/Field with Data type Image
(23 Aug 2005 19:3:25)
(4) SQL SERVER 2005: INSERT Images/Pictures FROM a FOLDER to my Table/Field with Data type Image
(23 Aug 2005 18:50:39)
Disconnecting Users
(23 Aug 2005 18:49:15)
Client tools install
(23 Aug 2005 18:42:34)
timings
(23 Aug 2005 18:10:27)
DBCC SHOWCONTIG
(23 Aug 2005 17:43:46)
(2) SQL SERVER 2005: INSERT Images/Pictures FROM a FOLDER to my Table/Field with Data type Image
(23 Aug 2005 16:36:7)
(1) SQL SERVER 2005: INSERT Images/Pictures FROM a FOLDER to my Table/Field with Data type Image
(23 Aug 2005 14:15:16)
store proc permission
(23 Aug 2005 13:29:32)
Re: Spam:RE: Query Analyzer
(23 Aug 2005 0:47:19)
Error message ??
(22 Aug 2005 23:38:9)
Replication database in sql 2000 - Can destination table be different name ?
(22 Aug 2005 17:23:1)
NCHAR(260)
(22 Aug 2005 15:6:51)
Restore lost Stored Proc
(22 Aug 2005 12:36:33)
sp_detach_db and sp_attach_db scripts ...
(22 Aug 2005 12:32:36)
script for databases creation
(22 Aug 2005 11:57:1)
Generate DDL script for databases
(22 Aug 2005 1:6:18)
SQL Server: Obtain all the objects ina a Database
(21 Aug 2005 0:19:8)
Question regarding NetLibs
(20 Aug 2005 2:36:40)
Connectivity Issues
(19 Aug 2005 19:49:54)
Trace reults
(19 Aug 2005 19:27:27)
RESTORE problems
(19 Aug 2005 17:58:50)
Making database transfer too complicated?
(19 Aug 2005 15:24:0)
full-text catalog
(19 Aug 2005 14:11:22)
Re: How to update 2 tables
(19 Aug 2005 10:21:4)
Service account Greyed out in EM
(19 Aug 2005 8:59:47)
script to checking jobs that failed
(19 Aug 2005 8:34:8)
How to shrink LDF file
(19 Aug 2005 7:35:59)
Attaching/detaching databases or moving MDF/LDF files
(19 Aug 2005 4:45:2)
Re: Strip Unwanted Characters
(18 Aug 2005 18:45:49)
Server Monitoring Tool
(18 Aug 2005 18:23:43)
Detaching MSDB
(18 Aug 2005 18:12:17)
Re: Update Nulls
(18 Aug 2005 16:39:40)
SQL 2005 for Developers - Connectivity Tip
(18 Aug 2005 15:48:15)
RE:Strip Unwanted Characters
(18 Aug 2005 14:2:17)
TEMPDB Issue
(18 Aug 2005 13:1:14)
Checking database status
(18 Aug 2005 11:8:28)
SQL SERVER Permissions and Rights
(18 Aug 2005 11:6:22)
Memory consideration
(18 Aug 2005 9:25:1)
SQL Server 7 to 2000
(18 Aug 2005 7:32:27)
SQL Records Filtering,
(18 Aug 2005 1:38:20)
How to determine if a Secondary Index is being used
(17 Aug 2005 21:18:27)
SCOPE_IDENTITY v @@IDENTITY
(17 Aug 2005 21:1:57)
SQL Server - Backup Devices
(17 Aug 2005 18:48:27)
How to lock down Stored Procedures- 2nd Submission
(17 Aug 2005 17:49:58)
Savepoints and Transactions in a batch
(17 Aug 2005 17:47:17)
Converting from 24hr time
(17 Aug 2005 16:45:32)
xp_sqlinventory????
(17 Aug 2005 13:23:6)
page cannot be displayed!
(17 Aug 2005 11:36:19)
reset the identity field to 1
(17 Aug 2005 11:34:26)
Sproc in cache
(17 Aug 2005 8:45:33)
updating 65 records??
(17 Aug 2005 8:23:34)
Difference Between The Number Of Records In Tables
(17 Aug 2005 6:45:41)
Re: *****SPAM***** RE: reset the identity field to 1
(17 Aug 2005 2:46:51)
script for multiple servers
(17 Aug 2005 0:56:29)
Format of Numbers
(16 Aug 2005 23:44:8)
Disabling Multiple Jobs at Once
(16 Aug 2005 18:59:16)
Determining record size and wasted space
(16 Aug 2005 17:3:46)
How to lock down Stored Procedures
(16 Aug 2005 16:9:16)
xp_fixeddrives - total disk space ...
(16 Aug 2005 13:47:47)
Reading a registry value from a stored procedure,
(16 Aug 2005 8:36:2)
Cleaning up the output from SQL scripts ... run from the MSDOS prompt
(15 Aug 2005 23:49:47)
Reindex failure
(15 Aug 2005 18:28:38)
Log file full!
(12 Aug 2005 20:8:48)
Shrink Database
(12 Aug 2005 20:3:20)
SQL 7 to SQL 2000 Help!!!!!!!!!!!!!!!!!!
(12 Aug 2005 19:53:0)
Filtering records while fetching from database,
(12 Aug 2005 19:42:54)
A note about AWE & changing SQL service account ...
(12 Aug 2005 19:37:40)
Moving Databases From one Server to Another
(12 Aug 2005 19:1:7)
jods transfer
(12 Aug 2005 18:38:32)
Please Help!
(12 Aug 2005 16:46:35)
SQL syntax advice please?
(12 Aug 2005 16:39:4)
one source, multiple database connection?
(12 Aug 2005 15:54:38)
DTS Packages
(12 Aug 2005 14:10:40)
Finding Duplicate Row
(12 Aug 2005 12:54:16)
SQL or MySQL
(12 Aug 2005 12:21:8)
R: SQL syntax advice please?
(12 Aug 2005 8:45:40)
Difference between Select Into & Bulk Transfer
(12 Aug 2005 8:37:32)
Re: [RMX:#] SQL Query
(12 Aug 2005 8:5:9)
Sql Query
(12 Aug 2005 7:10:5)
Oracle Backup
(11 Aug 2005 22:5:29)
Re: [SPAM:BAYESIAN] - RE: Spam:RE: Finding Duplicate Row - Bayesi an Filter detected spam
(11 Aug 2005 19:33:6)
logging log on attempts and locking out a user
(11 Aug 2005 18:46:34)
Re: Spam:RE: Finding Duplicate Row
(11 Aug 2005 18:19:14)
Re: ***SPAM***Re: replication question
(11 Aug 2005 18:18:29)
Duplicate records
(11 Aug 2005 18:11:42)
Replication Question
(11 Aug 2005 18:10:21)
user login question
(11 Aug 2005 17:2:11)
DTS MAPI problem
(11 Aug 2005 17:1:43)
Request SQL Server DBA's Daily Routine
(11 Aug 2005 16:35:29)
Cannot Shrink Database
(11 Aug 2005 15:36:37)
SQL Server DBA's Daily Routine
(11 Aug 2005 11:19:56)
database in suspect mode
(11 Aug 2005 7:58:11)
replication / Reporting Services question
(10 Aug 2005 20:26:16)
Login Failed for user 'sa' from Kanishka
(10 Aug 2005 17:39:50)
Good Sites related Database clustering.
(10 Aug 2005 12:9:37)
Starting Command Prompt From SQL Query Analyzer (SQL Server 2000)
(10 Aug 2005 11:51:43)
OpenQuery issue
(10 Aug 2005 11:44:29)
Example script to disable log shipping ....
(9 Aug 2005 23:4:21)
mssqlserver service will not start
(9 Aug 2005 22:48:24)
Also to the backup Error
(9 Aug 2005 21:26:50)
SQL Error during backups
(9 Aug 2005 21:13:58)
Re: [SPAM:HEADER] - SQL Error during backups - Number of numbers in MIME From exceeds maximum threshold
(9 Aug 2005 21:10:12)
Re: [SPAM:BAYESIAN] - RE: Starting Enterprise Manager From SQL Qu ery Analyzer (SQL Server 2000) - Bayesian Filter detected spam
(9 Aug 2005 20:47:30)
Starting Enterprise Manager From SQL Query Analyzer (SQL Server 2000)
(9 Aug 2005 20:37:16)
Starting Enterprise Manager From SQL Query Analyzer
(9 Aug 2005 20:33:35)
Re: [SPAM:HEADER] - RE: Starting Enterprise Manager From SQL Quer y Analyzer (SQL Serv er 2000) - Number of numbers in MIME From exceeds ma ximum threshold
(9 Aug 2005 19:18:1)
Large Batch Job
(9 Aug 2005 18:39:59)
Finding all tables where a particular column has a given value
(9 Aug 2005 18:39:34)
Performance question on dropping/creating a table with clustered index
(9 Aug 2005 18:12:0)
How can I rebuild the MSDB database in a Sql 2000 server?
(9 Aug 2005 16:6:3)
Special characters..
(9 Aug 2005 15:57:23)
SQL server agent e-mail
(9 Aug 2005 15:4:54)
Installation Question
(9 Aug 2005 14:1:59)
quickie
(9 Aug 2005 13:48:33)
Restoring MSDB & Master
(9 Aug 2005 12:45:7)
Creating a userdefined role.
(9 Aug 2005 9:23:23)
running DTS from batch file
(9 Aug 2005 6:7:6)
Extract to Excel file
(9 Aug 2005 2:38:34)
Import data from password protected .xls
(8 Aug 2005 22:26:44)
delete rows that have certain value
(8 Aug 2005 19:39:10)
Count Vs. sp_SpaceUsed
(8 Aug 2005 17:13:25)
Re: (S) SQL Server 2005 Console PGM Connection (Visual Studio 2005)
(8 Aug 2005 17:10:12)
DTS Package runs, but scheduled job fails
(8 Aug 2005 17:6:58)
Re: (2) SQL Server 2005 Console PGM Connection (Visual Studio 2005)
(8 Aug 2005 16:43:18)
SQL Server 2005 Console PGM Connection (Visual Studio 2005)
(8 Aug 2005 16:18:56)
Orphaned dbo
(8 Aug 2005 15:44:37)
DB maintenance plans
(8 Aug 2005 13:19:25)
AWE Memory Question?
(8 Aug 2005 3:26:26)
Disk Fragmentation
(8 Aug 2005 2:18:7)
Dump Anyone
(7 Aug 2005 22:39:31)
Full Backup keeps failing..
(6 Aug 2005 19:21:1)
Can I get your Opinions
(5 Aug 2005 21:8:26)
Re: *****SPAM***** RE: create Trigger with not null value
(5 Aug 2005 16:2:10)
spt_values
(5 Aug 2005 15:50:48)
"Redirection exe error"
(5 Aug 2005 15:48:7)
SQL Reports
(5 Aug 2005 15:16:2)
Finding Special Characters
(5 Aug 2005 14:58:52)
Optimization error
(5 Aug 2005 13:54:20)
Database Corrupted.
(5 Aug 2005 12:31:16)
Bulk insert data conversion error (overflow) bigint
(5 Aug 2005 9:47:14)
Use of Cursors in Triggers
(5 Aug 2005 9:26:25)
DTS Active X
(5 Aug 2005 7:21:32)
Order by and case stmt
(5 Aug 2005 6:53:23)
create Trigger with not null value
(5 Aug 2005 6:46:47)
Trigger authority
(5 Aug 2005 2:11:8)
Re: DTS Active X - Win Zip
(5 Aug 2005 0:3:20)
Best practices to use with custom error messages
(4 Aug 2005 23:54:48)
Sending Email if Store procedure fails,
(4 Aug 2005 18:36:42)
Recommended removal of indexes
(4 Aug 2005 18:28:29)
Modify Tables in a Merge Replication
(4 Aug 2005 18:19:37)
Deadlocks
(4 Aug 2005 17:24:46)
how to handle text or ntext vaible in the function?
(4 Aug 2005 16:58:46)
Duplicate fields
(4 Aug 2005 16:57:28)
using 'top 1' to define selectivity
(4 Aug 2005 16:38:48)
Joining to sysdatabases
(4 Aug 2005 16:20:21)
Profiler -> Trace Template -> Indexing Wizard
(4 Aug 2005 15:49:15)
Follow Up to Which is better
(4 Aug 2005 15:46:31)
How do I retrieve the information in the Description field of the Design Table function
(4 Aug 2005 15:16:2)
Zipping Files
(4 Aug 2005 15:8:7)
Create trigger?
(4 Aug 2005 13:53:53)
Date and time Function
(4 Aug 2005 13:45:52)
tempdb is 65GB and it's filling
(4 Aug 2005 13:39:21)
Transection LOG
(4 Aug 2005 12:43:21)
rows to columns
(4 Aug 2005 11:33:25)
moving data from one server to another
(4 Aug 2005 11:4:2)
64 bit Analysis Server
(4 Aug 2005 8:28:58)
"Server: Msg 11, Level 16, State 1, Line 0"
(4 Aug 2005 8:25:1)
Query in Restoring
(4 Aug 2005 8:7:43)
SQL DB incremental backup scrip
(4 Aug 2005 2:57:22)
Re: rows to columns No takers
(4 Aug 2005 0:5:34)
how to create a temp table using 2 tables and insert the details
(3 Aug 2005 23:41:24)
Select * takes very long time on SQL Server
(3 Aug 2005 21:38:40)
use of composite non-clustered indexes
(3 Aug 2005 21:19:48)
Declarative SQL Syntax Question
(3 Aug 2005 20:36:47)
Passing Text Values as a parameter
(3 Aug 2005 20:16:19)
missing client records for each database
(3 Aug 2005 20:13:22)
Transparent Gateway from Oracle
(3 Aug 2005 17:12:51)
DTS HELP
(3 Aug 2005 16:58:11)
How do I insert, update, delete pictures in SQL Server?
(3 Aug 2005 16:46:38)
shrink tempdb options
(3 Aug 2005 15:23:36)
Query in Stored procedure
(3 Aug 2005 14:57:29)
Primary Key
(3 Aug 2005 14:12:24)
Which is Better
(3 Aug 2005 13:59:0)
odbc
(3 Aug 2005 13:54:38)
ODBC SQL Connections Problem
(3 Aug 2005 13:38:46)
Time out error
(3 Aug 2005 12:44:54)
Re: [RMX:#] SQLServer port
(3 Aug 2005 10:28:57)
SQLServer port
(3 Aug 2005 7:53:8)
Transactions are not Getting close
(3 Aug 2005 4:24:16)
Error trying to restore database
(2 Aug 2005 23:14:26)
Backing up databases
(2 Aug 2005 22:44:15)
Single line output
(2 Aug 2005 22:38:10)
defragging - is it worth it?
(2 Aug 2005 21:14:40)
Deleting broken users
(2 Aug 2005 20:18:56)
Problem with Linked Server and Windows Group
(2 Aug 2005 19:12:12)
Question
(2 Aug 2005 18:52:47)
Important article everyone should read
(2 Aug 2005 18:39:55)
Error 7399 in SQL Server
(2 Aug 2005 16:31:3)
CHARINDEX
(2 Aug 2005 15:29:31)
query problem
(2 Aug 2005 13:42:3)
Monitoring using profiler
(2 Aug 2005 13:40:21)
Error Establishing Socket
(2 Aug 2005 12:43:2)
trigger not firing properly
(2 Aug 2005 11:30:19)
moving some data from one database to another...
(2 Aug 2005 8:34:44)
IBM server with raid controller crashing when Oracle resizes database.
(2 Aug 2005 2:43:16)
slowness on the server
(2 Aug 2005 1:23:38)
Script to generate the create database, create table scripts ...
(2 Aug 2005 1:22:43)
SQL timeouts
(1 Aug 2005 23:4:35)
Oracle to Sql Server
(1 Aug 2005 21:41:20)
SQL Server 2005 Education
(1 Aug 2005 18:50:13)
full text indexes
(1 Aug 2005 16:9:40)
Reindex task filling disk
(1 Aug 2005 10:54:38)
Performance Tunning
(1 Aug 2005 3:56:45)
sql lazydba home page