MS Sql Server

February 2007

Re: [Spam] I am unable to bcp using fixed format file
(28 Feb 2007 23:20:16)
Permission a User or Role to all stored procs in a database
(28 Feb 2007 22:17:41)
Table variable as output parameter?
(28 Feb 2007 21:1:32)
xml import urgent help
(28 Feb 2007 20:28:29)
data type enhancement for 2005?
(28 Feb 2007 20:0:45)
Change compatibility mode to 90 after upgrading to sql 2005?
(28 Feb 2007 19:39:24)
DST changes for SQL SERVER 7
(28 Feb 2007 19:28:46)
SQL Server without using EM?
(28 Feb 2007 18:58:39)
Error message in DTS job
(28 Feb 2007 18:51:24)
" quotes to appear in t-sql
(28 Feb 2007 16:4:20)
Re: [***SPAM*** Score/Req: 4.5/3.5] " quotes to appear in t-sql
(28 Feb 2007 15:31:33)
maint plan 2005 ToolBox
(28 Feb 2007 15:30:32)
Why doesn't dbreindex or indexdefrag change results in showcontig?
(28 Feb 2007 15:12:18)
How to copy file using stored procedure?
(28 Feb 2007 14:22:21)
Access Date query
(28 Feb 2007 13:35:7)
SQL Server Stop
(28 Feb 2007 4:33:24)
SQL 2005 - Online Indexing Error with XML Data Type
(28 Feb 2007 0:43:57)
I am unable to bcp using fixed format file
(27 Feb 2007 19:6:10)
Inner joining different servers
(27 Feb 2007 18:59:16)
BULK INSERT removing header?
(27 Feb 2007 18:35:16)
Log shipping
(27 Feb 2007 17:25:0)
Now the export...
(27 Feb 2007 17:18:32)
Trace Events in Event Log
(27 Feb 2007 16:48:18)
Clusters or Mirrors?
(27 Feb 2007 16:48:11)
MSDCT
(27 Feb 2007 16:32:18)
migrating clob data to sql server
(27 Feb 2007 15:16:2)
Import data from a tab delimited using SQL?
(27 Feb 2007 15:3:57)
Sql & Exchange
(27 Feb 2007 14:55:29)
SP2 for SQL2005
(27 Feb 2007 12:20:4)
DTS Error
(27 Feb 2007 12:16:16)
SQLAgent Running
(27 Feb 2007 9:46:20)
Linked server Open query error
(27 Feb 2007 9:37:10)
Error viewing Stored Procedures under SQL 2005 Management Studio
(27 Feb 2007 2:34:31)
Need help setting up mail on SQL2005
(26 Feb 2007 21:32:17)
Progess and DST
(26 Feb 2007 21:16:9)
Supressing DBCC output?
(26 Feb 2007 20:8:3)
Replication syncobj Ownership
(26 Feb 2007 17:49:16)
Backup Transaction with NO_LOG
(26 Feb 2007 17:25:19)
Moving a 2000 cluster
(26 Feb 2007 15:52:11)
need column headings returned by DTS
(26 Feb 2007 15:51:11)
New Server - Best Practice to Copy Databases
(26 Feb 2007 15:47:51)
How to kick current logged in users off SQL 2000
(26 Feb 2007 15:12:35)
SQL 2000 SP3a
(26 Feb 2007 12:36:19)
how to insert a text value with apostrophes in access db
(26 Feb 2007 11:56:45)
Maintenance Plan Non-information fixed yet?
(26 Feb 2007 9:9:21)
MS Access DB script generation
(26 Feb 2007 5:57:17)
Access DB script generation.
(26 Feb 2007 5:46:50)
LISTOWNER- EMAIL SHIELDING
(24 Feb 2007 14:0:1)
sql 2000 to 2005 performance data
(24 Feb 2007 0:45:27)
Dynamics
(23 Feb 2007 20:51:23)
Migration to SQL Server 2005
(23 Feb 2007 16:45:18)
2005 Maintenance Plan
(23 Feb 2007 16:26:16)
Must Have: SQL 2005 Cluster SSIS config article
(23 Feb 2007 15:57:50)
Creting read only view with schemabinding
(23 Feb 2007 14:42:0)
Query to retreive all logins with sa for SQL2K
(23 Feb 2007 13:57:6)
Script Logins With SIDS and Passwords
(23 Feb 2007 13:41:34)
Character size issue
(23 Feb 2007 13:32:24)
Cannot open database "db1" requested by the login
(23 Feb 2007 13:10:46)
Select DISTINCT based on date
(23 Feb 2007 9:27:19)
Search all field in all tables
(23 Feb 2007 9:24:45)
sync process
(22 Feb 2007 23:37:0)
Re: Maths and SQL Server - A little more INFO
(22 Feb 2007 22:52:59)
Re: [SPAM(7.3)] DYNAMIC QUERY/SEARCH
(22 Feb 2007 22:38:23)
Can you read a log file?
(22 Feb 2007 22:27:9)
Strange 2005 Error message in Profiler
(22 Feb 2007 21:15:0)
How many files should TEMPDB has?
(22 Feb 2007 19:41:41)
Creating a backup job in SQL 2005
(22 Feb 2007 19:19:15)
where do I change defaults?
(22 Feb 2007 18:23:52)
Re: [BULK] Strange 2005 Error message in Profiler
(22 Feb 2007 16:42:35)
Dynamic SQL
(22 Feb 2007 15:17:40)
Need help on SAN
(22 Feb 2007 15:15:15)
Full Recovery Model
(22 Feb 2007 14:49:34)
Adding Business Days to a Date
(22 Feb 2007 14:39:25)
Index Error
(22 Feb 2007 12:35:3)
Qweries which display key indicators mesures
(22 Feb 2007 9:45:31)
Why can't I dynamically create a view?
(22 Feb 2007 4:16:47)
Starting up database 'dbname' message
(21 Feb 2007 23:27:33)
Re: SQL Server 2005 SP2 appears out - Read 3.2.6 of README
(21 Feb 2007 22:30:39)
Re: Null fields (SOLVED)
(21 Feb 2007 20:12:52)
Null fields
(21 Feb 2007 19:26:17)
Sql server log access
(21 Feb 2007 19:7:47)
Finding records in a table with blank fields
(21 Feb 2007 18:2:7)
How to Grant only create sp no table drop or edit or create
(21 Feb 2007 16:14:3)
Create a SQL table from Excel
(21 Feb 2007 15:49:19)
Tool or syntax for CR/LF
(21 Feb 2007 15:28:20)
Internal Query Processor Error
(21 Feb 2007 15:17:38)
NOT SQL --- Dynamics
(21 Feb 2007 14:24:40)
2000 vs 2005 performance gains
(21 Feb 2007 13:27:12)
Table relationships, forcing a rule.
(21 Feb 2007 13:2:37)
Maths and SQL Server
(21 Feb 2007 12:55:56)
how to find out the db name dynamically??? CAROL GREEN PLZ HELP!!!!
(21 Feb 2007 10:4:44)
Print file from stored procedure.
(21 Feb 2007 9:20:42)
List of disable/enable trigger
(21 Feb 2007 8:23:5)
DYNAMIC QUERY/SEARCH
(21 Feb 2007 5:7:19)
SQL Server 2005 SP2 appears out
(20 Feb 2007 23:15:54)
Error Retrieval
(20 Feb 2007 19:29:12)
Off Site Back Ups?
(20 Feb 2007 19:18:22)
Transaction Log Starting Size
(20 Feb 2007 18:18:26)
Identities across developement invironments
(20 Feb 2007 17:46:49)
Stored Procedure Search
(20 Feb 2007 17:5:34)
delivering replicated transactions
(20 Feb 2007 16:55:25)
Bulk-Logged Problems
(20 Feb 2007 16:19:58)
Re: outer join
(20 Feb 2007 15:59:44)
Linked servers SQL 2005
(20 Feb 2007 14:43:43)
Privs
(20 Feb 2007 14:20:42)
NULL isnull for ntext datatype
(20 Feb 2007 12:48:19)
2005 security questions
(20 Feb 2007 11:31:45)
Failover
(20 Feb 2007 10:36:3)
Linked server query
(20 Feb 2007 9:16:41)
Login problem
(19 Feb 2007 16:34:2)
Trying to monitor locks on a table
(19 Feb 2007 15:42:36)
Re: sp creation failed
(19 Feb 2007 14:59:4)
Thanks - Re: Moving DTS Packages
(19 Feb 2007 13:51:22)
Create sp permission but not alter Table or Drop table
(19 Feb 2007 13:39:5)
Merge 2 fields into 1
(19 Feb 2007 12:19:46)
DTS from remote SQL 2000 servers through faulty lines (comms)
(19 Feb 2007 10:16:37)
sp creationed failed
(18 Feb 2007 10:19:9)
Cannot resolve collation conflict for equal to operation.
(17 Feb 2007 5:14:8)
Spaces when merging 2 fields
(16 Feb 2007 23:7:34)
Dates
(16 Feb 2007 21:20:3)
DBA BOOK for both Beginner to professional
(16 Feb 2007 21:20:2)
Saving a User's SQL Server Objects
(16 Feb 2007 21:20:0)
Dropping a sql server 7 user
(16 Feb 2007 20:57:26)
Convert GUIDS to DTS
(16 Feb 2007 20:7:18)
Database and Performance Monitoring
(16 Feb 2007 19:58:49)
adding a dts package into a job
(16 Feb 2007 16:56:32)
Re: [***SPAM*** Score/Req: 4.5/3.5] RE: DBA BOOK for both Beginner to professional
(16 Feb 2007 15:25:8)
Management Studio frozen
(16 Feb 2007 15:4:26)
SQL Server Port Change
(16 Feb 2007 14:49:28)
Trying to avoid creating 1000 views
(16 Feb 2007 14:33:2)
SP Error
(16 Feb 2007 8:31:40)
getting error during drop column
(16 Feb 2007 4:41:9)
Creating table from "Select ... ForXML" generated XML schema
(16 Feb 2007 2:49:54)
Moving DTS Packages
(15 Feb 2007 19:40:50)
SQLtrace
(15 Feb 2007 18:18:31)
Transfering Application Roles
(15 Feb 2007 17:56:10)
Monitoring Queue ??
(15 Feb 2007 17:42:18)
SQL 2005 Problem
(15 Feb 2007 17:33:4)
Migrating logins from one sql server to another
(15 Feb 2007 17:12:16)
SQL Server 2000 Service pack 4
(15 Feb 2007 16:25:13)
Spilt String
(15 Feb 2007 15:56:26)
backup and restore
(15 Feb 2007 15:11:16)
how can check only for one ' ???? carol green plz help!!!
(15 Feb 2007 14:20:5)
Restoring db from mdf and ldf files
(15 Feb 2007 13:49:7)
Assigning a created user a login
(15 Feb 2007 11:15:39)
problem when going to shrink the log file
(15 Feb 2007 9:16:3)
SQL(ms sql 2000) does not start when server rebooted
(14 Feb 2007 22:41:8)
SQL 2005 SP1 version
(14 Feb 2007 22:15:42)
SQL 2005 -- best set up practice
(14 Feb 2007 21:14:3)
just thought you might want to know
(14 Feb 2007 21:6:40)
Final try, saving off user
(14 Feb 2007 20:34:49)
Finding Text
(14 Feb 2007 18:10:39)
Finding String Value
(14 Feb 2007 15:7:52)
Extremely Large Transaction Log File - SQL 2005
(14 Feb 2007 14:47:37)
MSSQL Service indicates stopping
(14 Feb 2007 13:58:11)
xp_sendmail error
(14 Feb 2007 12:46:45)
How can I Rename Named Instance
(14 Feb 2007 12:3:55)
Re: trigger mysteries
(14 Feb 2007 8:5:40)
Pad Index
(14 Feb 2007 7:15:22)
SQL Server 2000/5
(13 Feb 2007 22:58:55)
Better SQL Server Backup and Monitoring Product
(13 Feb 2007 20:41:40)
SQLServer 2000 job scheduling
(13 Feb 2007 20:39:44)
federated servers
(13 Feb 2007 17:37:25)
Managing Jobs
(13 Feb 2007 17:36:40)
Mssql 2005 failover.
(13 Feb 2007 17:29:6)
Location logs of databases in MS sqlsevr
(13 Feb 2007 16:48:24)
Documentation
(13 Feb 2007 16:23:55)
Space used, left in each filegroup
(13 Feb 2007 15:2:31)
Er Studio , adding a comment to a table
(13 Feb 2007 14:46:51)
Deadlock Management Script
(13 Feb 2007 14:35:44)
Droping objects, and/or saving objects before deleting login
(13 Feb 2007 13:14:28)
urgent pls
(13 Feb 2007 11:41:25)
SQL Server 2000
(13 Feb 2007 7:9:26)
blocking problems
(13 Feb 2007 6:38:21)
Find login users objects
(13 Feb 2007 2:26:43)
Export DTS from 2000 to 2005 Where can I edit?
(12 Feb 2007 23:32:3)
/PAE and AWE again
(12 Feb 2007 23:11:13)
Recursive Hierarchy
(12 Feb 2007 23:4:21)
Database Audit Control
(12 Feb 2007 21:9:52)
DDL, DML and DSL?
(12 Feb 2007 20:58:10)
Guideline document for Security in SQL Server 2005
(12 Feb 2007 19:1:17)
Roles script
(12 Feb 2007 17:55:46)
User Not Authenticated
(12 Feb 2007 17:53:25)
How to determine which INDEX needed
(12 Feb 2007 16:37:35)
Order By Functions
(12 Feb 2007 14:32:6)
How to Backup SQL2000 database to another PC?
(11 Feb 2007 19:58:43)
SQLSERVERAGENT service error
(11 Feb 2007 14:34:27)
What is the longest length a varchar variable can hold
(11 Feb 2007 8:51:52)
restore msdb db
(9 Feb 2007 22:12:46)
How to capture the name
(9 Feb 2007 21:31:49)
Which SSIS tasks is for .bat/.cmd files?
(9 Feb 2007 21:30:55)
Question
(9 Feb 2007 19:56:48)
TSQL Code to get Job(s) history Pass 5 days
(9 Feb 2007 18:20:35)
What do you recommend
(9 Feb 2007 17:43:27)
Error converting data type nvarchar to numeric
(9 Feb 2007 17:9:57)
db growth calculation
(9 Feb 2007 17:4:42)
Need facts to persuade database change
(9 Feb 2007 16:53:20)
drop login that owns objects
(9 Feb 2007 15:16:48)
connectivity problem
(9 Feb 2007 14:3:32)
Dynamic SQL Wierd Error....
(9 Feb 2007 14:0:7)
SQL Error when attaching a database with deleted log file
(9 Feb 2007 11:31:48)
formatting and comments
(9 Feb 2007 8:28:5)
Looking for a SQL Server Option Setting
(8 Feb 2007 22:4:53)
Cannot sp_changeDBowner on 'model' database
(8 Feb 2007 21:31:46)
SSIS configuration on Cluster
(8 Feb 2007 18:42:19)
Getting last months data
(8 Feb 2007 16:37:53)
Linked Server Issue
(8 Feb 2007 15:46:1)
How to return a value in a stored procedure
(8 Feb 2007 8:55:34)
Potentially useful tool: sp_search (Take 2)
(8 Feb 2007 5:34:43)
info
(8 Feb 2007 5:18:30)
using count on text datatype
(8 Feb 2007 4:54:13)
Re how to return a value from a stored proceture
(8 Feb 2007 4:45:30)
SQLServer Performance slow
(8 Feb 2007 4:13:31)
Server slow performance
(8 Feb 2007 1:37:59)
XML DML - READY FOR A PADDED CELL HERE
(7 Feb 2007 23:49:30)
To increase database free space right away?
(7 Feb 2007 22:26:25)
Re: Possible Spam2: Script to move logins
(7 Feb 2007 22:9:17)
Script to move logins
(7 Feb 2007 22:1:31)
Potentially useful tool: sp_search
(7 Feb 2007 20:56:27)
Problem with view using Linked server - Please help
(7 Feb 2007 20:30:45)
my messages text format
(7 Feb 2007 19:20:23)
Query
(7 Feb 2007 16:38:17)
Tracing a stored procedure
(7 Feb 2007 16:31:27)
Impact(s) to change the recovery model from simple to full
(7 Feb 2007 16:30:19)
Shrink Database Affecting Fragmentation
(7 Feb 2007 16:2:59)
Version/service pack
(7 Feb 2007 15:51:22)
Read80Trace
(7 Feb 2007 14:36:25)
SQL - Servier slow performance
(7 Feb 2007 10:21:45)
sql server 2000 64 bit degrade after inof sp4
(7 Feb 2007 7:27:56)
Actual Cost of the Query
(7 Feb 2007 6:29:58)
Question on index rebuild
(6 Feb 2007 22:36:1)
SQL 2000 Profiler
(6 Feb 2007 21:10:8)
sp_executesql and sp_sendSMTPMail
(6 Feb 2007 20:46:27)
Seeking Employment in Illinois???
(6 Feb 2007 20:45:53)
How to execute two inserts one after the other
(6 Feb 2007 20:20:33)
Global trigger
(6 Feb 2007 20:18:37)
sql 2005
(6 Feb 2007 20:12:3)
Wanted: Sample batch file backup command
(6 Feb 2007 19:50:37)
Operations Manager Warning Alert
(6 Feb 2007 17:7:19)
DTS and logging
(6 Feb 2007 16:48:19)
Error: 15457, Severity: 0, State: 1 in ERROR log
(6 Feb 2007 15:55:27)
/PAE and AWE for SQL Server
(6 Feb 2007 15:27:11)
QSoft RAMDisk
(6 Feb 2007 15:24:1)
Replicating Sql Server 2005
(6 Feb 2007 15:21:23)
Trace Files
(6 Feb 2007 13:27:20)
Table scan
(6 Feb 2007 8:47:29)
Baffled - Access to MSSQL
(5 Feb 2007 22:10:24)
lazy server
(5 Feb 2007 22:6:46)
Re: Permissions Question, Samples wanted
(5 Feb 2007 21:41:18)
SQL 2005 services won't start
(5 Feb 2007 21:39:46)
Permissions Question
(5 Feb 2007 21:15:38)
recommended reading
(5 Feb 2007 20:35:48)
Windows Authentication
(5 Feb 2007 20:28:44)
CREATING FULLTEXT CATALOG [catSearch]
(5 Feb 2007 18:9:27)
Perfromace Issue after applying SP4 in SQL Server 2000
(5 Feb 2007 15:58:58)
Login failed for user
(5 Feb 2007 15:15:35)
Alias database in SQL 2005
(5 Feb 2007 14:57:13)
Table size
(5 Feb 2007 12:42:0)
constant Scan
(5 Feb 2007 11:51:27)
DTS job Failed
(5 Feb 2007 11:30:47)
books related to Sql server 2000/2005
(5 Feb 2007 5:21:30)
System account and replication
(4 Feb 2007 21:53:40)
Delete of table size about 12 GB
(3 Feb 2007 7:51:31)
Constructing Dynamic Hierarchy using MS Reporting Services 2005
(3 Feb 2007 0:21:57)
Common Table Expressions in SQL Server
(2 Feb 2007 20:38:59)
In-Memory Database
(2 Feb 2007 20:16:38)
SQL and XML
(2 Feb 2007 20:7:59)
Export Dump in SQL Server 2005
(2 Feb 2007 19:48:0)
Bulk inserts
(2 Feb 2007 19:42:10)
Replcation between SQL & MySQL
(2 Feb 2007 19:38:57)
Global Variable
(2 Feb 2007 19:30:15)
SQL Server Exception
(2 Feb 2007 19:15:52)
Xquery, updating & looping through results
(2 Feb 2007 16:4:10)
SQL 2005 delivered user ID
(2 Feb 2007 15:57:57)
Collation and instances.
(2 Feb 2007 15:44:48)
Script
(2 Feb 2007 14:22:20)
Database hits
(2 Feb 2007 12:57:54)
Text File
(2 Feb 2007 10:53:0)
Index Size is Greator Than Data Size
(2 Feb 2007 6:30:12)
LOG oversize notification
(2 Feb 2007 4:17:38)
EMC SAN Configuration
(2 Feb 2007 2:27:8)
SQL Server 2005
(2 Feb 2007 1:35:34)
Comparing result sets.
(1 Feb 2007 21:47:54)
ODBC driver for 2005
(1 Feb 2007 20:20:53)
how to detach and attach system DBs?
(1 Feb 2007 20:18:22)
Subfolders in SSMS Object Explorer?
(1 Feb 2007 19:55:44)
changing tempdb collation
(1 Feb 2007 19:32:7)
xp_sendmail help
(1 Feb 2007 19:13:19)
Recall: xp_sendmail help
(1 Feb 2007 18:34:9)
Replication
(1 Feb 2007 18:8:59)
Command to script all DBs and table row count
(1 Feb 2007 17:27:38)
auto-grow
(1 Feb 2007 17:8:53)
ms sql tape back up
(1 Feb 2007 17:4:35)
Transaction Log
(1 Feb 2007 16:23:0)
Free, used Space of a database during a period of time
(1 Feb 2007 15:26:32)
Trunacte a partition in MS SQL 2005
(1 Feb 2007 15:24:8)
SQL Trace at start-up SQL 2005
(1 Feb 2007 14:45:51)
Backup
(1 Feb 2007 12:13:39)
DBCC TRACEON
(1 Feb 2007 11:33:20)
change system date through a vb codeý
(1 Feb 2007 10:37:30)
SQL Error when attaching a suspect database
(1 Feb 2007 7:35:4)
sql lazydba home page