RE: Looking for a graphical Job history analysis tool
Have a look at SQL Sentry also. For job management and history, that one is hard to beat. The Idera stuff is looking good also though, so can't hurt to look at multiple solutions.
2005-04-05
Python
RE: Need SQL to render parms for PK & FK DDL gen
Foreign keys : SELECT TOP 100 PERCENT PTbl.name AS PkTableName, PCol.name AS PkColName, FTbl.name AS ConstraintName, dbo.sysobjects.name AS FkTableName, FCol.name AS FkColName FROM dbo.sysobjects INNER JOIN dbo.syscolumns FCol INNER JOIN dbo.sysobjects FTbl INNER JOIN dbo.sysforeignkeys FKS ON FTbl.id = FKS.constid INNER JOIN dbo.syscolumns PCol ON FKS.rkeyid = PCol.id AND FKS.rkey = PCol.colid INNER JOIN dbo.sysobjects […]
2005-03-31
RE: Cannot connect to SQL server using DOMAIN network
Please, first make sure that what Mike said is done.I would say it does not look as permission problem from the error message. The error mesasaage looks like that instance could not be found and I always have this message with firewall problems, no matter who started the SQL services. It was only 2 cases where access was […]
2005-03-31
RE: Query problem
Delete from dbo.Quick2 Q where exists (Select * from dbo.tmt2 T where Q.num = T.Num) Select * from dbo.Quick2
2005-03-31
RE: How to change security back to SQL
Hi,Read thishttp://www.microsoft.com/sql/techinfo/tips/administration/May3.aspand change this:In SQL Server 7.0, the key is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode In SQL Server 2000, the key is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft MicrosoftSQLServer\<instance_name>\MSSQLServer\LoginMode The value of LoginMode is 1 for Windows Authentication only, and 2 for Mixed Mode. After locking yourself out, you can change the value of LoginMode to 2, restart SQL Server, and log in […]
2005-03-31
RE: How do I delete the corresponding row?
Paula this is a little off the subject and perhaps I should start another thread but just a quick question on your statement "As a rule we do not use cascading deletes as we leave it up to the programmers to decide" I agree that using cascading deletes should not be used in all cases but when […]
2005-03-31
RE: How do I delete the corresponding row?
PaulaI think you can re arrange your SP to produce a temp table with records marked to delete, instead of deleting them directly (changinf DELETE... for a INSERT INTO #TempTable SELECT...)Once you have this temp table, you can delete depending records in any other table simply using a join... after that, you delete main records, […]
2005-03-31
RE: Need a few links on using ASP to import/export documents.
Thanks Frank,I did the google thing yesturday (forget my exact clause but it was similar) and I was just returning garbage as far as usefull sites.
2005-03-24
2005-03-22
RE: Deploying DTS packages from different environments
Hi I need to dts an excel. Depending on where the excelfile is stored, this excel is must be dts'ed within the same database. So eg Folder :Track, file : verdeling.xls, it should dts'ed into database : track.I am using software that is called automate. This is a service, triggering the file. When the file […]
2005-03-18
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers