MS Sql Server

December 2006

Server does not exist or access denied
(31 Dec 2006 20:52:26)
Stored Procedure to List Tables, Rowcount?
(31 Dec 2006 4:42:36)
LISTOWNER- EMAIL SHIELDING
(30 Dec 2006 14:0:3)
HAPPY NEW YEAR
(30 Dec 2006 9:26:42)
HAPPY NEW YEAR!!!!
(30 Dec 2006 9:7:18)
SQL Backup
(30 Dec 2006 5:22:22)
Rebuilding all indexes on all table
(29 Dec 2006 17:34:0)
Failover Cluster
(29 Dec 2006 16:44:17)
SQL Server - stoted procedure using text data type
(29 Dec 2006 11:35:58)
How do I capture text after @ sign
(29 Dec 2006 4:5:51)
How to Backup DB
(29 Dec 2006 3:26:34)
security account delegation
(28 Dec 2006 17:42:19)
error Msg 8115
(28 Dec 2006 15:22:49)
TOA$D for SQL Server
(28 Dec 2006 14:49:10)
Urgent log file full issue
(28 Dec 2006 14:36:22)
Restoring a particular table from a dump file
(28 Dec 2006 14:35:26)
Tab to space (SSMS)
(28 Dec 2006 14:29:51)
Oracle Database 11G
(28 Dec 2006 14:15:16)
ROBUST PLAN option
(27 Dec 2006 20:55:24)
Uppercasing Text Datatype
(27 Dec 2006 17:52:46)
Simulate the Oracle and DB2 MERGE Statement in SQL Server
(27 Dec 2006 16:20:40)
Last Updated Row
(27 Dec 2006 12:11:59)
Urgent help
(27 Dec 2006 5:55:0)
Exporting data from Oracle and Sybase to Text file and loading it into MS SQL 2005
(26 Dec 2006 7:13:6)
DTS
(26 Dec 2006 7:1:25)
DTS restore.
(26 Dec 2006 6:9:2)
renaming
(23 Dec 2006 10:7:43)
Merry Christmas!!!
(23 Dec 2006 9:42:51)
Urgent - Import SQL Server 2005 mdf & ldf file into SQL Server 2000
(22 Dec 2006 19:3:54)
Job or SSiS
(22 Dec 2006 16:37:0)
Merry Merry Christmas!!!!!!!!!!!!!!
(22 Dec 2006 15:2:4)
Merry Merry Christmas
(22 Dec 2006 12:34:5)
how do I get one row per id?
(21 Dec 2006 21:23:55)
Replication & Log Shipping
(21 Dec 2006 20:52:20)
Log shipping to another instance on the same physical server
(21 Dec 2006 20:42:9)
Getting login name - from IIS
(21 Dec 2006 19:29:28)
Quick question regarding escape characters
(21 Dec 2006 19:23:39)
Schedule Job design question
(21 Dec 2006 19:7:54)
Can't save maintenance plan
(21 Dec 2006 15:54:19)
Long Running Jobs?
(21 Dec 2006 15:22:38)
SQL Std to SQL Enterprise Upgrade
(21 Dec 2006 15:19:32)
text for a table
(21 Dec 2006 14:17:43)
Warning Message re Max Row Size
(21 Dec 2006 14:12:7)
index seek Vs Index scan
(21 Dec 2006 9:54:19)
Transfering Maintenance Plans
(21 Dec 2006 4:52:37)
Transfering DTS packages
(20 Dec 2006 22:10:22)
making changes to a whole lot of stored procedures
(20 Dec 2006 21:14:32)
Monitoring Help in 2000
(20 Dec 2006 19:14:31)
Re: red-gate AND Help with SQL Tools please
(20 Dec 2006 18:48:2)
Listing table columns
(20 Dec 2006 18:31:57)
Scripting objects to be released to Production
(20 Dec 2006 18:4:3)
Version control of objects
(20 Dec 2006 18:3:5)
Re: Listing table columns - ORACLE
(20 Dec 2006 17:6:15)
Oh where oh where is my SSIS package?
(20 Dec 2006 16:32:46)
RDMB
(20 Dec 2006 15:13:19)
how to handle this situation
(20 Dec 2006 14:31:13)
NOLOCK issue
(20 Dec 2006 14:27:50)
SSIS Package
(20 Dec 2006 12:20:0)
Re: Scripting help
(20 Dec 2006 12:12:5)
2005 questions
(20 Dec 2006 11:55:7)
Urgent Requirement for Project Manager and Assiatant Project Manager
(20 Dec 2006 9:47:53)
Re: ORACLE data block corrupted
(20 Dec 2006 9:8:50)
Default user database dropped
(20 Dec 2006 8:54:30)
Weird results......
(20 Dec 2006 0:1:39)
Help (DTS Permissions)
(19 Dec 2006 20:49:58)
Attaching a SQL2000 DB to SQL2005 server
(19 Dec 2006 18:49:56)
Why is sql backup file so large?
(19 Dec 2006 17:40:5)
using ActiveX script in DTS to concatenate date to file
(19 Dec 2006 17:34:12)
OSQL and extended character sets
(19 Dec 2006 17:22:15)
ERP Performance Issue
(19 Dec 2006 17:21:12)
Re: ODBC vs Named Pipes
(19 Dec 2006 17:16:17)
SQL 2005 to SQL2000
(19 Dec 2006 16:9:23)
Sql Development with Visual Studio 2005
(19 Dec 2006 15:31:48)
database file growth
(19 Dec 2006 15:26:10)
trigger puzzle
(19 Dec 2006 15:14:9)
Instance2 port number wrong, after 2000 to 2005 upgrade.
(19 Dec 2006 13:42:15)
Required Query Optimization Tips
(19 Dec 2006 13:18:20)
Can Both SQL Server 2000 and 2005 installed in the same machine
(19 Dec 2006 3:59:40)
SQL 2005 Security
(18 Dec 2006 21:21:18)
RAID
(18 Dec 2006 20:5:51)
EMC SAN replication and SQL databases
(18 Dec 2006 20:2:47)
Master comment table vs multiple comment tables
(18 Dec 2006 19:30:19)
Created dated folder
(18 Dec 2006 19:13:12)
DBCC CheckDB - how often to run?
(18 Dec 2006 16:48:21)
Performance/index question
(18 Dec 2006 16:41:45)
Microsoft Support for SQL Server 2000!
(18 Dec 2006 15:6:26)
Re: SQL Server 2005 - space left in datafile (Open)
(18 Dec 2006 14:44:29)
SQL Server 2005 - space left in datafile
(18 Dec 2006 14:30:23)
Alternate Create Table Method
(18 Dec 2006 11:27:59)
what should be the checkList if sql server goes down?
(18 Dec 2006 10:35:35)
vb .net help
(15 Dec 2006 19:49:3)
2000 Security issue
(15 Dec 2006 19:37:52)
SQL Server 2005 Error when Using the Import/Export Wizard
(15 Dec 2006 18:44:40)
Database backup question
(15 Dec 2006 16:12:10)
Re: [***SPAM*** Score/Req: 4.5/3.5] 2000 Security issue
(15 Dec 2006 15:52:13)
Active Directory & ServiceDesk integration with SQL Server
(15 Dec 2006 15:14:54)
Regarding OSQL
(15 Dec 2006 13:34:18)
Shrink Database option
(15 Dec 2006 11:51:38)
sp__DbAccess
(15 Dec 2006 9:8:33)
Legato Backup software
(14 Dec 2006 22:24:11)
Backup Scheme...
(14 Dec 2006 21:25:53)
SQL 2000 perf issue
(14 Dec 2006 16:34:7)
File IDs and Description
(14 Dec 2006 16:25:56)
SQL 2005 Delegation issue
(14 Dec 2006 15:34:16)
timeout errors
(14 Dec 2006 13:51:58)
estimate memory usage
(14 Dec 2006 13:45:12)
old topic new discussion
(14 Dec 2006 13:23:36)
bulk insert not functioning
(14 Dec 2006 13:21:41)
query execution plan
(14 Dec 2006 9:15:13)
ODBC Best Practices
(14 Dec 2006 8:48:57)
performance tuning
(14 Dec 2006 7:26:57)
Update statistics
(14 Dec 2006 4:23:55)
query timeout error-urgent
(14 Dec 2006 3:52:5)
Find owners of objects
(13 Dec 2006 23:39:51)
SQL 2005 (64-bit)/SQL 2000 (32-bit) Replication
(13 Dec 2006 20:54:19)
Special characters
(13 Dec 2006 19:48:38)
Re: [QUAR] RE: DTS Question
(13 Dec 2006 18:47:39)
DTS question
(13 Dec 2006 17:31:3)
(2nd Try) Is it possible to.......
(13 Dec 2006 16:17:50)
Been staring too long (QRY Help)
(13 Dec 2006 15:52:57)
2005 question to view jobs
(13 Dec 2006 15:23:53)
how to Kill a background process
(13 Dec 2006 14:17:10)
SQL Server 2005 - view members of windows group
(13 Dec 2006 13:39:9)
Configuring SQL 2005!!!!
(13 Dec 2006 5:45:44)
is it s stored pocedure? or may be a an ad hoc query, or both?
(12 Dec 2006 22:15:41)
Copying DTS packages and SQL Agent Jobs from SQL 7 to 2000
(12 Dec 2006 18:20:44)
HELP Needed: Scheduling an SSIS Package
(12 Dec 2006 18:8:19)
new extended stored proc not working in production environment
(12 Dec 2006 17:46:43)
Finding duplicates
(12 Dec 2006 17:15:33)
count(*) returns 1 everytime
(12 Dec 2006 16:55:13)
Re: xp_sendemail error (Open)
(12 Dec 2006 15:36:16)
execute system sps
(12 Dec 2006 15:32:26)
How to Zip file/DB Backup using Sql Query
(12 Dec 2006 15:28:45)
OSQL
(12 Dec 2006 15:6:43)
xp_sendemail error
(12 Dec 2006 15:4:48)
Driver problem with Merge Replication
(12 Dec 2006 14:37:5)
REPLICATION ISSUE - HELP
(12 Dec 2006 14:22:45)
SQL 2005 tutorial.....
(12 Dec 2006 12:49:16)
Supporting .net framework 1 as well as 2 in in IIS
(12 Dec 2006 11:49:17)
Creating Instance and Database in SQL 2005.....
(12 Dec 2006 10:58:33)
Re: Creating Instance and Database in SQL 2005..... (Open)
(12 Dec 2006 10:46:13)
Using xp_cmdshell security question
(11 Dec 2006 23:43:0)
JITdebugger
(11 Dec 2006 16:20:2)
Facets
(11 Dec 2006 15:28:28)
Correct settings for a clean post?
(11 Dec 2006 15:23:31)
Query/SP to know how many sql login can access a particular table.
(11 Dec 2006 14:57:23)
Re: Query/SP to know how many sql login can access a particular table. (Open)
(11 Dec 2006 14:50:58)
Not SQL Server
(11 Dec 2006 12:22:8)
SQL Server 2005 Non-mail
(11 Dec 2006 11:3:52)
Re: Maitenace Mode Vs Emergency Mode (Open)
(11 Dec 2006 10:47:21)
Maitenace Mode Vs Emergency Mode
(11 Dec 2006 9:56:27)
Database last used
(11 Dec 2006 9:44:33)
Linked Servers
(11 Dec 2006 8:59:36)
clustered and Non-clustered index on same column
(10 Dec 2006 22:1:55)
External logging from an automated SQL
(10 Dec 2006 4:44:38)
Com object error
(9 Dec 2006 7:22:1)
Can you use WITH STANDBY in a RESTORE
(9 Dec 2006 7:21:33)
Fragmentation question
(8 Dec 2006 19:30:30)
Stripping text from a string - hopefully without having to string walk!!
(8 Dec 2006 18:28:2)
audit trigger
(8 Dec 2006 17:18:57)
using profiler
(8 Dec 2006 17:15:18)
Re: [BULK] DTS question
(8 Dec 2006 16:46:20)
AutoShrink option
(8 Dec 2006 14:55:5)
Cannot process....
(8 Dec 2006 12:44:51)
Trigger to update field based on criteria
(8 Dec 2006 12:37:16)
Performance Question
(8 Dec 2006 11:33:47)
Server has been renamed, after SQL was installed.
(8 Dec 2006 10:52:37)
Apply Diff Backup to Warm Server
(8 Dec 2006 7:43:7)
Srinking a database
(8 Dec 2006 3:10:18)
Error: 1203, Severity: 20, State: 1
(8 Dec 2006 3:7:40)
migration
(7 Dec 2006 21:57:57)
Script to generate deadlocking info
(7 Dec 2006 17:27:9)
Migrating from SQL 2000 to SQL 2005
(7 Dec 2006 16:53:57)
Cluster fail over
(7 Dec 2006 16:16:15)
Collation
(7 Dec 2006 15:36:1)
Managing SS2k and SS2k5
(7 Dec 2006 15:35:43)
SQL2005 Max Instances
(7 Dec 2006 15:30:0)
Replication
(7 Dec 2006 14:49:12)
HELP Needed: Import from Oracle to SQL 2005
(7 Dec 2006 13:54:34)
ASP.NET or Java Script Help
(7 Dec 2006 13:49:51)
change non-clustered index to clustered index
(7 Dec 2006 13:32:49)
Convert Date and time format
(7 Dec 2006 12:58:24)
SQL 2000 Reporting Services
(7 Dec 2006 12:9:37)
MOM with SQL 2005
(7 Dec 2006 0:24:3)
Database blocking caused by backup
(7 Dec 2006 0:5:8)
Users & Logins
(6 Dec 2006 21:11:6)
Determining service pack level
(6 Dec 2006 21:5:52)
Server Performance
(6 Dec 2006 20:5:55)
Is it possible to.......
(6 Dec 2006 18:34:58)
Source Control/Management Software
(6 Dec 2006 17:21:48)
Please help with my backup syntax.
(6 Dec 2006 16:4:46)
Re: [QUAR] RE: Determining service pack level
(6 Dec 2006 13:29:41)
Error in Trusted SQL Login
(6 Dec 2006 13:29:20)
can't drop corrupted table
(6 Dec 2006 12:34:4)
:O/
(6 Dec 2006 11:50:8)
Cool tool....
(6 Dec 2006 11:13:52)
(2nd Attempt) DTS question - Looping export of CSV files
(6 Dec 2006 11:7:2)
Re: Development Standards
(6 Dec 2006 10:5:0)
How to call the built-in stored procedure of SQL 2000 from c#
(6 Dec 2006 9:50:35)
CLR Debugger
(6 Dec 2006 4:19:34)
Re: mirror vs log shipping
(5 Dec 2006 21:55:21)
Re: log shipping [SEC=UNCLASSIFIED]
(5 Dec 2006 21:40:53)
Log shipping
(5 Dec 2006 21:23:37)
MDF vs LDF
(5 Dec 2006 21:20:34)
Read locking and concurrency in MSSQL 2005
(5 Dec 2006 20:39:24)
SQL and OS Patch Level
(5 Dec 2006 20:29:12)
Post Formatting
(5 Dec 2006 18:2:31)
SQLServer User Permissions on tables
(5 Dec 2006 17:54:49)
How to alter table for identity column?
(5 Dec 2006 17:37:51)
Help Update Statement
(5 Dec 2006 16:51:10)
Question on using the Copy Database Wizard
(5 Dec 2006 15:52:38)
SQL 2000 SP3 : Transactional Replication
(5 Dec 2006 15:9:39)
Create logins for multiple users
(5 Dec 2006 15:8:31)
SQL 2005 training
(5 Dec 2006 14:38:18)
Pass a parameter to procedure executed via OSQL.
(5 Dec 2006 14:0:23)
CPU Resources going high
(5 Dec 2006 12:35:29)
Pass Global Variable of DTS through any frong End Tools
(4 Dec 2006 18:13:39)
Recovery Models when transaction log backups are not desired
(4 Dec 2006 18:4:8)
SQL 2000 Question
(4 Dec 2006 18:4:8)
Initial Full Text Search is Painfully Slow
(4 Dec 2006 16:57:20)
LiteSpeed Developer Ed./Dual-core Xeon processor
(4 Dec 2006 15:40:45)
Upgrade SQL 2005 Stnd Edition to Enterprise Edition
(4 Dec 2006 15:14:36)
Moving Remote/Link Servers from server A to B
(4 Dec 2006 14:50:4)
Why Views Intead of Stored Procedures
(4 Dec 2006 13:50:40)
sequence of where condition
(4 Dec 2006 11:53:55)
Ansi Join between more than 2 tables
(4 Dec 2006 11:32:25)
DB Restore is very slow when using SQL Litespeed
(4 Dec 2006 10:30:30)
Order of expressions in where clause
(4 Dec 2006 10:26:53)
Oracle To MSQLServer
(4 Dec 2006 3:40:43)
restoring sql logins
(2 Dec 2006 5:40:3)
SQL Reporting Question
(1 Dec 2006 21:10:38)
query for maintenace plans?
(1 Dec 2006 21:1:44)
Re: Error Capture
(1 Dec 2006 20:38:19)
Access Denied in DOS Script in SQL Server Job
(1 Dec 2006 20:20:15)
SQL 2005 64-BIT QUESTION
(1 Dec 2006 20:3:41)
strings in SPs
(1 Dec 2006 18:11:19)
extent scan fragmentation still high after reindex
(1 Dec 2006 17:7:21)
Calling a third party executable through a stored procedure
(1 Dec 2006 15:49:29)
query to report sql server agent properties?
(1 Dec 2006 15:49:2)
Does rebuilding an index also defrag it?
(1 Dec 2006 15:14:56)
data file size (space allocatted)
(1 Dec 2006 13:43:30)
DBCC checkdb error?
(1 Dec 2006 12:34:21)
how reduct LDF
(1 Dec 2006 11:39:33)
Re: Read Only File Groups (Open)
(1 Dec 2006 10:10:18)
Re: Bulk inserts (Open)
(1 Dec 2006 8:48:34)
importing data from SQLServer to Oracle ??
(1 Dec 2006 8:6:44)
SQL XML Query Issue.
(1 Dec 2006 4:52:37)
Data Type check in differnt table a database
(1 Dec 2006 1:36:29)
Read Only File Groups
(1 Dec 2006 0:4:34)
sql lazydba home page