Viewing 6 posts - 1 through 6 (of 6 total)
I get [NULL] in 'DataBaseName' column
SQL:[2005]
Otherwise v.useful.tool
August 7, 2008 at 3:25 am
thnx for the script, I work for a v.large (global) plc. tradionally IT-NETWORK staff are DBA's, us Software SQL Developers have to beg.4.any.rights**
I have just proved that we are NOT...
July 31, 2008 at 1:42 am
thnx for the information
Has any one got a script that will show status of all database.indices Statistics settings including last update.date, so that I can identify incorrect settings and days...
July 30, 2008 at 3:14 am
Look at: GeckoWare SQL Scribe for Microsoft SQL Server.
www.ag-software.com
Main non-standard use is Comparing DB Versions [Tables/SP/Function/Views...]
Upgrade are supplied...
July 28, 2008 at 9:03 am
on area where I have been back to #table is after CTE
eg
;WITH cte_OldTraders (TRID, LastSOdate)
AS (
SELECT traderid, MAX(orderdate)
FROM salesorders
WHERE status != N'CANCELLED'
GROUP BY...
July 17, 2008 at 7:28 am
remember you can use tempdb as a nearly normal database**
I create Structure for XML explict table and error_log table in tempdb and JOB-Agent bcp's these to files.xml
Their STRUCTURES/Programmes are copied...
July 17, 2008 at 5:13 am
Viewing 6 posts - 1 through 6 (of 6 total)