MS Sql Server

July 2007

Log file is missing
(31 Jul 2007 23:10:59)
I'm getting blocked left and right
(31 Jul 2007 22:7:8)
Using Access to create reports and queries to a SQL server
(31 Jul 2007 18:33:57)
Replication Setup
(31 Jul 2007 18:14:54)
Re: Linked Server Help - Possible solution!
(31 Jul 2007 17:49:42)
SQL Server 2005 Reporting Services (migration)
(31 Jul 2007 17:38:59)
insert thing
(31 Jul 2007 17:32:0)
Linked Server Help - Resent with error message!
(31 Jul 2007 17:20:15)
Linked Server Help
(31 Jul 2007 17:0:59)
Debugging Procs in SQL 2005
(31 Jul 2007 16:58:46)
Accents in Database
(31 Jul 2007 16:22:8)
restore database on another network
(31 Jul 2007 15:59:10)
Move Diagrams in SQL 2005
(31 Jul 2007 15:34:55)
error while opening DTS thru remote desktop
(31 Jul 2007 15:20:51)
Unused space in DB
(31 Jul 2007 15:8:56)
Getting the 2nd to max date for a table
(31 Jul 2007 14:20:29)
SQL Server - Counting All Rows In All Tables In All Databases
(31 Jul 2007 13:55:47)
Calculate Business Days Between Two Dates...
(31 Jul 2007 13:37:37)
sp_trace_create - @RC=12
(31 Jul 2007 12:57:18)
Fresh Install or Upgrade
(31 Jul 2007 12:20:3)
For XML
(31 Jul 2007 12:6:27)
Dynamics server error
(31 Jul 2007 11:46:42)
Re: Error 100 unable to start dynamics service - urgent
(31 Jul 2007 10:23:59)
List of tables
(31 Jul 2007 9:59:39)
Connection failed error
(31 Jul 2007 9:28:25)
Isn't if Friday yet
(31 Jul 2007 7:54:41)
SQL Server 2005 SP2
(30 Jul 2007 21:29:46)
Miscellaneous Problems
(30 Jul 2007 19:33:47)
Where do I put the SQL Server binaries on either 2000 or 2005
(30 Jul 2007 19:19:0)
T-SQL Backup all DBs
(30 Jul 2007 15:52:47)
Datatype Conversion Problem
(30 Jul 2007 15:21:54)
DB Growth Configuration Properties
(30 Jul 2007 15:1:17)
sp_MSforeachdb
(30 Jul 2007 14:33:9)
Error 100 unable to start dynamics service
(30 Jul 2007 13:42:41)
sql cluster issue
(30 Jul 2007 13:36:6)
What is better TempTable(#Table) or using Cursors ??
(30 Jul 2007 13:25:58)
sp_MSforeachdb and sp_MSforeachtable
(30 Jul 2007 13:25:20)
Calculate Age
(30 Jul 2007 13:16:20)
replication problems
(30 Jul 2007 12:55:38)
retrieve Age from ID_number
(30 Jul 2007 11:52:45)
Share point can not connect to the database
(28 Jul 2007 20:43:23)
LISTOWNER- EMAIL SHIELDING
(28 Jul 2007 13:0:2)
TransactionLog Truncation
(28 Jul 2007 10:47:9)
How to export list
(27 Jul 2007 21:56:48)
USERSTORE_TOKENPERM question
(27 Jul 2007 21:41:33)
Linked server query what am I missing?
(27 Jul 2007 18:53:13)
Interview question
(27 Jul 2007 15:30:16)
ASPSTATE/ViewState table - massive db growth
(27 Jul 2007 15:14:12)
How Do I force DTS package to Quit if File Does Not Exists?
(27 Jul 2007 14:59:0)
Joins Across Databases
(27 Jul 2007 14:50:17)
Referencing a different server
(27 Jul 2007 14:7:44)
QBE & SYSTEM TABLES
(27 Jul 2007 13:45:45)
why does msforeachdb do this
(27 Jul 2007 13:8:16)
SSRS parameters
(27 Jul 2007 12:33:39)
Urgent
(27 Jul 2007 12:31:4)
rotate results
(27 Jul 2007 12:27:23)
Dump Transaction log
(27 Jul 2007 12:25:58)
tfi friday
(27 Jul 2007 11:33:7)
Query
(27 Jul 2007 8:54:16)
replace single spaces
(27 Jul 2007 6:57:8)
Expanding Log file with recovery model set to SIMPLE
(26 Jul 2007 20:52:25)
Access Knowledge?
(26 Jul 2007 19:24:4)
DBCC Inputbuffer (UNCLASSIFIED)
(26 Jul 2007 19:2:5)
Odd Replication Error
(26 Jul 2007 18:10:40)
Migrating to SQL2005
(26 Jul 2007 17:37:11)
replace in stored procedure
(26 Jul 2007 17:33:4)
number conversion function
(26 Jul 2007 17:21:38)
Offline check
(26 Jul 2007 17:12:5)
Virtual Server / SQL Server 2005 / 64-bit
(26 Jul 2007 16:44:58)
SQL 2005 Error
(26 Jul 2007 16:31:7)
xp_stopmail, xp_startmail
(26 Jul 2007 16:29:11)
Error creating new database user
(26 Jul 2007 16:14:14)
database in suspect mode
(26 Jul 2007 15:52:23)
SQL Server 2000 Reporting Services Installation Media
(26 Jul 2007 15:40:6)
Indexes and replication
(26 Jul 2007 15:34:27)
Oracle e-books or links
(26 Jul 2007 15:33:56)
insert
(26 Jul 2007 15:0:29)
64-Bit Problems with 2005
(26 Jul 2007 14:19:48)
whats the quickest way to get a list of db's on a server
(26 Jul 2007 13:54:23)
transport in SAP
(26 Jul 2007 10:55:46)
SQL Server Agent will not start on cluster.
(26 Jul 2007 8:56:55)
Using substring
(26 Jul 2007 6:53:48)
Backup of Views and SPROCs
(26 Jul 2007 3:49:25)
SQL Server 2000 restore questions
(26 Jul 2007 3:16:27)
audit trigger
(26 Jul 2007 1:51:56)
Import question
(25 Jul 2007 19:15:11)
Logging Stored Procedure execution
(25 Jul 2007 18:39:58)
Step Error Source: Microsoft JET Database Engine
(25 Jul 2007 18:21:57)
padding / replication / preceding zeros - I'd leap out the windo w but Im on the ground floor
(25 Jul 2007 15:58:21)
Columns to Rows
(25 Jul 2007 15:55:34)
Is it advisable to install any antovirus software in a haavily used production Database
(25 Jul 2007 15:47:24)
user created db role
(25 Jul 2007 15:36:15)
Backup script question
(25 Jul 2007 15:31:0)
Setting up replication
(25 Jul 2007 15:8:7)
function help?
(25 Jul 2007 13:12:39)
Re: Using date functions
(25 Jul 2007 10:35:59)
migrating cubes from 2000 and 2005
(25 Jul 2007 7:50:9)
SQL 2005 Reporting Services
(24 Jul 2007 22:45:47)
SQL Server 2005 Management Studio SLOWNESS
(24 Jul 2007 19:28:45)
Getting service account info from SQL Server 2005
(24 Jul 2007 19:24:18)
Error: 9002, Severity: 17, State: 6 - TempDB Log File Full
(24 Jul 2007 16:17:25)
Exponential Conversion
(24 Jul 2007 15:48:8)
Suggestions needed.
(24 Jul 2007 15:17:49)
Error Message
(24 Jul 2007 14:16:2)
msdb Restore
(24 Jul 2007 14:0:6)
Question on Connection Killing
(24 Jul 2007 13:23:35)
Constraint how-to question
(24 Jul 2007 13:21:1)
Sharepoint gives an error all of a sudden
(24 Jul 2007 13:7:49)
DoubleTake Geocluster
(24 Jul 2007 10:59:3)
distributed transaction over a linked server
(24 Jul 2007 6:48:59)
Function
(23 Jul 2007 20:7:19)
FK between schemas
(23 Jul 2007 19:24:3)
Moving System Databases to different drives in Clustered Environment
(23 Jul 2007 16:32:49)
NOLOCK
(23 Jul 2007 15:59:54)
deadlock help
(23 Jul 2007 15:4:59)
Re: Replication Usefulness
(23 Jul 2007 14:35:11)
Replication Usefullness
(23 Jul 2007 14:31:54)
Domain users and sp_change_users_login
(23 Jul 2007 14:21:34)
sp_executesql
(23 Jul 2007 14:19:6)
Master Server? yea or nay?
(23 Jul 2007 14:17:5)
SQL2005 Insert into table with money field fails: Cannot insert null value into fld.
(23 Jul 2007 13:15:14)
problem with sp_columns in 2005
(23 Jul 2007 12:27:45)
large log file
(23 Jul 2007 11:59:53)
Release Unused Database Space
(23 Jul 2007 10:50:26)
sql server
(21 Jul 2007 13:52:52)
SQL Server (Reindex All Tables in All Databases)
(21 Jul 2007 13:41:20)
Replication / diff backups
(21 Jul 2007 1:35:14)
Optimizations
(20 Jul 2007 20:40:13)
Logical File name
(20 Jul 2007 18:0:53)
Cluster question - URGENT
(20 Jul 2007 15:36:45)
SQL 2005 Bulk Insert problem
(20 Jul 2007 15:25:3)
Data Dictionary Script for SQL server 2005
(20 Jul 2007 14:41:52)
Third Party Software
(20 Jul 2007 14:30:39)
sp_executesql - Help
(20 Jul 2007 14:26:17)
SQL Server 2000 and dropping user connections.
(20 Jul 2007 14:25:15)
SQL 2005 archive bit Question
(20 Jul 2007 14:7:38)
Linked Server
(20 Jul 2007 14:6:12)
Cycle log in SQLServer 2000
(20 Jul 2007 13:51:12)
Script to list all permissions for a role
(20 Jul 2007 13:44:28)
Calling multiple SP's in one job
(20 Jul 2007 13:37:42)
Important Notice!
(20 Jul 2007 11:1:14)
Reporting Services Language Settings
(20 Jul 2007 9:48:52)
Anybody know if...
(20 Jul 2007 8:23:44)
SQL_Latin1_General_CI_AS_KS_WS collation
(19 Jul 2007 20:16:40)
XMLmodeling within relational schemas
(19 Jul 2007 18:55:3)
Linked Servers
(19 Jul 2007 17:21:53)
Apex Tools
(19 Jul 2007 17:15:23)
SQL Job question
(19 Jul 2007 15:20:19)
Reporting Services report issue/question
(19 Jul 2007 14:47:15)
DBCC SHRINKFILE Command not working
(19 Jul 2007 14:24:2)
instance install issue ~ Edition Change Check ~ help
(19 Jul 2007 14:19:45)
Shrinking files or at least supposed to be
(19 Jul 2007 13:43:22)
(SQL Server 2005) Linked server to DB2
(19 Jul 2007 12:55:25)
SSIS connectivity issues - going around in circles
(19 Jul 2007 11:54:31)
DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, ALL_ERRORMSGS, NO_INF OMSGS
(19 Jul 2007 10:38:37)
Restore filegroup
(18 Jul 2007 20:31:45)
Database modeling
(18 Jul 2007 18:34:29)
Re: Purge & Dynamic SQL
(18 Jul 2007 18:24:43)
Reporting Services
(18 Jul 2007 16:21:25)
Purge
(18 Jul 2007 15:58:46)
AS remote connection
(18 Jul 2007 14:48:20)
create destination table issues in integration services
(18 Jul 2007 13:8:21)
Right assigned to particular role
(18 Jul 2007 7:50:35)
reporting services 2005
(18 Jul 2007 7:39:30)
mssqlsystemresource.mdf
(17 Jul 2007 20:59:28)
check for existance of a cursor
(17 Jul 2007 20:2:30)
Maintenance jobs and shrinking of DB
(17 Jul 2007 19:5:50)
INTERMITTENT PERFORMANCE ISSUES.
(17 Jul 2007 17:50:24)
Guidance Please
(17 Jul 2007 17:33:14)
Thought this might interest you: Oracle Database 11g: The Top Features for DBAs and Developers
(17 Jul 2007 17:30:28)
11g
(17 Jul 2007 17:24:11)
Re: Possible Spam: INTERMITTENT PERFORMANCE ISSUES.
(17 Jul 2007 17:22:20)
SQL Server 2005 - Linked Server question
(17 Jul 2007 16:22:0)
Help with Dates
(17 Jul 2007 15:39:13)
Additional Information to Previous Date Post
(17 Jul 2007 14:24:58)
Previous Date Post Additional Information
(17 Jul 2007 14:21:5)
LDF file
(17 Jul 2007 13:56:6)
PV function help
(17 Jul 2007 13:53:9)
Combining Files
(17 Jul 2007 13:53:7)
Archiving Table data
(17 Jul 2007 13:23:47)
SQL Mail Problem
(17 Jul 2007 12:26:23)
Date Format
(17 Jul 2007 11:27:41)
SQL 2005 DB offline
(16 Jul 2007 23:55:11)
Active directory/SQL Question
(16 Jul 2007 22:24:6)
Group By Order
(16 Jul 2007 18:57:35)
Transactional replication error
(16 Jul 2007 17:24:28)
mirroring please help
(16 Jul 2007 15:19:48)
help needed with dates
(16 Jul 2007 15:11:42)
More date conversion problems
(16 Jul 2007 13:55:55)
sp_msforeachdb killing me...
(16 Jul 2007 8:19:6)
mental subquery friday not enough cape town wine block
(13 Jul 2007 20:13:48)
How to invoke db mail?
(13 Jul 2007 20:3:20)
Sync'ing data center advice?
(13 Jul 2007 19:1:50)
restore db problem
(13 Jul 2007 18:28:58)
Trying to delete Agent Jobs
(13 Jul 2007 16:53:48)
Interesting Fact Every DBA should know
(13 Jul 2007 16:28:36)
restore error
(13 Jul 2007 15:28:14)
inserts and indexes
(13 Jul 2007 13:17:43)
Re: Administrator - Please help
(13 Jul 2007 13:14:14)
The most helpful/lazy dbas around!
(13 Jul 2007 13:1:55)
SQL Server 2005 (Stuff)
(13 Jul 2007 12:36:40)
where can i find default values of procedure
(13 Jul 2007 12:0:12)
SQL Server Agent
(13 Jul 2007 8:50:27)
Evaluate a variable as a query?
(13 Jul 2007 3:21:41)
Replication: Oracle to Sql Server
(12 Jul 2007 18:38:40)
What is better, less I/O or less CPU Usage?
(12 Jul 2007 18:22:50)
Report Services - Report Design Guide?
(12 Jul 2007 16:25:38)
SQL Server 2005 Copy Database Wizard
(12 Jul 2007 14:30:34)
I have to complain to sympathetic ears...
(12 Jul 2007 11:51:35)
Darn Sniper Email Bot!
(12 Jul 2007 8:26:6)
Moving log file
(12 Jul 2007 1:15:30)
Re: SSIS packages still
(11 Jul 2007 22:36:40)
sp_change_users_login
(11 Jul 2007 20:18:34)
Cannot Generate SSPI Context
(11 Jul 2007 19:35:17)
sql profiler setup for database restore
(11 Jul 2007 18:57:18)
Database Scanners
(11 Jul 2007 18:51:57)
Convert Part 3
(11 Jul 2007 18:8:31)
Replication guru question
(11 Jul 2007 17:7:33)
Operating system error 64(The specified network name is no long
(11 Jul 2007 16:11:13)
Replication Loop?
(11 Jul 2007 15:40:52)
help needed
(11 Jul 2007 14:39:13)
To add clarification...
(11 Jul 2007 14:14:25)
Decimal places question
(11 Jul 2007 14:12:54)
Help Please
(11 Jul 2007 14:6:20)
export to excel file
(11 Jul 2007 13:19:0)
never been a cursor person :)
(11 Jul 2007 12:23:33)
Re: double space covert to " . help !!!!!
(11 Jul 2007 10:3:53)
Store procedure check dead lock
(11 Jul 2007 10:1:22)
Getting the filename from a path
(10 Jul 2007 23:57:6)
Sort Problem
(10 Jul 2007 19:53:0)
Time value stored as int
(10 Jul 2007 18:22:35)
tempdb
(10 Jul 2007 17:49:56)
CONVERT round 2
(10 Jul 2007 16:8:59)
SSIS packages still and Reporting Services
(10 Jul 2007 15:44:52)
Why won't this work (SQL Server 2000)
(10 Jul 2007 15:35:48)
double space covert to " ... help !!!!!
(10 Jul 2007 15:28:56)
RECMODEL_70BACKCOMP
(10 Jul 2007 15:26:8)
Percentile Calculation
(10 Jul 2007 15:4:0)
Standards
(10 Jul 2007 14:54:58)
Inserting records when there is a foreign key dependency
(10 Jul 2007 14:43:4)
Convert issue minutes to MM/DD/YYYY
(10 Jul 2007 14:39:8)
Re: LINQ - Debate
(10 Jul 2007 14:9:2)
SQL Server and Oracle Intraction
(10 Jul 2007 13:15:57)
Alert on mobile
(10 Jul 2007 13:14:59)
Webservice
(10 Jul 2007 12:19:58)
Memory
(10 Jul 2007 11:43:17)
Hai
(10 Jul 2007 5:50:58)
UPDATE NOT WORKING
(9 Jul 2007 22:4:51)
SSIS packages
(9 Jul 2007 21:25:41)
Phone number Format
(9 Jul 2007 17:51:55)
Error Encountered by SQL Alert
(9 Jul 2007 16:17:0)
problems with cube
(9 Jul 2007 14:37:46)
Filegroups and ndf
(9 Jul 2007 13:32:57)
result like this 07/09/2007 05:31:57 PM
(9 Jul 2007 12:7:3)
Log file full
(9 Jul 2007 11:36:25)
Table Locking
(9 Jul 2007 9:21:51)
Regarding sqlbacup
(8 Jul 2007 10:17:33)
DTS Package question
(6 Jul 2007 20:18:18)
DISABLE
(6 Jul 2007 20:7:44)
Stored proc issue (Ad-hoc only)??
(6 Jul 2007 17:52:10)
Dev environment
(6 Jul 2007 17:38:13)
Replication with 2000 and 2005
(6 Jul 2007 17:34:21)
Duplicates in SQL
(6 Jul 2007 17:4:16)
xp_sendmail works for individuals but not for groups
(6 Jul 2007 16:41:48)
Active/Active Clustering
(6 Jul 2007 15:26:35)
Reporting Services.
(6 Jul 2007 15:10:56)
weekend
(6 Jul 2007 15:9:2)
2005 mode on dbs
(6 Jul 2007 15:3:40)
Beer / Liquor subject changed !!
(6 Jul 2007 14:48:56)
Re: Irish Pub :)
(6 Jul 2007 14:40:55)
Export Header_Row to FileSystem
(6 Jul 2007 14:18:21)
Reporting Manager Counter
(6 Jul 2007 14:12:20)
Sql server 2000 sp4 risk
(6 Jul 2007 13:30:17)
fat chance but worth a try
(6 Jul 2007 13:25:47)
Urgent Help needed!!!
(6 Jul 2007 12:51:7)
Conditional workflow issue in DTS
(6 Jul 2007 12:51:2)
differential backup must be tied to particular server ? (sql 200 0)
(6 Jul 2007 10:56:32)
changing data in a text field but only where there is numerics
(6 Jul 2007 10:3:8)
Reporting Manager
(6 Jul 2007 8:20:8)
Substring/Convert help
(6 Jul 2007 7:2:7)
Defragmenting an .mdf or .ldf file
(5 Jul 2007 20:7:50)
Space Available in EM Taskpad View (UNCLASSIFIED)
(5 Jul 2007 19:43:12)
Backup
(5 Jul 2007 18:21:19)
Database maintenance plans
(5 Jul 2007 17:38:13)
Replication
(5 Jul 2007 15:13:54)
sql 2005 service broker
(5 Jul 2007 14:40:43)
Enumerating and restoring users, roles, permissions
(5 Jul 2007 13:48:27)
stoopid AS 2005 Q
(5 Jul 2007 13:17:42)
SQL SERVER 2005 SQLCMD
(5 Jul 2007 12:27:33)
SQL Server 2005 SSIS Packages Link
(5 Jul 2007 11:46:47)
SQL DTS Package Log slow
(5 Jul 2007 6:24:13)
Using SQL 2000 DbEngine as a back end to SQL 2005 Analysis server
(4 Jul 2007 15:4:33)
DTS or whatever its' called in 2005
(4 Jul 2007 15:2:55)
SP Parameter list
(4 Jul 2007 14:19:22)
Updating table which contains a foreign key
(4 Jul 2007 13:32:12)
Reporting Services - Oracle.
(4 Jul 2007 13:20:50)
Log shipping option not visible
(4 Jul 2007 13:20:10)
Performance Monitor - Time line
(4 Jul 2007 11:30:20)
Transaction Replication Error in 2000
(4 Jul 2007 11:27:24)
Size of Tables?
(4 Jul 2007 8:1:13)
question.... "maintenance sp's"
(4 Jul 2007 6:45:25)
isolation level spanning the cursor
(4 Jul 2007 6:22:5)
There must be a way....
(4 Jul 2007 0:16:37)
Re: [SPAM] RE: If statement in a sql query
(3 Jul 2007 20:10:17)
SQLCMD.EXE with -v
(3 Jul 2007 17:29:20)
If statement in a sql query
(3 Jul 2007 17:27:15)
SQL 2005 data import
(3 Jul 2007 14:11:53)
Format in MS-Query
(3 Jul 2007 13:58:36)
Performance Monitor - X-axis
(3 Jul 2007 13:28:8)
database restore
(3 Jul 2007 13:15:30)
Suppress Messages when executing Stored Proc as a Scheduled Job
(3 Jul 2007 13:9:33)
Identifying the Column that Defines the partition
(3 Jul 2007 12:23:25)
Differences between Linked Servers and Remote Servers?
(3 Jul 2007 8:45:3)
ForEach Loop container
(2 Jul 2007 19:13:53)
Managing SQL 2000 Users Best Practice
(2 Jul 2007 18:19:15)
Stupid script task !!!
(2 Jul 2007 17:56:27)
The Mystery of Downtime
(2 Jul 2007 17:44:35)
Function within a function, whets the right way to do this?
(2 Jul 2007 17:13:41)
SQL2005 DTS schedule legacy job
(2 Jul 2007 16:12:26)
How to count whcihc query executed how many time in sql server
(2 Jul 2007 13:40:8)
Re: How to count which query executed how many time in sql server
(2 Jul 2007 13:27:6)
TOP 100 Records.
(2 Jul 2007 13:16:53)
Report Model in SQL 2005 Reporting Services
(2 Jul 2007 11:56:46)
Need help to transfer users from sql server 2000 to 2005
(2 Jul 2007 11:50:12)
change a job owner
(2 Jul 2007 9:58:16)
MDX
(2 Jul 2007 7:30:37)
what users are executing
(1 Jul 2007 12:29:8)
sql lazydba home page