MS Sql Server

June 2005

Shrinking a Database, Part II
(30 Jun 2005 23:55:42)
Index question...
(30 Jun 2005 18:23:44)
DTS Export Dynamic Filename
(30 Jun 2005 14:50:17)
Query a table in any database
(30 Jun 2005 14:48:36)
Changing a connection on DTS
(30 Jun 2005 12:38:20)
DTS
(30 Jun 2005 11:35:33)
Recovery?
(30 Jun 2005 11:34:31)
SQL Login Info...
(30 Jun 2005 11:32:10)
Connecting from oracle to sqlserver
(30 Jun 2005 11:13:6)
Help Please
(29 Jun 2005 20:39:27)
USE @variable
(29 Jun 2005 19:45:31)
Remote Servers
(29 Jun 2005 18:32:51)
Transpose Problem
(29 Jun 2005 13:8:48)
Performance issue - am I correct
(29 Jun 2005 12:46:2)
1=1 ?
(29 Jun 2005 10:36:17)
Shrinking a Database
(29 Jun 2005 5:39:21)
What size should the msdb database hover around?
(29 Jun 2005 2:15:2)
Selecting range of rows
(28 Jun 2005 22:24:49)
DTS Transform Data Task
(28 Jun 2005 18:29:46)
ntext get content
(28 Jun 2005 17:41:6)
Defeat Single Quotation in a string
(28 Jun 2005 17:6:24)
Anyone seen this error on SQL Server Client Tools Install?
(28 Jun 2005 16:59:27)
memory issue
(28 Jun 2005 15:37:23)
Scripting Database Users
(28 Jun 2005 15:9:17)
Quick Question
(28 Jun 2005 13:54:21)
clustering combined with replication
(28 Jun 2005 12:47:36)
Script help?
(27 Jun 2005 18:38:17)
How to concatenate in select query
(27 Jun 2005 13:12:19)
Copy from Excel
(27 Jun 2005 12:57:19)
Re: [RMX:#] How to concatenate in select query
(27 Jun 2005 12:2:20)
COALESCE() VS. ISNULL()
(27 Jun 2005 11:58:24)
Distinct
(27 Jun 2005 9:53:2)
LISTOWNER- EMAIL SHIELDING
(25 Jun 2005 13:0:2)
Persistent Connectivity Problems
(24 Jun 2005 18:8:1)
GUID as PK
(24 Jun 2005 17:48:58)
Linked Server
(24 Jun 2005 16:16:37)
DBA Role
(24 Jun 2005 14:51:31)
Urgent
(24 Jun 2005 13:54:23)
Changing the SQL Server Port Number
(24 Jun 2005 12:56:20)
SQL Server Listener????
(24 Jun 2005 12:28:18)
Re: TRY IT OUT.......... [Spammer taken out of list]
(24 Jun 2005 8:45:58)
TRY IT OUT..........
(24 Jun 2005 8:16:45)
@@SERVERNAME
(24 Jun 2005 1:23:2)
comments & suggestions appreciated
(24 Jun 2005 1:5:25)
Re: Transaction Processing - Correction
(23 Jun 2005 18:19:8)
two-task
(23 Jun 2005 16:33:41)
a little assistance please
(23 Jun 2005 14:43:19)
Transaction Processing
(23 Jun 2005 14:36:22)
image question.
(23 Jun 2005 13:46:37)
licensing question
(23 Jun 2005 13:11:15)
Hardening
(23 Jun 2005 12:16:10)
image problem
(23 Jun 2005 12:10:17)
MDX Queries
(23 Jun 2005 7:15:32)
XP_CMDSHELL
(22 Jun 2005 20:20:57)
View Permissions Question
(22 Jun 2005 20:20:14)
Incremental replication or full copy
(22 Jun 2005 18:55:28)
Extracting data from a .csv file
(22 Jun 2005 17:39:21)
DTS question
(22 Jun 2005 17:27:39)
best practices
(22 Jun 2005 16:37:45)
Assistance
(22 Jun 2005 14:50:3)
No space left on database
(22 Jun 2005 14:41:28)
Re: Questions on Alerts
(22 Jun 2005 13:45:0)
Encryption
(22 Jun 2005 7:55:35)
Problem with KILLED/ROLLBACK cmd in sp_who2 stored procedure resu ltset (KILLED/ROLLBACK process stuck)
(22 Jun 2005 0:55:38)
Diagrams
(21 Jun 2005 20:21:58)
For alerts...Is is true?
(21 Jun 2005 18:28:2)
ActiveX Script to get Computer Name
(21 Jun 2005 14:38:58)
Number of Rows
(21 Jun 2005 14:0:18)
Re: DTS Question + Another Question
(21 Jun 2005 13:53:55)
Urgent Advice
(21 Jun 2005 13:45:7)
Upgrading or migrating SQL2000 to SQL2005
(21 Jun 2005 9:47:8)
SQL/XML query
(21 Jun 2005 9:46:39)
Whats wrong in this syntax
(21 Jun 2005 7:29:33)
SQL Server Scheduled Job - Restore Database
(20 Jun 2005 19:11:16)
HotFix Information
(20 Jun 2005 18:59:22)
Scheduled Job
(20 Jun 2005 18:18:57)
Microsoft WEBCAST on Upgrading SQL Server
(20 Jun 2005 17:37:19)
odbc connection
(20 Jun 2005 14:31:10)
Connectivity
(20 Jun 2005 11:45:16)
Formatting osql output
(20 Jun 2005 11:10:10)
Question for Monday
(17 Jun 2005 22:59:25)
Cannot Drop The Database
(17 Jun 2005 21:22:22)
Triggers on System Tables
(17 Jun 2005 19:37:10)
SQL hacking and shutdown no connection
(17 Jun 2005 19:34:37)
Re: SQL hacking and shutdown no connection sorry it a little chan ge
(17 Jun 2005 19:4:58)
Microsoft MVP
(17 Jun 2005 18:52:49)
SELECT OUTPUT
(17 Jun 2005 18:12:48)
Cannot connect to server very urgent
(17 Jun 2005 17:34:49)
Quick Replication Question - Adding a table/object to an existing regime?
(17 Jun 2005 16:33:50)
Regarding Error "Specified SQL Server Not Found"
(17 Jun 2005 12:53:33)
SQL Server SP4
(17 Jun 2005 12:41:6)
Antivirus anyone
(17 Jun 2005 12:2:50)
sql output formatting
(17 Jun 2005 7:6:31)
IMPORTANT
(17 Jun 2005 4:55:39)
Migrating to SQL2005
(17 Jun 2005 0:1:25)
restoring
(16 Jun 2005 20:8:20)
Moving a role from one server to another
(16 Jun 2005 18:38:42)
Log shipping
(16 Jun 2005 17:57:3)
freeware
(16 Jun 2005 17:45:59)
Determine missing records from two tables
(16 Jun 2005 15:18:56)
Advice on Index
(16 Jun 2005 14:20:9)
How to pass parameters to DTS using procedure
(16 Jun 2005 13:48:39)
Tables with 255 columns
(16 Jun 2005 13:23:7)
Service Pack 4
(16 Jun 2005 12:40:3)
Re: [RMX:#] Service Pack 4
(16 Jun 2005 11:9:59)
Which Ports?
(16 Jun 2005 11:5:11)
Date and Time Tables Last Modified
(16 Jun 2005 9:37:35)
Disaster Recovery Plan
(16 Jun 2005 6:51:11)
slowness on the server
(15 Jun 2005 23:53:21)
Script to generate the create database, create table scripts ...
(15 Jun 2005 18:52:44)
Unable to connect to SQL server from Visual studio
(15 Jun 2005 15:24:0)
Encrypting SQL Server data
(15 Jun 2005 15:11:35)
Microsoft Search Service
(15 Jun 2005 14:49:20)
Follw up to Insert Quicker from last week.
(15 Jun 2005 12:49:32)
Who's using my CPU
(15 Jun 2005 11:29:45)
anyone ever used RAID50 ?
(15 Jun 2005 8:0:22)
IIS - Virtual Directory or Site
(15 Jun 2005 4:17:8)
extended properties
(14 Jun 2005 23:56:32)
License Key info
(14 Jun 2005 21:35:53)
THANKS FOR THE REPLIES --- RE: Follw up to Insert Quicker from last week.
(14 Jun 2005 15:33:25)
How to get the active processes
(14 Jun 2005 11:17:26)
Msg 15289 Cannot have an open transaction when this is run.
(14 Jun 2005 9:39:41)
Database Username and Password
(14 Jun 2005 4:18:3)
BCPing accross network segments.
(14 Jun 2005 0:23:26)
DTS Package
(13 Jun 2005 19:44:5)
Poor insert performance
(13 Jun 2005 17:54:52)
VMWare ...
(13 Jun 2005 16:16:21)
'Restoring' a new database
(13 Jun 2005 14:43:53)
Scripts for userloginsLogins - Experts Help me
(13 Jun 2005 13:57:6)
WITH ENCRYPTION Questions
(13 Jun 2005 11:28:36)
Extraction of usernames of local db from a common schema
(13 Jun 2005 10:54:31)
Stored Procedure in SELECT
(13 Jun 2005 9:39:16)
Snapshot database
(13 Jun 2005 7:47:6)
Could not allocate space for object
(10 Jun 2005 17:24:13)
Backup Strategies...
(10 Jun 2005 17:17:6)
I cannot find the magic "Insert Quicker" option
(10 Jun 2005 17:12:14)
SQL2005 Management Studio Query Editor
(10 Jun 2005 14:13:23)
produce a script for sql server to overwrite backups
(10 Jun 2005 12:34:0)
Re: Spam:Re: Any Easy Way for removing rowguid column from table
(10 Jun 2005 4:37:23)
SQL.LOG file
(9 Jun 2005 22:38:27)
Migration from developer 2000 to Forms & Reports 6i
(9 Jun 2005 13:40:56)
TempDB, MSDB & Master, Model MDF Files
(9 Jun 2005 11:4:48)
Truncate DATE
(9 Jun 2005 10:46:24)
Any Easy Way for removing rowguid column from table
(9 Jun 2005 9:1:13)
Training CDs
(9 Jun 2005 6:10:18)
FYI
(9 Jun 2005 1:28:10)
datepart vs DateValue, off by 2 days?
(8 Jun 2005 21:2:9)
Grant select on at the column level
(8 Jun 2005 18:18:50)
Why is my date extraction code off by 2 days?
(8 Jun 2005 17:49:55)
Password Lifetime and expiration in Oracle 9i database
(8 Jun 2005 17:6:26)
Registering Server
(8 Jun 2005 15:19:44)
View Contents of Transaction Log
(8 Jun 2005 12:9:11)
Creating A Linked AS400 (iseries) server in MSSQL 2000 Ent
(8 Jun 2005 11:54:15)
Temporary table output
(8 Jun 2005 11:35:55)
Re: [RMX:#] @@SERVERNAME
(8 Jun 2005 10:8:12)
Restore with missing/deleted transaction log
(8 Jun 2005 6:16:37)
Wrong path of MDF and LDF on sysfiles
(8 Jun 2005 5:29:0)
Service Pack 3/3a
(8 Jun 2005 5:18:43)
Trigger Failing & Errorlevel
(7 Jun 2005 20:42:47)
Excel and stored proc
(7 Jun 2005 19:43:10)
full text indexes
(7 Jun 2005 18:43:49)
Re: SQL Collation
(7 Jun 2005 16:7:4)
ActiveX Scripting Global variable issue
(7 Jun 2005 14:48:10)
Restore databases into new instance
(7 Jun 2005 14:39:18)
Migration of DB between server
(7 Jun 2005 13:41:51)
incrementing year variable in SQL DTS
(7 Jun 2005 12:50:51)
Re: [RMX:#] Re: Service Pack 3/3a
(7 Jun 2005 12:43:54)
USING DTS to transfer LOGINS
(7 Jun 2005 10:42:27)
Query
(7 Jun 2005 9:10:29)
How to add more fields for tables within the given database
(7 Jun 2005 7:13:55)
Is this a bug ...
(7 Jun 2005 7:9:36)
ms sql error 9002
(7 Jun 2005 6:40:35)
Table Corrupt
(7 Jun 2005 5:29:56)
I WANT TO CONCATENATE ALL THE FIELDS INTO ONE COLUMN?
(6 Jun 2005 10:8:48)
Re: [RMX:###] Re: HOW TO PRINT ROWNUM LIKE IN ORACLE
(6 Jun 2005 6:36:27)
HOW TO USE ALIAS WHEN USED IN SUBQUERY
(6 Jun 2005 6:31:11)
HOW TO PRINT ROWNUM LIKE IN ORACLE
(6 Jun 2005 6:20:19)
uncompressing LZ77 DATA
(3 Jun 2005 17:0:15)
Does Anyone Know?
(3 Jun 2005 15:11:40)
Case statement in Order by clause..
(3 Jun 2005 11:20:30)
hardware upgrade
(3 Jun 2005 9:11:55)
xp_MSADEnabled
(3 Jun 2005 8:58:14)
Import Wizard Error Message
(2 Jun 2005 21:40:59)
concatenating all values of F2 for each value of F1
(2 Jun 2005 20:6:8)
NT Login lag
(2 Jun 2005 18:14:1)
I'm dating myself...
(2 Jun 2005 16:39:56)
creating a linked IBM AS400 server in MS SQL
(2 Jun 2005 14:38:10)
unusual request
(2 Jun 2005 14:27:58)
Back up of Primary file group only throws error messages
(2 Jun 2005 13:54:43)
SQL User Management
(2 Jun 2005 12:18:24)
Database Recovery from MDF files (2)
(2 Jun 2005 9:39:25)
Moving a table to a separate file group / mdf data file
(2 Jun 2005 0:36:23)
BII Utility - Errors Loading Images
(1 Jun 2005 20:20:14)
Undoing "restore database with recovery"
(1 Jun 2005 17:48:16)
Check for SQL Server Authentication Mode
(1 Jun 2005 14:5:27)
Shrinking Log Files
(1 Jun 2005 14:4:52)
Primary Keys of a Table
(1 Jun 2005 13:34:31)
Linked Server Trigger Question
(1 Jun 2005 13:26:18)
compressed data - help!!!!
(1 Jun 2005 13:24:22)
Re: SQL Server Process Is Eating Memory - Memory Leak?
(1 Jun 2005 10:12:42)
Help on Size of MDF File
(1 Jun 2005 4:43:38)
user logins & permission
(1 Jun 2005 1:22:28)
sql lazydba home page