Tag Archives: sql server 2005
Here’s an interesting approach for creating a quick and dirty schema to get you started with XML. DECLARE @schema xml SET @schema = (SELECT * FROM schema.TABLE FOR XML AUTO, ELEMENTS, XMLSCHEMA(’SchemaName’)) SELECT @schema I don’t have the source, but … Continue reading
Inside source control, I have scripts arranged as follows: Drive:/Base/Database/ Drive:/Base/Database/Functions Drive:/Base/Database/Proc Drive:/Base/Database/Tables Etc.. Each script stored can be run multiple times with no ill effect. For example, a table generation script first checks to see that it exists before … Continue reading
Recently we had a database issue, that necessitated us moving logins. Here’s an article I used from Microsoft to help script the logins. The KB is specifically for 2005 -> 2008, but it will also get you login’s out of … Continue reading
A recent post on sqlservercentral.com got me thinking about Hashbytes recently. I was ignoring the issue of getting a false positive using a hashbyte solution to check for errors, and focused on the performance of the routine. My initial pass … Continue reading
It seems that Windows Server 2008 and/or SQL Server 2005 doesn’t automatically add a firewall exception to the OS for access to the database. As a result, an exception needs to be added, by following instructions found here.
SELECT DATEADD( mm, DATEDIFF( mm, 0, GETDATE() ), 0 ) AS FirstOfMonth Since I always manage to get the syntax wrong from memory, above is a SELECT statement that will return the first day of the current month. Edit: As … Continue reading