Hi guys, I have created a script of User-Defined-Function to extract the calulated time from two given datetime inputs. But you have to pass THREE parameters like :-a)Start Datetimeb)End Datetimec)To display the format either in HH:MM:SS or HH.MM , we use 'T'(HH:MM:SS) OR 'N'(HH.MM). Please feel FREE to E-mail me at […]
2004-01-14
160 reads
this script simply returns list of all triggers and their dependant tables in current database.Ex:Select * from rk_vAlltriggers
2004-01-08
265 reads
This script will generate a stored procedure named procCreateXSD. Run this script to create the SP.The purpose of this SP is to generate the XSD from selected tables we passed to the script. It accepts the Dataset name, URI, and the list of the tables to be included.For example:exec proccreateXSD 'NorthwindDataset', 'http://www.tempuri.org/', 'Customers,Orders,Products'Be aware that […]
2004-01-08
415 reads
Script lists all overlapping jobs that ran on selected server within last @Hoursback hours.Basically, idea behind this is to find jobs that are running at the same time, because that might significantly slow down server, especially if you have jobs that are running during business hours. You can do the same by looking into Jobs […]
2004-01-02
1,284 reads
Based on moffan76's script to GRANT EXEC to all sprocs and UDFs (that EXEC) and GRANT SELECT to views and UDFs (that SELECT). This script uses that same general technique of selecting the object names from sysobjects, but does it in one step w/o using a cursor. It is also not wrapped in a sproc […]
2003-12-30
229 reads
Monthly SQL Server Agent Jobs report Script Monthly SQL Server Agent Jobs report. It will give a summarized picture of SQL Agent jobs run during a calendar month. You can use it to file up reports for system audit. It does not handle jobs that are run more than […]
2003-12-30
1,444 reads
This Script takes a user name and set execute permissions on SPs and UDFs.
2003-12-28
317 reads
Simple Procedure to rapidly rebuild a copy of Development TEST1 DB...Lovely and fast when Tard Developers have highlevels of access and you just need them out to restore / refresh a db...KILL KILL KILL !!! Remember to reset / resolve users and permissions after this is run. I use a DTS RUN statment with a […]
2003-12-18
201 reads
T-SQL String Function: Returns passed date formatted using passed criteria. Format criteria similar to Visual Basic. Sorry, prior script had a reference to one of my internal UDFs :(.
2003-12-17
248 reads
This procedure queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules(if applicable),how often the interval occurs(every X hours,min.,days,etc), the maximun duration, last duration,last status of the job.This is a script that I modified and added to from M.Pearson.
2003-12-16
421 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers