MS Sql Server

September 2006

LISTOWNER- EMAIL SHIELDING
(30 Sep 2006 13:0:2)
Does anyone have a script for SQL Agent job analysis?
(29 Sep 2006 19:34:8)
today is my Friday but have great unknown unsearchable question. . . .
(29 Sep 2006 19:33:49)
View not using an Index
(29 Sep 2006 18:48:59)
2005 Reporting Services
(29 Sep 2006 18:38:31)
Re: SQL Server vs Enterprise Edition
(29 Sep 2006 14:46:46)
Trace for ODBC Connections
(29 Sep 2006 14:29:42)
ADO syntax
(29 Sep 2006 12:47:58)
Use of STANDBY Parameter
(29 Sep 2006 12:46:35)
Email notifications
(29 Sep 2006 8:18:42)
Moving Databases
(29 Sep 2006 6:29:51)
Design Question
(29 Sep 2006 6:21:11)
Conditional unique index?
(29 Sep 2006 3:0:30)
Hello folks - question on fixing identity field
(28 Sep 2006 22:54:58)
DATABASE NOT PERFORMING
(28 Sep 2006 22:37:46)
Msforeachtable issue with getting upated status
(28 Sep 2006 21:1:21)
Find 2nd, 3rd, & 4th rows if available
(28 Sep 2006 20:52:55)
SQL Cluster - HELP
(28 Sep 2006 19:44:17)
kinda quick solution needed to truncate transaction log
(28 Sep 2006 17:43:55)
Moving to a new filegroup.
(28 Sep 2006 17:38:22)
output file
(28 Sep 2006 17:18:11)
Error While executing Jobs in SQL Server 2000
(28 Sep 2006 16:22:23)
Something wrong with this string?
(28 Sep 2006 15:52:22)
Help, how do I shrink my tran log?
(28 Sep 2006 15:36:55)
does this sp_who2 result mean anything to anyone?
(28 Sep 2006 14:42:14)
Select Permissions for DTS packages - Mgmt Studio
(28 Sep 2006 13:53:0)
Why need ndfeven we create mdf more
(28 Sep 2006 13:23:50)
Union Query...
(28 Sep 2006 12:50:0)
HTML output in email from SQL Server 2000
(28 Sep 2006 12:12:11)
Collation issue
(28 Sep 2006 10:27:1)
Urgent Please Solve SP Problem
(28 Sep 2006 10:14:37)
Collation problem
(28 Sep 2006 9:41:14)
Collation problem.
(28 Sep 2006 9:15:18)
bookmark lookup
(28 Sep 2006 8:22:33)
Not able to start Service using local SQL account
(27 Sep 2006 23:10:22)
SQL Server 2005 Maximum memory
(27 Sep 2006 20:0:48)
Standard Edition to EE
(27 Sep 2006 18:40:55)
SQL Connectivity Across Novell Network
(27 Sep 2006 18:26:24)
sysjobs
(27 Sep 2006 18:10:27)
HELP!
(27 Sep 2006 17:11:0)
How to find out last time stored procedure was used
(27 Sep 2006 15:25:11)
DTS recover from sysdtspackages table with help of textcopy
(27 Sep 2006 13:29:46)
TNS could not resolve service name
(27 Sep 2006 13:8:32)
DTS package information
(27 Sep 2006 12:40:33)
Projection
(27 Sep 2006 12:31:21)
Excellent opportunity for You / Requirement of Sysbase / Oracle / DB2 / DB2 UDB / SQL DBA in HSBC Global Technology Centre ,Pune
(27 Sep 2006 9:20:0)
What are standard procedure for SQL Server health check / performance issue troubleshooting....
(27 Sep 2006 7:46:2)
Need some Data-structure explanation
(26 Sep 2006 21:42:35)
permissions continued...
(26 Sep 2006 20:13:2)
dynamic table prefixes, how?
(26 Sep 2006 18:47:3)
Only for fun . . .
(26 Sep 2006 15:6:48)
list of tables with indexes
(26 Sep 2006 14:38:18)
Unable to attach a database.
(26 Sep 2006 8:2:43)
Agent Service Not installed on XP and not been able to install it
(25 Sep 2006 19:44:24)
SQL 2005 Key Permissions
(25 Sep 2006 18:49:21)
Table - disk page ownership ??
(25 Sep 2006 18:31:48)
Linked Server
(25 Sep 2006 18:22:55)
Changed server name old DTS jobs running
(25 Sep 2006 15:58:27)
Replication error
(25 Sep 2006 14:55:4)
Re: Re your question about imports that failed last week -- Posted in error
(25 Sep 2006 13:59:46)
Re your question about imports that failed last week.
(25 Sep 2006 13:53:32)
PEARL SCRIPTS
(25 Sep 2006 12:51:20)
DTS restore from msdb backup
(25 Sep 2006 12:47:13)
How to confirm the size of a database
(25 Sep 2006 12:34:22)
Comparing String!!!
(25 Sep 2006 8:10:16)
Logging in Application Log!!!!
(25 Sep 2006 5:56:12)
Create HTML report from T-SQL Query?
(25 Sep 2006 5:51:41)
User Permissions
(24 Sep 2006 10:41:31)
sp_makewebtask
(22 Sep 2006 22:45:42)
Failure on rebuild of master
(22 Sep 2006 20:42:18)
transaction log shrink via batch file?
(22 Sep 2006 20:19:58)
LDF file is huge
(22 Sep 2006 17:48:6)
Magical Record..
(22 Sep 2006 16:51:2)
Launching a trace
(22 Sep 2006 16:42:54)
xp_sendmail error
(22 Sep 2006 16:2:30)
Log shipping
(22 Sep 2006 15:58:57)
Kids Stuff
(22 Sep 2006 13:30:59)
Red Gate SQL Backup
(22 Sep 2006 10:38:16)
Replica means identical right? !!!!!
(22 Sep 2006 6:33:49)
MSDTC service not available.
(22 Sep 2006 6:28:55)
DTS Package
(21 Sep 2006 20:17:29)
SQL Cluster - IP Address
(21 Sep 2006 19:7:49)
SQL 2000
(21 Sep 2006 17:53:17)
SQL Server Named Instance connectivity
(21 Sep 2006 15:34:32)
Re: [Spam?] (4) SQL Server Named Instance connectivity
(21 Sep 2006 15:7:37)
Options for removal of IDS from warm server
(21 Sep 2006 15:4:7)
Login/user problem after restore
(21 Sep 2006 14:6:4)
BATCHES and Email
(21 Sep 2006 13:45:15)
tables reffered in my procedure
(21 Sep 2006 13:40:44)
Referential integrity
(21 Sep 2006 4:20:28)
Re: [Spam?] (4) RE: tables reffered in my procedure
(21 Sep 2006 3:42:10)
Trying to Save a Stored Proc
(20 Sep 2006 22:52:31)
Backup
(20 Sep 2006 22:6:37)
SQL Server Auditing
(20 Sep 2006 21:49:43)
Just checking if I can E-Mail this group.
(20 Sep 2006 18:57:10)
Parsing Text fields in SQL
(20 Sep 2006 17:55:18)
Passing parameters to a DTS package
(20 Sep 2006 17:52:15)
SQLServer & SQLServerAgent Logins
(20 Sep 2006 15:20:51)
Unzip Files in Windows 2003 Server
(20 Sep 2006 14:46:40)
Update query - subquery returns more than one row
(20 Sep 2006 14:14:43)
How can use user define function with out any user prefix
(20 Sep 2006 13:55:38)
Microsoft SQL Server 2000 Licenses
(20 Sep 2006 12:50:58)
Re: [Spam?] (4) Any Tips on using SELECT INSERT UPDATE?
(20 Sep 2006 12:13:44)
How to restore transaction log backups!!!!
(20 Sep 2006 12:11:43)
encrypting database
(20 Sep 2006 12:4:47)
Re: [Spam?] (4) tables reffered in my procedure
(20 Sep 2006 11:41:44)
SQL Readmail
(20 Sep 2006 11:28:9)
export to CSV
(20 Sep 2006 9:26:37)
Any Tips on using SELECT INSERT UPDATE?
(20 Sep 2006 6:10:19)
Help with an update statement
(19 Sep 2006 20:44:17)
Query Help
(19 Sep 2006 19:34:0)
Pl. Explain Why it not working
(19 Sep 2006 16:46:50)
replication problems
(19 Sep 2006 16:32:9)
Deadlock question
(19 Sep 2006 15:57:25)
Refrence books for SQL DBA & DTS
(19 Sep 2006 15:37:15)
Is it possible to grab the paths of all databases to be backed up programmatically?
(19 Sep 2006 14:20:12)
Data Projections
(19 Sep 2006 14:6:45)
Sarbanes-Oxley
(19 Sep 2006 13:35:14)
R: Sarbanes-Oxley
(19 Sep 2006 13:8:34)
Where's my profile table?
(19 Sep 2006 10:53:35)
Filer
(19 Sep 2006 8:45:45)
Disadvantage of Transactional backup
(18 Sep 2006 20:21:10)
What is the easiest approach to assign the privilege to an account to execute all user-defined stored procedure under a database?
(18 Sep 2006 20:5:26)
Audit user access
(18 Sep 2006 18:23:48)
Disadvantage--backup
(18 Sep 2006 17:5:12)
Location - scripts
(18 Sep 2006 11:11:21)
Select Query - Help Required
(18 Sep 2006 9:44:8)
received e-mai
(18 Sep 2006 9:40:46)
Vacancies in my company
(18 Sep 2006 7:5:48)
Access Denied Error in XP_CMDSHELL!!!
(18 Sep 2006 7:4:0)
urgent help required
(17 Sep 2006 20:41:59)
DTS problem - excel - truncates after 255 chars
(17 Sep 2006 19:31:26)
Logging and auditing
(15 Sep 2006 21:30:17)
LISTOWNER - Posting Delay - fixed
(15 Sep 2006 21:26:30)
LISTOWNER - Posting Delay - 2nd probe
(15 Sep 2006 21:23:9)
SQL server STD vs Enterprise
(15 Sep 2006 20:54:58)
Re: sqlplus / as sysdba
(15 Sep 2006 20:2:30)
Restoring a database from 2k5 to 2K
(15 Sep 2006 20:0:21)
LISTOWNER - Posting Delay
(15 Sep 2006 19:39:33)
set up a network path as a backup
(15 Sep 2006 18:49:22)
Lazy DBA Posting Delay
(15 Sep 2006 16:26:16)
Temp Table issue
(15 Sep 2006 12:51:16)
INDEXES
(15 Sep 2006 11:37:14)
Caching a database
(15 Sep 2006 10:29:8)
Re: Max Memory on SQL2000 SE
(15 Sep 2006 7:4:38)
Port Number on 2005
(15 Sep 2006 6:41:55)
IO issue
(14 Sep 2006 23:4:50)
Backups
(14 Sep 2006 21:7:52)
Re: (4) SQL server STD vs Enterprise
(14 Sep 2006 20:50:4)
Re: [Spam?] (4) RE: Temp Table issue
(14 Sep 2006 20:38:4)
Re: [Spam?] (4) SQL server STD vs Enterprise
(14 Sep 2006 19:52:44)
Navision 3.7 SQL2k 32bit migrating to SQL 2k5 64 bit - any known issues?
(14 Sep 2006 19:46:28)
Replication over Internet
(14 Sep 2006 17:50:36)
How to assign privilege for a user to view jobs for some databases only in Enterprise Manager?
(14 Sep 2006 17:2:38)
SQL 2005 Database Mail using SQL authenication and attachments
(14 Sep 2006 17:1:35)
Sending mail if master..xp_cmdshell give error!!!
(14 Sep 2006 15:53:31)
Re:Type Mismatch Errors
(14 Sep 2006 15:34:12)
Why does this happen?
(14 Sep 2006 13:37:16)
Type Mismatch Errors
(14 Sep 2006 12:56:16)
Restore Question
(14 Sep 2006 11:28:51)
Re: [Spam?] (4) RE: xp_cmdshell
(14 Sep 2006 8:50:5)
Hmmm...update with unexpected results
(13 Sep 2006 22:23:0)
Where do triggers display in Management Studio?
(13 Sep 2006 20:15:8)
What is an IO count?
(13 Sep 2006 19:40:49)
Update with unexpected results
(13 Sep 2006 19:32:49)
Re: Type Mismatch Errors]
(13 Sep 2006 18:59:31)
Could not start a transaction for OLE DB provider 'IBMDA400'
(13 Sep 2006 17:43:19)
Re: [Spam?] (4) RE: [Spam?] (4) RESTORE question
(13 Sep 2006 17:31:56)
Re: [Spam?] (4) RE: RESTORE question
(13 Sep 2006 17:16:23)
Re: [Spam?] (4) RESTORE question
(13 Sep 2006 16:46:14)
XP_CMDSHELL
(13 Sep 2006 15:26:14)
cpu util
(13 Sep 2006 13:36:31)
Db2 UDB information
(13 Sep 2006 13:31:34)
Moving a bunch of DTS packages in SQL2000
(12 Sep 2006 22:40:56)
Linked Servers
(12 Sep 2006 18:58:50)
question about compressed files
(12 Sep 2006 18:17:32)
Need feedback asap!!
(12 Sep 2006 18:1:45)
time
(12 Sep 2006 15:19:31)
error 998
(12 Sep 2006 14:47:58)
SQL Server Port Number
(12 Sep 2006 13:47:53)
Passing parameters to the job!!!!
(12 Sep 2006 7:46:4)
Re: [Spam?] (4) Email
(12 Sep 2006 6:42:26)
SQL Server DTS Error - Transfering Jobs
(12 Sep 2006 4:37:27)
Regarding SQL Server Documents
(12 Sep 2006 4:34:41)
Error in log
(11 Sep 2006 21:10:27)
Backup and restore scripts
(11 Sep 2006 19:17:36)
Re: Email: WORKING
(11 Sep 2006 16:58:0)
Oracle 10g DB training
(11 Sep 2006 16:42:26)
Granting Permission on SPS in simple way!!!!!!!!
(11 Sep 2006 15:38:56)
Timeout Issue
(11 Sep 2006 15:18:57)
DTS to export views and stored procedures only?
(11 Sep 2006 15:3:15)
ActiveX Job issue.
(11 Sep 2006 14:33:57)
Re: [POSIBLE SPAM] (51%) Timeout Issue
(11 Sep 2006 14:2:6)
How to define an IO?
(8 Sep 2006 21:26:35)
Neat Replication Find
(8 Sep 2006 18:38:8)
DTS/ JOB execution issues with Oracle involved
(8 Sep 2006 18:35:16)
crosstab query
(8 Sep 2006 18:21:51)
How to programmatically determine the owners of DTS
(8 Sep 2006 17:47:56)
DTSs
(8 Sep 2006 16:55:56)
performance degradation after moving to AD
(8 Sep 2006 16:25:10)
Re: Suggestion for Splitting Database
(8 Sep 2006 15:23:18)
xpsmtp80.dll
(8 Sep 2006 14:37:26)
SQL Log shipping in sql 2000 Standared edition
(8 Sep 2006 14:23:46)
Db Performance
(8 Sep 2006 14:6:35)
Re: TPN POSSIBLE SPAM:SQL Log shipping in sql 2000 Standared edition
(8 Sep 2006 13:59:30)
'dynamic' join in Views
(8 Sep 2006 13:49:19)
Re: TPN POSSIBLE SPAM:RE: SQL Log shipping in sql 2000 Standared edition
(8 Sep 2006 13:22:42)
Ghost cleanup
(8 Sep 2006 13:3:29)
Tape Backup Question
(8 Sep 2006 12:52:59)
Vacancy for the post of MS-SQL DBA
(8 Sep 2006 12:40:27)
Execution of sp's on replicated db
(8 Sep 2006 12:37:40)
How to imporve the SP whoes performance is Very low.
(8 Sep 2006 10:27:37)
xp_sendmail: failed with mail error 0x80040119
(8 Sep 2006 10:24:25)
Suggestion for Spliting Database
(8 Sep 2006 9:35:46)
Sending data >32k by a stored procedure
(8 Sep 2006 6:50:6)
Index
(8 Sep 2006 4:49:40)
SQL Server 2005 Upgrade Path
(8 Sep 2006 1:19:56)
Replication and Calculated fields
(7 Sep 2006 22:44:56)
SQL Server Linked Tables
(7 Sep 2006 21:44:19)
High paging rate
(7 Sep 2006 20:21:48)
Interesting workaround to our data/network problem
(7 Sep 2006 18:44:21)
Ok, so we had a major melt down
(7 Sep 2006 17:29:50)
DB ndex
(7 Sep 2006 14:44:53)
Tool to compare Databases in MSSQL
(7 Sep 2006 14:25:40)
Log files
(7 Sep 2006 11:25:38)
Cannot Detach the database 'distribution' because it is being used for replication
(7 Sep 2006 9:50:39)
Distribution database Log file is full
(7 Sep 2006 9:16:35)
SQL Server logs
(7 Sep 2006 6:54:50)
log shipping demistified
(7 Sep 2006 1:22:27)
unix time conversion
(7 Sep 2006 1:2:25)
Which table restore the information of log file path in SQL 7?
(6 Sep 2006 20:56:38)
Re: [Spam?] (5) Need help with a query to improve performance
(6 Sep 2006 20:2:42)
How to programmatically determine roles of all accounts from the table, sysusers?
(6 Sep 2006 20:2:31)
Easy One! Security
(6 Sep 2006 20:0:21)
Need help with a query to improve performance
(6 Sep 2006 19:57:51)
Re: [Spam?] (4) Easy One! Security
(6 Sep 2006 19:57:21)
sp_who2
(6 Sep 2006 19:57:3)
@@CPU_BUSY and CPUTime when running sp_who2
(6 Sep 2006 19:53:26)
need to replace carriage returns and commas
(6 Sep 2006 19:33:34)
Cross Database permissions
(6 Sep 2006 17:24:12)
Statistics
(6 Sep 2006 16:52:2)
Server Consolidation Project - VMWare - SQL Server 2000
(6 Sep 2006 15:21:57)
Mapping Logins for a Linked Server
(6 Sep 2006 15:16:14)
Trn. Log backup larger then log file.
(6 Sep 2006 15:12:30)
error while attaching data files
(6 Sep 2006 12:32:27)
SQL Server 2000 Table and column level security
(6 Sep 2006 12:9:18)
How do I write files with Transact SQL or use LOOPs and variable file names in DTS?
(6 Sep 2006 11:43:2)
SQL 2000 Log Viewer
(6 Sep 2006 11:30:39)
SQL Collation Issue
(6 Sep 2006 11:30:39)
Clarification Required Please!!!!!!!!!!!!
(6 Sep 2006 11:2:49)
anyone seen this error?
(6 Sep 2006 4:15:23)
How to find instance associated IP
(6 Sep 2006 2:59:49)
Database growth monitoring script ...
(5 Sep 2006 22:7:45)
SQL2005 and SOX compliance
(5 Sep 2006 20:35:38)
Re: [Spam?] (4) Data file set to 10% unrestricted growth is ignored
(5 Sep 2006 18:15:31)
script for db drop monitoring
(5 Sep 2006 18:14:15)
Profiler for non sysadmin user?
(5 Sep 2006 17:19:26)
Data file set to 10% unrestricted growth is ignored
(5 Sep 2006 16:35:50)
SQL Server Agent
(5 Sep 2006 15:59:55)
seeking clarification on Trace 1024
(5 Sep 2006 15:38:51)
Transaction Log that will not truncate
(5 Sep 2006 15:4:47)
File Handling in sql 2000
(5 Sep 2006 12:31:42)
SQL server 2000 standared edition resource kit
(5 Sep 2006 12:5:30)
Reading Writing to a text /XML file!!!!
(5 Sep 2006 11:49:9)
How Do I Gather Statistics from SQL Jobs?
(5 Sep 2006 11:31:46)
Return next 5 records starting at record 5
(5 Sep 2006 11:18:21)
String Concatenate With Group By
(5 Sep 2006 10:26:32)
Can we create recursive cursor in SQL Server 2000
(5 Sep 2006 10:21:5)
How to monitor CPU usage for a database in the Profiler?
(5 Sep 2006 8:53:30)
pwdcompare. ish.
(4 Sep 2006 17:40:25)
Stored Procedure...
(4 Sep 2006 16:0:21)
speaking of dates
(4 Sep 2006 15:13:14)
dbcc Shrinkdatabase
(4 Sep 2006 10:31:17)
OPENROWSET error...
(4 Sep 2006 6:21:27)
IIS & SQL2005
(1 Sep 2006 21:59:39)
help needed
(1 Sep 2006 20:19:19)
db dELETION NOTIFICATION
(1 Sep 2006 18:12:14)
Backup fast
(1 Sep 2006 15:25:29)
Recover modified data.
(1 Sep 2006 14:10:30)
Load process failing on Log Shipping Database
(1 Sep 2006 14:5:17)
fn_trace_gettable
(1 Sep 2006 14:3:59)
Removing extended SP
(1 Sep 2006 7:19:28)
How to save PerfMon data into a file?
(1 Sep 2006 4:44:53)
SQL Compatibility Level
(1 Sep 2006 1:53:40)
sql lazydba home page