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