MS Sql Server

November 2007

Script to list Server and Database Roles for Selected users
()
File size?
()
Identify SP3 versus SP3A
()
Silly Question
()
ADO Connection to SQL Server
()
Log file not exists
()
Data Structure for category pickers and dependencies
()
moving master DB from one server to another
()
2000 to 2005 upgrade
()
How to reduce log file size and fix to a lower value
()
SQL Server Agent (Agent XPs disabled)
()
DTS Permissions to file denied? (UNCLASSIFIED)
()
data type tinyint?
(29 Nov 2007 22:7:33)
linked server suffers act of god
(29 Nov 2007 21:57:5)
needle in a hay stack
(29 Nov 2007 21:8:3)
Dropping items from replication
(29 Nov 2007 20:43:12)
Unique Table
(29 Nov 2007 20:42:59)
SQL Server 2000 Lock & Memory Configuration (UNCLASSIFIED)
(29 Nov 2007 20:17:2)
Re: datatype tinyint
(29 Nov 2007 19:12:29)
Agent in a pickle
(29 Nov 2007 18:50:55)
SQL Sererv 2005 Client Tools
(29 Nov 2007 15:11:10)
Additional Windows Cluster Node refuses to install SQL 2005 SP2
(29 Nov 2007 14:53:32)
SSIS
(29 Nov 2007 14:32:10)
Merge Replication
(29 Nov 2007 11:35:20)
Urgent help required : Facings DB locking problem in sql server 2000
(28 Nov 2007 23:15:47)
Table Scans
(28 Nov 2007 23:12:53)
Cross-DB DDL Script Generation Tool
(28 Nov 2007 23:9:16)
import the tables , triggers and procedures
(28 Nov 2007 22:14:35)
busey day - profiler question
(28 Nov 2007 20:43:16)
Opinions on Resonate SQLSure for Load Balancing
(28 Nov 2007 20:9:34)
Changing Named Instance to Default Instance SQL2005
(28 Nov 2007 19:52:12)
SQL 2005 Question
(28 Nov 2007 19:27:9)
Allow a user to create, alter, drop any view in 2005
(28 Nov 2007 16:54:49)
Recall: Allow a user to create, alter, drop any view in 2005
(28 Nov 2007 16:53:48)
SQL 2005 SP2
(28 Nov 2007 16:8:58)
Error when trying to run snapshot agent and merge agent using script
(28 Nov 2007 15:15:35)
Connection is broken
(28 Nov 2007 14:53:52)
Comparing databases
(28 Nov 2007 14:21:6)
rsAccess Denied
(28 Nov 2007 13:43:24)
strange error creating a filegroup in 2005
(28 Nov 2007 6:40:0)
maintenance plans failure in sql server 2005
(28 Nov 2007 3:33:55)
VS 2008 install fest
(28 Nov 2007 0:39:0)
Reporting Services
(27 Nov 2007 22:46:29)
Database behaving badly
(27 Nov 2007 20:24:38)
Importing date field from ORACLE
(27 Nov 2007 19:28:36)
problems with variable table in sql 2005
(27 Nov 2007 18:31:37)
SQL Profiler help needed
(27 Nov 2007 16:53:15)
How to Move from 2000 to 2005
(27 Nov 2007 16:0:47)
Batch Counter in SQL Server
(27 Nov 2007 15:49:38)
Some Help would be appreciated
(27 Nov 2007 13:8:50)
All columns with Numeric or Money Type
(27 Nov 2007 12:56:25)
CHAR vs VARCHAR...
(27 Nov 2007 9:4:42)
dbcc shrinkfile question
(27 Nov 2007 8:15:7)
FTP
(27 Nov 2007 1:13:47)
Wait Type Tracewrite
(26 Nov 2007 22:27:34)
Reading File Shares using SQL Server
(26 Nov 2007 22:7:24)
Renaming an field - Help
(26 Nov 2007 20:21:59)
Installing SQL 2005 Client tools to Citrix
(26 Nov 2007 15:23:31)
suspended status
(26 Nov 2007 13:31:11)
Suspnded Status
(26 Nov 2007 13:9:46)
Log shipping question
(26 Nov 2007 12:55:26)
Scheduling Sanpshot Backup
(26 Nov 2007 10:11:3)
OPENROWSET help required
(26 Nov 2007 8:16:41)
LISTOWNER- EMAIL SHIELDING
(24 Nov 2007 14:0:2)
Is there a Batch Counter in SQL Server?
(23 Nov 2007 19:15:34)
Looking for a book suggestion
(23 Nov 2007 17:26:33)
aarrgh moved an ndf file and now i am getting this error, desperate need help please :)
(23 Nov 2007 16:54:43)
HELP!!!!! Huge bottleneck
(23 Nov 2007 14:10:31)
locking problem in trigger
(23 Nov 2007 12:25:12)
Read Text file
(23 Nov 2007 12:17:18)
Deadlock often
(23 Nov 2007 10:31:41)
Problem with DTS package ActiveX scripting
(23 Nov 2007 6:51:36)
Network Card causing high CPU usage
(23 Nov 2007 5:18:2)
Re: SSRS help
(22 Nov 2007 16:7:45)
pairwise query
(22 Nov 2007 12:55:19)
schema under a database tab
(22 Nov 2007 12:9:32)
SQL Server 2000 DTS to SQL2K5 SSIS
(22 Nov 2007 11:57:44)
Problem with DTS package.
(22 Nov 2007 10:29:19)
SQL 2000 Secrity issue
(21 Nov 2007 17:35:52)
page life expectancy/CPU spike
(21 Nov 2007 17:33:30)
Join
(21 Nov 2007 16:52:32)
Executing DBCC commands via Linked server
(21 Nov 2007 15:32:17)
Need to move data from 1 server to another under few scenarios.
(21 Nov 2007 13:58:18)
cluster upgrade
(21 Nov 2007 13:41:53)
Index Tuning Wizard
(21 Nov 2007 12:47:49)
Timeout in Management Console 2005
(21 Nov 2007 12:38:19)
search for keyword accross entire database
(21 Nov 2007 12:36:31)
How to read old transaction
(21 Nov 2007 10:0:1)
Searching on # character in full text indexes - noise character question
(21 Nov 2007 8:51:17)
Studio manager Question - Searching character strings
(21 Nov 2007 1:2:25)
query is compiling but not executing
(20 Nov 2007 22:39:2)
Finding the last occurance of a character
(20 Nov 2007 20:17:46)
Data Update Query
(20 Nov 2007 19:43:38)
output
(20 Nov 2007 18:1:39)
Scripting of SSIS package
(20 Nov 2007 15:17:24)
SSRS 2005
(20 Nov 2007 15:3:2)
Sync'ing logins in 2005
(20 Nov 2007 14:25:34)
Functional Consultant - MCP Developer
(20 Nov 2007 14:5:38)
database create
(20 Nov 2007 13:19:50)
Check the size of a table in
(20 Nov 2007 13:19:49)
reducing an ndf file
(20 Nov 2007 12:53:33)
Trigger Priority problem
(20 Nov 2007 12:50:57)
very lazy dba today - moving table to file group through management console
(20 Nov 2007 12:3:39)
Modification dates of Stored Procedure in MSSQL 2005
(20 Nov 2007 8:55:5)
SQL 2000 Query Analyser is running slow, WHY?
(20 Nov 2007 0:30:37)
How to run schema updates on heavy tables
(20 Nov 2007 0:9:38)
Spec's for Production 2005 or draft for best practices...
(19 Nov 2007 23:8:22)
Create proc without validating
(19 Nov 2007 20:47:20)
Remote access not allowed for Windows NT user activated by SETUSER.
(19 Nov 2007 19:30:18)
Too many rows (top N for each A)
(19 Nov 2007 14:35:10)
Coverting SQL2000 DTS to SQL2005 SSIS
(19 Nov 2007 12:39:8)
Re: query is compiling but within a cursor not executing
(19 Nov 2007 6:35:24)
Re: query is compiling but within a cursot not executing
(19 Nov 2007 6:2:42)
logical Scan Fragmentation & Extent scan Fragmentation
(18 Nov 2007 17:8:2)
UTC date format
(17 Nov 2007 12:46:53)
Execute As QUestion
(16 Nov 2007 22:17:35)
if exists
(16 Nov 2007 20:36:32)
.trc files
(16 Nov 2007 20:24:15)
Lock
(16 Nov 2007 20:4:4)
Performance Expectations
(16 Nov 2007 19:5:36)
Weirdest thing I have ever seen in SQL - can anyone explain
(16 Nov 2007 19:4:10)
Time out error in sqlserver
(16 Nov 2007 18:28:55)
Query
(16 Nov 2007 16:24:28)
XSD to Table
(16 Nov 2007 15:59:18)
Copy Database Structure
(16 Nov 2007 15:55:0)
dependencies ,procedures ,functions ofa column
(16 Nov 2007 10:47:29)
ADO queries
(16 Nov 2007 0:32:29)
connection pooling
(15 Nov 2007 23:42:15)
Assigning an OUTPUT Parameter from a For XML Explicit Select Statement
(15 Nov 2007 22:23:47)
Read-Write Ratios
(15 Nov 2007 22:12:30)
Row Count per table in DB
(15 Nov 2007 21:40:43)
Help Writing a Procedure
(15 Nov 2007 21:0:2)
Rollback
(15 Nov 2007 18:48:12)
Re: Pivot rows of data into one Column (SQL Server 2005)
(15 Nov 2007 18:12:46)
SSIS data flow task error
(15 Nov 2007 16:28:57)
What's the opposite of the Char() function?
(15 Nov 2007 15:16:37)
SQL 2000 DB Changes
(15 Nov 2007 13:39:55)
all data with camel letter like ShIrT Is VeRy NiCe
(15 Nov 2007 9:34:9)
schema design for email database
(15 Nov 2007 4:28:7)
Can I do this?
(14 Nov 2007 23:3:25)
Memory Usage
(14 Nov 2007 21:26:19)
question about triggers
(14 Nov 2007 20:8:7)
web interface
(14 Nov 2007 18:26:18)
row length
(14 Nov 2007 17:43:44)
Replication and Index Tuning Wizard
(14 Nov 2007 16:26:26)
object disappearing from the database
(14 Nov 2007 15:13:57)
Performance problem
(14 Nov 2007 14:27:36)
Date Type (design)
(14 Nov 2007 12:59:58)
Scheme for email database
(14 Nov 2007 11:42:41)
ssis problem
(14 Nov 2007 10:29:38)
Conversion from mssql 2000 to 2005 & Macola
(14 Nov 2007 1:56:57)
sql server reporting services
(13 Nov 2007 19:35:12)
Migrate to SQL 2005
(13 Nov 2007 19:2:13)
Output Results to file
(13 Nov 2007 17:27:56)
import the data from excel file to SQL table
(13 Nov 2007 15:9:56)
SQL And Netbackup Question
(13 Nov 2007 14:55:53)
weird issue
(13 Nov 2007 14:19:58)
SSIS master package configurations
(13 Nov 2007 13:53:39)
Data Warehousing Book
(13 Nov 2007 7:2:54)
log shipping problem
(12 Nov 2007 21:3:55)
NT Authority/ System
(12 Nov 2007 20:13:38)
Ensuring my email is not blocking Lazy dba....
(12 Nov 2007 19:3:41)
avg. disk queue length
(12 Nov 2007 16:7:38)
Autogrow 64000%
(12 Nov 2007 15:27:12)
Transactional Replication
(12 Nov 2007 14:35:12)
Defining Order on Subset in Data
(12 Nov 2007 14:31:46)
doubt
(12 Nov 2007 13:46:58)
SQL Server 2005 timing
(12 Nov 2007 13:38:28)
Tool to compare Stored Procs and Triggers
(12 Nov 2007 6:19:22)
Workday Selection
(12 Nov 2007 0:16:58)
Log Shipping solutions in SQL 2000 Standard Edition
(9 Nov 2007 23:14:2)
Thoughs on Red-Gate's SQL Backup?
(9 Nov 2007 20:34:4)
Dedicated server for distribution
(9 Nov 2007 20:20:21)
SSIS Connections using Environment Variables or XML files
(9 Nov 2007 18:2:42)
Logins Question...
(9 Nov 2007 17:44:21)
smo script
(9 Nov 2007 14:17:31)
Anyone use BizTalk?
(9 Nov 2007 13:59:37)
Remapping users
(9 Nov 2007 2:7:50)
drop all tables for specific owner
(9 Nov 2007 0:45:12)
update across linked servers
(9 Nov 2007 0:7:6)
Temp Table Question...
(8 Nov 2007 22:33:14)
Multiple tables in DTSWizard?
(8 Nov 2007 21:52:31)
RAM question
(8 Nov 2007 21:28:23)
Please help.. Stored Proc won't create
(8 Nov 2007 20:4:44)
Log file.
(8 Nov 2007 17:2:3)
Installation of SQL server 64bit
(8 Nov 2007 15:55:6)
SQL Server SA Account
(8 Nov 2007 15:42:49)
Migrate to Oracle(need your help urgent..)
(8 Nov 2007 15:24:28)
encrypted stored procedure
(8 Nov 2007 14:14:43)
Replication and Indexes
(8 Nov 2007 12:29:18)
Difference in the syntax in Oracle 9i and Oracle 10g.
(8 Nov 2007 10:32:50)
Removing first 4 characters in a column
(8 Nov 2007 7:13:32)
Foxpro database
(7 Nov 2007 22:43:28)
Using SSIS to connect to ORACLE
(7 Nov 2007 21:16:48)
Connectivity Issue SQL 2005
(7 Nov 2007 20:46:21)
Ok I give up
(7 Nov 2007 20:27:40)
Login information in sql table
(7 Nov 2007 17:24:32)
SA username.
(7 Nov 2007 16:58:12)
Replication Question
(7 Nov 2007 16:28:3)
DTS package is failing midstream during the execution
(7 Nov 2007 16:12:51)
Collation and Union woes
(7 Nov 2007 16:10:10)
Adding columns
(7 Nov 2007 15:37:35)
New Server for SQL Reporting Services will be my downfall (UNCLASSIFIED)
(7 Nov 2007 15:7:37)
Corrupt Log File - Database suspect
(7 Nov 2007 14:44:37)
Reports Running Slow
(7 Nov 2007 13:55:36)
Silly Question time
(7 Nov 2007 13:23:11)
Maintenance Plans
(7 Nov 2007 12:59:0)
Convert Oracle dmp to SQL 2005
(7 Nov 2007 0:30:27)
Turn off Logging to the Job History Log for a specific Job
(6 Nov 2007 22:26:3)
Tranlog backup hung - thoughts?
(6 Nov 2007 21:25:18)
Import XML file into SQL Table
(6 Nov 2007 20:22:59)
sql 2005/disk mirroring
(6 Nov 2007 19:42:54)
SQL Server (List Column Names)
(6 Nov 2007 19:37:2)
remote procedure execute error
(6 Nov 2007 19:0:42)
Create job to alert users (UNCLASSIFIED)
(6 Nov 2007 18:8:29)
HELP! Possible corrupt db
(6 Nov 2007 17:46:14)
SQL Agent Job Fails when Scheduled
(6 Nov 2007 17:11:57)
Transaction Log continues to grow
(6 Nov 2007 16:41:48)
Locks?
(6 Nov 2007 16:41:47)
Oracle reference
(6 Nov 2007 14:1:18)
DTS/IIS
(6 Nov 2007 13:28:23)
listing users, access etc
(6 Nov 2007 13:12:1)
Count by category Query
(6 Nov 2007 13:11:18)
Collation
(6 Nov 2007 13:1:7)
Interchange the Rows with Columns in Select query of Sql Server 2000, Oracle
(6 Nov 2007 12:54:13)
Query Transaction Log????
(6 Nov 2007 11:58:58)
comparison of multiple-column primary keys
(6 Nov 2007 11:57:46)
XML
(6 Nov 2007 5:19:40)
Table Locking schema
(5 Nov 2007 23:18:17)
two linked server spoofs....
(5 Nov 2007 22:28:42)
DAVCatalog
(5 Nov 2007 21:47:51)
Temp DB error
(5 Nov 2007 20:58:49)
Sql Server 2000 without documentation!
(5 Nov 2007 20:54:0)
Actual Table Size
(5 Nov 2007 20:47:40)
Querying Transaction Logs????
(5 Nov 2007 20:47:27)
SQL 2005 Error!
(5 Nov 2007 20:6:20)
Help in how to retreive images in a column
(5 Nov 2007 15:53:13)
DTS Packages
(5 Nov 2007 15:26:25)
updating all the jobs owners on a server
(5 Nov 2007 14:40:15)
Database monitoring
(5 Nov 2007 14:1:25)
Selecting and inserting data into several linked servers
(5 Nov 2007 13:37:39)
Big Brother Script needed for SQL Logins...
(5 Nov 2007 12:53:17)
Transferring logins and password to new server
(5 Nov 2007 12:30:41)
2005 TLog backup
(5 Nov 2007 12:21:56)
working out the data size of a row in a table
(5 Nov 2007 8:50:29)
Simple Grant question?
(4 Nov 2007 4:3:2)
How to script a DTS package?
(3 Nov 2007 0:0:29)
"Autogrow of file 'tempdb_log' in database 'tempdb' cancelled or timed out after 0 ms."
(2 Nov 2007 23:24:7)
SSIS Permissions
(2 Nov 2007 23:19:26)
T-SQL Select query issue table provided
(2 Nov 2007 16:0:12)
xp_sqlmaint help
(2 Nov 2007 15:14:28)
script help
(2 Nov 2007 15:8:32)
Sql Log File
(2 Nov 2007 15:2:44)
Creation of db_denyddladmin role
(2 Nov 2007 14:23:43)
Can i call a job into another job
(2 Nov 2007 12:30:58)
How to restore the database?using SQL SERVER 2000
(2 Nov 2007 10:59:2)
A transport-level error has occurred when receiving results from the server
(2 Nov 2007 10:52:40)
Mirroring
(2 Nov 2007 10:37:16)
MRS Question
(2 Nov 2007 9:8:12)
Backup History.
(2 Nov 2007 6:10:28)
I need a script to find longest running transaction
(2 Nov 2007 6:8:58)
Script for First and last date of current month??
(1 Nov 2007 19:22:41)
Creating an automated sequence of jobs
(1 Nov 2007 18:36:14)
Linked Server Objects question
(1 Nov 2007 18:34:42)
Number of traces running
(1 Nov 2007 18:0:48)
Fields List
(1 Nov 2007 17:13:2)
Re: Cursor like function
(1 Nov 2007 16:55:14)
Trying to set up Mirroring
(1 Nov 2007 16:24:56)
please help ; transport-level error
(1 Nov 2007 15:24:38)
The INSERT statement contains fewer items than the insert list.
(1 Nov 2007 14:24:18)
Dataset Error
(1 Nov 2007 13:51:7)
Extract numeric data
(1 Nov 2007 12:50:37)
Linked Servers Etc
(1 Nov 2007 11:2:17)
Re: Get a Free Training CD -- new titles, no purchase necessary
(1 Nov 2007 10:43:17)
Text data type
(1 Nov 2007 10:23:37)
Profiler
(1 Nov 2007 9:31:36)
sql lazydba home page