|
XLeratorDB/util ensures your purchased XLeratorDB products will install successfully on your database!
Use XLeratorDB/util's TestServer function to make sure that your registered server name, which you specify during checkout, is correct.
Also, use XLeratorDB/util to simplify common tasks such as checking for existence of a table, view, database, user, etc., which is commonly done in sql installation scripts to drop a particular object before re-creating it.
Turn this:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[mytable]') AND type in (N'U'))
DROP TABLE [dbo].[mytable]
IF (wct.TableExists('dbo','myTable') <> 0) DROP TABLE dbo.myTable
XLeratorDB functions utilize SQLCLR technology and work like any other user-defined function.
XLeratorDB/util installs in minutes and is available for use immediately.
Download a copy for FREE today.
List Of SQL Server Utility Functions:
ApplicationRoleExists
|
Test for existence of an application role
|
AssemblyExists
|
Test for existence of a SQL CLR assembly
|
DatabaseExists
|
Test for existence of a database
|
DatabaseRoleExists
|
Test for existence of a database role
|
FunctionExists
|
Test for existence of a SQL CLR function
|
SchemaExists
|
Test for existence of a schema
|
StoredProcedureExists
|
Test for existence of a Stored Procedure
|
TableExists
|
Test for existence of a table
|
TestServer
|
Test configured server name
|
UserExists
|
Test for existence of a user account
|
ViewExists
|
Test for existence of a view
|
|