MS Sql Server

May 2007

automate restore process for developer environment
(31 May 2007 23:48:5)
Run SP for 1 user
(31 May 2007 23:39:5)
backup set default file name when using maintinence plan
(31 May 2007 22:52:14)
E-commerce
(31 May 2007 19:39:10)
Windows is searching for devenv.exe
(31 May 2007 19:22:49)
backup set info query
(31 May 2007 18:2:2)
Microsoft Surface --Cool!!!
(31 May 2007 15:3:42)
MOM Reporting Database Housekeep.
(31 May 2007 15:1:34)
User list with sqladmin and db_owner roles
(31 May 2007 14:21:49)
DTS
(31 May 2007 14:12:42)
Deadlock Detection
(31 May 2007 13:16:39)
Proxy Account
(31 May 2007 13:3:49)
GlobalParameters
(31 May 2007 4:33:5)
NT AUTHORITY\NETWORK SERVICE
(30 May 2007 21:22:32)
Source Control that can Compare and Deploy
(30 May 2007 20:33:32)
restoring encrypted passwords
(30 May 2007 18:36:4)
DTS success/failure flow
(30 May 2007 17:20:6)
SQL ERROR
(30 May 2007 15:37:46)
SQL Server 2000
(30 May 2007 15:29:47)
How to print data base tables
(30 May 2007 14:45:10)
Limit to no. of foreign keys in 2k?
(30 May 2007 14:38:54)
DTS logging
(30 May 2007 13:46:46)
Can I write insert statement in functions?
(30 May 2007 13:13:29)
Log shipping
(30 May 2007 12:48:56)
DTS 'Execute SQL Task' control flow
(30 May 2007 12:45:1)
Getting rid of dbo when swapping Access db for SQL db
(30 May 2007 12:8:58)
SQl Express 2005 Concurrent connections
(30 May 2007 8:6:14)
ON DELETE CASCADE
(30 May 2007 8:0:37)
using trace and profile
(29 May 2007 22:24:18)
Osql output - trim characters.
(29 May 2007 21:52:36)
Error 8344
(29 May 2007 21:37:48)
2005 install error message. HELP!!!
(29 May 2007 21:19:6)
DTS Scheduling
(29 May 2007 21:13:53)
BCP utility
(29 May 2007 21:7:4)
why we need referential integrity?
(29 May 2007 18:18:46)
SQL reporting server 2000 report recovery?
(29 May 2007 18:2:40)
SQL Server Business Intelligence Development Studio not found ...
(29 May 2007 16:41:58)
Question about backup solutions
(29 May 2007 15:39:55)
@@lock_timeout
(29 May 2007 15:21:15)
DELETE OLD BACKUP FILES IN ORACLE
(29 May 2007 14:43:42)
openrowset from excel into table - max field length?
(29 May 2007 14:39:8)
Orphaned #Tables SQL2005 SP1 64-bit
(29 May 2007 14:31:22)
Regarding : SQL 2000 job
(29 May 2007 13:29:14)
SQL Server to DB2 Database Administration classes
(29 May 2007 11:27:10)
Sql Query
(29 May 2007 8:49:50)
Transaction Replication with more than 200 databases
(28 May 2007 19:5:36)
SQL Mail issues on SQL 2005 SP1
(28 May 2007 14:53:11)
SQL Server Conferences
(28 May 2007 5:10:27)
I/O Error
(26 May 2007 16:10:50)
LISTOWNER- EMAIL SHIELDING
(26 May 2007 13:0:2)
SQL Server Constraints
(25 May 2007 21:24:28)
Re: [SPAM] - RE: Help : sql 2005 sp2 install error Microsoft SQL Server 2005 error 1603 - Number of numbers in MIME From exceeds maximum threshold
(25 May 2007 20:47:42)
Login Form!
(25 May 2007 20:15:11)
Using BCP to export to UTF 8 format
(25 May 2007 18:47:16)
odbc
(25 May 2007 18:17:44)
Help : sql 2005 sp2 install error Microsoft SQL Server 2005 error 1603
(25 May 2007 18:11:59)
Error install SP2 on SQL Server 2005.
(25 May 2007 17:53:47)
Re: Login Form!--best practice
(25 May 2007 15:51:1)
Schemas in SQL 2005
(25 May 2007 14:26:31)
ms certification (MCITP: Database Developer)
(25 May 2007 10:33:42)
ssis 'checkpointfilename' property error
(25 May 2007 4:13:24)
Transaction Log Backup
(24 May 2007 20:26:24)
moving logs without detach
(24 May 2007 19:24:43)
Looking for info/best practices for transaction log on a SANS
(24 May 2007 18:50:14)
readable view
(24 May 2007 18:34:42)
Free up space in TempDB
(24 May 2007 17:36:34)
DTS and Blocking
(24 May 2007 16:58:25)
Urgent help !!
(24 May 2007 16:15:35)
SQL server 2005 - Remote access to Integration Services
(24 May 2007 16:14:42)
Database Mirroring
(24 May 2007 15:30:48)
This should be easy...
(24 May 2007 15:0:32)
Need help SQL 2005 configuration
(24 May 2007 14:56:33)
Full text search
(24 May 2007 14:51:29)
find jobs in sql server
(24 May 2007 8:37:21)
query-urgent
(24 May 2007 8:14:3)
Failover - Restore job fails in Logshipping
(24 May 2007 7:7:3)
shrink tempdb
(23 May 2007 18:54:13)
script showing sysadmin users
(23 May 2007 18:51:34)
Replication Over the Internet
(23 May 2007 17:23:53)
Help! with Restore
(23 May 2007 14:12:27)
Script for listing all Scheduled Tasks
(23 May 2007 13:14:19)
Insert Statement
(23 May 2007 12:10:2)
Help w/ job description : Report Server Administrator
(23 May 2007 11:46:19)
DTS and checking 1/0 question
(23 May 2007 11:22:0)
Trouble defining columns in target text file - dts package
(23 May 2007 8:28:35)
what objects are responsible for paging/disk access
(22 May 2007 23:8:15)
DUMP TRANSACTION
(22 May 2007 22:50:32)
sysusers vs. sys.sysusers
(22 May 2007 20:21:28)
@BeginDate declare - HELP
(22 May 2007 15:41:6)
query inquery
(22 May 2007 15:34:15)
export tables to multiple servers
(22 May 2007 13:38:42)
Query job scheduler
(22 May 2007 12:52:46)
xp_cmdshell - cannnot browse the remote machine
(22 May 2007 11:56:57)
SQL Space Statiscs
(22 May 2007 11:34:46)
Is there a client tool for sqlserver2005 like oracle sqlplus?
(22 May 2007 9:51:6)
IS sleeping processes affect the performance in sql server 2000
(22 May 2007 6:34:48)
bulk copy and performance
(21 May 2007 21:5:16)
Log file is full
(21 May 2007 20:8:34)
SQL Server 2005 Standard Edition Pricing
(21 May 2007 19:5:50)
process suspended
(21 May 2007 19:3:1)
column definition - exclusive lock
(21 May 2007 18:45:25)
Turn off logging
(21 May 2007 16:7:28)
Re: using openrowset to get data from another server many joins taking long time.
(21 May 2007 15:11:45)
Log Shipping Tool for Very Large Transactional DB
(21 May 2007 7:57:11)
Reindexing Error
(21 May 2007 6:42:19)
maintenance plan on cluster server
(18 May 2007 19:24:5)
SQL 2005 Connectivity
(18 May 2007 16:48:53)
dbcc inputbuffer alternative
(18 May 2007 16:29:50)
Re: [SPAM] - Temp table and sp set??? Solution found but not that satisfying. - Number of numbers in MIME From exceeds maximum threshold
(18 May 2007 15:57:41)
Temp table and sp set??? Solution found but not that satisfying.
(18 May 2007 15:51:29)
What is the maximum number of instances in 2005 for the enterpris e edition
(18 May 2007 15:21:13)
SQL Service - Stopping
(18 May 2007 15:17:1)
Production Database is in Suspect Mode
(18 May 2007 14:59:31)
Temp table and sp set???
(18 May 2007 14:50:40)
Re: [SPAM] - RE: Production Database is in Suspect Mode - Number of numbers in MIME From exceeds maximum threshold
(18 May 2007 14:47:57)
triggers firing in replication
(18 May 2007 12:14:10)
collation conflict : urgent pls
(18 May 2007 11:46:59)
Regarding SQL 2005 maintenance job - rebuild index.
(18 May 2007 11:21:20)
Query to swap columns of a table
(18 May 2007 3:44:45)
Trouble restoring SQL Server backup
(17 May 2007 22:22:46)
Re: database backup
(17 May 2007 18:41:8)
management help
(17 May 2007 15:59:39)
SQL 2000 and 2005
(17 May 2007 15:34:58)
Removing users from DB without login in 2005?
(17 May 2007 14:18:21)
insert 0 or nULL
(17 May 2007 14:10:4)
Please help. Getting message: buffer latch type 2
(17 May 2007 13:54:22)
Re: NULL insert]
(17 May 2007 13:37:2)
Service Accounts Change
(17 May 2007 12:29:10)
Transaction Isolation Level
(17 May 2007 12:15:29)
Installation of SQL server 2000
(17 May 2007 10:34:46)
using an item list in a sql statement
(17 May 2007 0:19:10)
Warehouse/ETL mail list?
(16 May 2007 21:8:0)
NULL insert
(16 May 2007 20:30:53)
DR solutions
(16 May 2007 19:43:38)
No Takers on Replication Monitoring Requirements??????
(16 May 2007 19:31:14)
redirecting mails to outlook folder
(16 May 2007 19:1:24)
[Possible Spam] RE: Adding Reporting Svcs to a SQL 2005 server
(16 May 2007 19:1:6)
CERTIFICATION
(16 May 2007 19:0:4)
Adding Reporting Svcs to a SQL 2005 server
(16 May 2007 18:8:33)
How to check service pack on SQL 2000?
(16 May 2007 18:3:17)
Finding size and creation date of tables, indexes
(16 May 2007 17:27:29)
UPDATEING MANY ROWSAND COLUMNS OF A TABLE
(16 May 2007 16:51:30)
User Security
(16 May 2007 16:33:22)
log shipping to a database that then allows read/write
(16 May 2007 16:31:3)
UPDATES OF MANY ROWS IN AND COLUMNS
(16 May 2007 16:21:54)
Linked server problem
(16 May 2007 15:36:40)
hi i am new to ms sql i want now diffenreces between ms sql2000 and 2005
(16 May 2007 15:33:4)
Before I give up - SSIS transfer databases
(16 May 2007 15:11:19)
need urgent help
(16 May 2007 14:49:41)
Exporting Table Schema
(16 May 2007 14:36:2)
Database Stuck In recovery SQL Server 2005
(16 May 2007 12:54:5)
Spurious Backup and Disabled Jobs
(16 May 2007 12:31:36)
Detailed Replication Monitoring Requirements
(16 May 2007 11:44:5)
Adding a DEFAULT to an exsiting column
(16 May 2007 11:21:21)
SQL Dynamic Query
(16 May 2007 9:19:21)
World of confusion -I live in
(16 May 2007 8:53:0)
Help for locating sequences
(16 May 2007 7:16:44)
Re: [SPAM] - Re: DBCC SHRINKDATABASE - Number of numbers in MIME From exceeds maximum threshold
(15 May 2007 23:29:2)
SQL ERROR LOG for ERROR 1067
(15 May 2007 22:55:16)
ERROR 1067 during startup
(15 May 2007 21:41:0)
SQL error 1067
(15 May 2007 21:31:50)
Enterprise Manager Problem! HELP!
(15 May 2007 21:19:11)
dbcc Shrinkdatabase
(15 May 2007 20:47:2)
DBA - Fulltime - Contract
(15 May 2007 19:49:54)
Re: Spam:RE: redirecting mails to outlook folder
(15 May 2007 19:20:54)
tempdb
(15 May 2007 19:0:13)
With (nolock) Dangerous.
(15 May 2007 18:42:15)
DTS / BULK IMPORT EXPORT
(15 May 2007 18:29:5)
do events()
(15 May 2007 17:31:40)
Insert problem
(15 May 2007 15:54:42)
Differences between sqlserver 2000 and sqlserver 2005
(15 May 2007 15:37:19)
Re: [SPAM] - RE: With (nolock) Dangerous. - Number of numbers in MIME From exceeds maximum threshold
(15 May 2007 15:26:3)
Re: Log File
(15 May 2007 15:6:59)
Re: [SPAM] - RE: [SPAM] - RE: Differences between sqlserver 2000 and sqlserver 2005 - Number of numbers in MIME From exceeds maximum threshold - Found word(s) list error in the Text body
(15 May 2007 14:53:53)
SQL Server Administration for Oracle DBAs
(15 May 2007 14:50:26)
Re: [SPAM] - RE: Differences between sqlserver 2000 and sqlserver 2005 - Number of numbers in MIME From exceeds maximum threshold
(15 May 2007 14:34:31)
DTS Connection Question
(15 May 2007 13:43:2)
Developers oh my
(15 May 2007 11:51:18)
Char Conversion Help.
(15 May 2007 11:42:52)
Management Studio
(15 May 2007 11:7:47)
Selectivity of columns.
(15 May 2007 9:54:9)
MS SQL Server questions
(15 May 2007 7:52:48)
Time Out Expired!!!
(15 May 2007 7:47:43)
Backup & Recovery tools
(15 May 2007 0:46:36)
Error Message SQL Server 2005
(14 May 2007 19:43:17)
Re: Possible Spam: Management Studio
(14 May 2007 19:11:54)
SQL server 2000 is not keeping job history
(14 May 2007 18:37:16)
Re: Backup Recovery tools
(14 May 2007 16:40:48)
Timeouts
(14 May 2007 16:27:31)
Used space in tempdb log file grows
(14 May 2007 15:42:30)
Recall: Help for locating sequences
(14 May 2007 15:39:12)
Anyone try to add SQL 2005 to Active Directory?
(14 May 2007 14:26:36)
Urgent!! Sql Server 2005 Reports
(14 May 2007 14:26:28)
Windows BITS tool
(14 May 2007 14:3:36)
Re: Time to think about migrating to SQL Server 2008?
(14 May 2007 13:51:59)
Linking MS SQL to Oracle 9i
(14 May 2007 13:18:48)
Using GO statements in SP
(14 May 2007 12:27:13)
Can't get into Job Manager with the SYS password
(14 May 2007 8:8:42)
Very very urgent
(13 May 2007 12:36:2)
Server Slowdown
(11 May 2007 21:53:15)
Reporting Services Data Set Question
(11 May 2007 20:55:21)
Re: Kill Pid
(11 May 2007 18:20:48)
Bulk insert, conversion error
(11 May 2007 16:26:57)
Sql reporting server issues
(11 May 2007 16:15:16)
Storing result of a select statement
(11 May 2007 14:59:35)
SQL Server 2005 Reporting
(11 May 2007 14:13:44)
help with fuction
(11 May 2007 13:42:14)
@@identity column
(11 May 2007 13:24:18)
Identity field in a VIEW
(11 May 2007 5:35:15)
ssis configuration file
(11 May 2007 4:41:31)
SQL Server Agent service account permissions
(10 May 2007 22:18:7)
SQL 2005 Backup and Restore
(10 May 2007 22:14:39)
osql - headers
(10 May 2007 18:57:28)
Oracle rownum equivalent in MSSQL?
(10 May 2007 18:51:41)
Re: [SPAM] - osql - headers - Number of numbers in MIME From exceeds maximum threshold
(10 May 2007 18:37:22)
Cube Question
(10 May 2007 17:58:32)
Importance of SQLH2
(10 May 2007 16:45:6)
Re: Update question
(10 May 2007 15:39:46)
Update script
(10 May 2007 12:53:31)
Transactional Replication with auto increment keys.
(10 May 2007 12:39:6)
MSSQL Performance
(10 May 2007 12:30:13)
Re: [SPAM] - Database Planning and Analysis - Number of numbers in MIME From exceeds maximum thresh
(10 May 2007 12:23:43)
Re: [SPAM] - Database Planning and Analysis - Number of numbers in MIME From exceeds maximum threshold
(10 May 2007 12:0:18)
Re: [SPAM] - RE: SQL 2005 Backup and Restore - Number of numbers in MIME From exceeds maximum threshold
(10 May 2007 11:40:29)
Reporting Services
(10 May 2007 9:31:17)
Database Planning and Analysis
(10 May 2007 4:44:32)
Date
(10 May 2007 0:33:39)
sql server job
(9 May 2007 18:20:46)
EXISTS
(9 May 2007 18:8:37)
Performance tips for this update?
(9 May 2007 18:7:13)
Assign sequence number to a second identity field
(9 May 2007 17:43:27)
Re: update
(9 May 2007 17:8:49)
Re: Database User Rights
(9 May 2007 16:50:55)
dynamic update statement - necessary?
(9 May 2007 16:23:36)
Query
(9 May 2007 15:54:5)
conversion from string data type to date time data type
(9 May 2007 14:59:2)
Still trying to trap those pesky errors
(9 May 2007 14:52:29)
Apostrophe
(9 May 2007 14:34:15)
Stop a rollback?
(9 May 2007 14:9:15)
Developers Standards
(9 May 2007 13:19:1)
Bulk Insert - 1800 records/transaction
(9 May 2007 12:48:48)
Monitoring SQLServer Database
(9 May 2007 12:16:10)
Deadlock while selecting the data
(9 May 2007 11:32:54)
User Defined Date
(9 May 2007 10:43:30)
Need help looping through with a cursor
(8 May 2007 20:49:56)
Can not attach my database
(8 May 2007 20:14:13)
Store Procedure Running long time
(8 May 2007 18:47:16)
Reporting Services reinstallation problems
(8 May 2007 16:45:53)
replication 2005
(8 May 2007 15:52:24)
Error when create a job in SQL Server 2005
(8 May 2007 15:19:47)
sql server fundamentals 2000
(8 May 2007 14:18:36)
checklist
(8 May 2007 13:50:15)
sql server2000 fundamentals
(8 May 2007 13:42:18)
Re: [RDNS failed] Auto No in SQL Query
(8 May 2007 11:10:57)
255 chars problem with DTS-Excel
(8 May 2007 10:34:55)
SQL 2005 encription
(7 May 2007 19:9:19)
msdb restore question
(7 May 2007 13:49:47)
What needs to be done for proper backup of production database
(7 May 2007 13:46:10)
Regulatory Compliance 101 for the Overworked DBA
(7 May 2007 12:45:24)
Help converting FK-related script from SQL 2005 to SQL2000
(7 May 2007 0:31:20)
DTS Problem - "Sleeping" Database
(6 May 2007 22:26:28)
DBCC INPUTBUFFER
(4 May 2007 22:16:1)
In Today's News
(4 May 2007 18:43:28)
SQL 2005 and Taskpad
(4 May 2007 17:25:17)
XML Data Type
(4 May 2007 14:54:15)
Arrrrgghhhhhhh - More ODD very very ODD
(4 May 2007 13:16:54)
Odd, very very odd.
(4 May 2007 12:56:3)
[Possible Spam] RE: Applying SQL2005 Sp2 HotFix to a MSCS Cluster.
(4 May 2007 12:33:48)
SQL memory
(4 May 2007 11:30:30)
Odd very very odd - UPDATE
(4 May 2007 8:38:42)
create job script
(4 May 2007 8:38:27)
High Bandwidth consumption by replication.
(4 May 2007 8:37:0)
@@IDENTITY - odd behaviour?
(4 May 2007 7:16:25)
Applying SQL2005 Sp2 HotFix to a MSCS Cluster.
(3 May 2007 18:2:43)
Refresh Problem SQLServer7
(3 May 2007 17:31:38)
Transactional Replication with Great Plains
(3 May 2007 16:56:20)
Transfer Logins Task in SQL Server 2000
(3 May 2007 16:20:6)
Backups on SQL Server 2005
(3 May 2007 15:2:1)
Problem with 2000 job system on a dts job
(3 May 2007 14:23:47)
Backup Failure
(3 May 2007 13:48:45)
Starting a Job From C#
(3 May 2007 13:41:23)
internationalization- Question
(3 May 2007 13:40:20)
Tempdb grows dreatically
(3 May 2007 12:57:38)
DTS Error string: Invalid class string
(3 May 2007 12:21:33)
Varchars & table width
(3 May 2007 11:19:39)
Table with failed jobs
(3 May 2007 11:16:59)
SQL 2005 Replication / distribution DB
(3 May 2007 8:21:50)
How to get user list in database?
(3 May 2007 5:3:47)
data types and performance
(3 May 2007 3:49:59)
Trigger
(2 May 2007 19:36:12)
slow server
(2 May 2007 19:21:9)
Script
(2 May 2007 18:50:5)
Copy Packages from one server to another server
(2 May 2007 18:9:27)
2005 orphaned users
(2 May 2007 17:28:56)
Export table data from SQL server to ORACLE
(2 May 2007 13:56:43)
Help with a Query
(2 May 2007 13:54:59)
create replica
(2 May 2007 13:10:25)
DTS Script
(2 May 2007 12:44:27)
Schedule Jobs to Copy from One server to another
(2 May 2007 9:44:54)
Data export task
(2 May 2007 8:36:42)
Delete
(2 May 2007 6:23:41)
Backup and Restore database in clustered SQL 2005
(2 May 2007 1:23:19)
OpenRowSet in SQL 2005
(1 May 2007 20:6:21)
Re: Structure dump in XML
(1 May 2007 15:50:2)
dts-export query into another table
(1 May 2007 15:27:17)
login failed for sa,root,admin
(1 May 2007 15:14:13)
Why won't this use the index??
(1 May 2007 14:42:10)
Indexes vs. Constraints
(1 May 2007 14:30:6)
Save query results to File
(1 May 2007 14:7:54)
In SQl 2005 does Shrink database also truncate the Log files?
(1 May 2007 13:34:26)
Full and Differential Backup in SQL Server
(1 May 2007 12:19:49)
Auto No in SQL Query
(1 May 2007 11:13:56)
Struction in XML
(1 May 2007 9:14:9)
Urgent
(1 May 2007 6:44:10)
sql lazydba home page