Jon Galloway - All Comments

re: [Util] Open PLS Playlist in Windows Media Player

dbxdv — Sat, 19 Jul 2008 18:05:52 GMT

this is soo HACKS!

re: [T-SQL] Drop all constraints on a table

Adam Turner — Sat, 19 Jul 2008 17:02:48 GMT

Sorry didn't realize it didn't work with FK constraints...so here's the full code that will drop FK constraints and the tables and make sure you're not running on the production server:

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

ALTER PROCEDURE usp_ClearConstraints

@DatabaseName varchar(50)

IF @@ServerName <> 'YourProductionServer'

BEGIN

DECLARE @TableName NVARCHAR(50)

DECLARE @ConstraintName NVARCHAR(50)

DECLARE Constraints CURSOR FOR

SELECT TABLE_NAME, CONSTRAINT_NAME

FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE u

JOIN SYSOBJECTS s

ON u.TABLE_NAME = s.Name

WHERE TABLE_CATALOG = @DatabaseName

AND s.xType = 'U'

ORDER BY u.Constraint_Name --Get FK constraints first

OPEN Constraints

FETCH NEXT FROM Constraints INTO @TableName, @ConstraintName

WHILE @@FETCH_STATUS = 0

BEGIN

IF LEFT(@ConstraintName, 2) = 'FK'

BEGIN

DECLARE @FKTableName as varchar(50)

DECLARE @FKName as varchar(50)

SET @FKName = (SELECT TABLE_CATALOG FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_CATALOG = @TableName)

SET @FKTableName = (SELECT object_name(fkeyid) from sysreferences where object_name(constid) = @FKName)

EXEC('USE ' + @DatabaseName + ' ALTER TABLE [' + @TableName + '] DROP CONSTRAINT [' + @ConstraintName + ']')

FETCH NEXT FROM Constraints INTO @TableName, @ConstraintName

END

ELSE --Else if there are no foreign key constraints on the table

BEGIN

EXEC('USE ' + @DatabaseName + ' ALTER TABLE [' + @TableName + '] DROP CONSTRAINT [' + @ConstraintName + ']')

FETCH NEXT FROM Constraints INTO @TableName, @ConstraintName

END

CLOSE Constraints

DEALLOCATE Constraints

DECLARE Tables CURSOR FOR

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES u

JOIN SYSOBJECTS s

ON u.TABLE_NAME = s.Name

WHERE TABLE_CATALOG = @DatabaseName

AND s.xType = 'U'

OPEN Tables

FETCH NEXT FROM Tables INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC('USE ' + @DatabaseName + ' DROP TABLE [' + @TableName + ']')

FETCH NEXT FROM Tables INTO @TableName

END

CLOSE Tables

DEALLOCATE Tables

END

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS ON

re: [T-SQL] Drop all constraints on a table

Adam Turner — Sat, 19 Jul 2008 16:01:18 GMT

Here's some code that will go a step further and drop the tables as well as check to be sure you're not on the production server"

CREATE PROCEDURE usp_ClearConstraints

@DatabaseName varchar(50)

IF @@ServerName <> 'YourProductionServerName'

BEGIN

DECLARE @TableName NVARCHAR(50)

DECLARE @ConstraintName NVARCHAR(50)

DECLARE Constraints CURSOR FOR

SELECT TABLE_NAME, CONSTRAINT_NAME

FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE u

JOIN SYSOBJECTS s

ON u.TABLE_NAME = s.Name

WHERE TABLE_CATALOG = @DatabaseName

AND s.xType = 'U'

OPEN Constraints

FETCH NEXT FROM Constraints INTO @TableName, @ConstraintName

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC('USE ' + @DatabaseName + ' ALTER TABLE [' + @TableName + '] DROP CONSTRAINT [' + @ConstraintName + ']')

FETCH NEXT FROM Constraints INTO @TableName, @ConstraintName

END

CLOSE Constraints

DEALLOCATE Constraints

DECLARE Tables CURSOR FOR

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES u

JOIN SYSOBJECTS s

ON u.TABLE_NAME = s.Name

WHERE TABLE_CATALOG = @DatabaseName

AND s.xType = 'U'

OPEN Tables

FETCH NEXT FROM Tables INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC('USE ' + @DatabaseName + ' DROP TABLE [' + @TableName + ']')

FETCH NEXT FROM Tables INTO @TableName

END

CLOSE Tables

DEALLOCATE Tables

END

Zolpidem.

Zolpidem. — Sat, 19 Jul 2008 13:31:30 GMT

Zolpidem online. Cheapest zolpidem. Zolpidem eszopiclone indications. Zolpidem.

how to match data from excel to access - Learn Excel - Learn Excel - Learn Excel

how to match data from excel to access - Learn Excel - Learn Excel - Learn Excel — Sat, 19 Jul 2008 11:31:47 GMT

Pingback from how to match data from excel to access - Learn Excel - Learn Excel - Learn Excel

vector graphics software

vector graphics software — Fri, 18 Jul 2008 18:48:41 GMT

Pingback from vector graphics software

re: //TODONT: Use a Windows Service just to run a scheduled process

Aid — Fri, 18 Jul 2008 15:06:30 GMT

Sorry,got it wrong. Don't have VB on my laptop and read source in notepad.

re: [Util] Open PLS Playlist in Windows Media Player

Nick — Fri, 18 Jul 2008 14:22:14 GMT

When I go to the place you specify in your link and try to get the programme, I get the following:

A critical error has occurred.

Could not find file 'D:\Websites\tools.veloc-it.com\Portals\2\Repository\OpenPlsInWmp2Setup.45a14f27-82ff-4ef9-9b6e-3a29d3d34c26.zip'.

regards: Nick

re: //TODONT: Use a Windows Service just to run a scheduled process

Aid — Fri, 18 Jul 2008 14:04:03 GMT

Hi,

I'm currently looking at converting a piece of software from VB6 that transfers a CSV file to a database every 15 mins. I came across this www.codeproject.com/.../SQLAgent.aspx

It uses a windows service that wraps the scheduler. I'm actually using the software to backup a database and it works well so far. I was looking at services so I can run the app under localsystem account without anyone logged in.

I'm a bit confused about wrapping the scheduler inside a service and was looking for some other thoughts.

Thanks

re: [Util] Open PLS Playlist in Windows Media Player

Nick — Fri, 18 Jul 2008 09:12:53 GMT

When I try to download your compiled proramme I get this:

A critical error has occurred.

Could not find file 'D:\Websites\tools.veloc-it.com\Portals\2\Repository\OpenPlsInWmp2Setup.45a14f27-82ff-4ef9-9b6e-3a29d3d34c26.zip'.