It sounds like you might want this more automated, but if this is for occasional use you can script out all the functions by right clicking on the DB name in EM | All Tasks | Generate SQL Script |Show all |check the box for All User Defined Functions. Then click the Options tab and check Script […]
2005-02-10
Ok thanks again. It looks like my work hours come to end. Tomorrow I'll try to reconfigure MS DTC. Friendly speaking I don't understand why MSDTC needs separate IP address, but if it want it, it will get oneThank you for your help. It looks like you are my personal adviser. I'm very grateful to you
2005-02-10
Cody,My setup is almost identical to yours, and I get no results either. Just one row with the value NULL. (I think blank lines get returned as NULL when using xp_cmdshell, based on testing with the DIR command). I originally was using SETSPN.EXE version 5.00.2184.1, but downloaded the newest version, 5.2.3630.0. Didn't make any difference. […]
2005-02-09
2005-02-07
it seems thats what is happening. I put the other stored procs in the DTS package to run in order. maybe that will work?!??!!
2005-02-07
Hello guys,i have a problem with this statement:USE SQLDoku DECLARE servername_cursor CURSOR FOR SELECT SRVNAME FROM master.dbo.sysservers OPEN servername_cursor DECLARE @servername varchar(30) --SET @servername = 'authors' FETCH NEXT FROM servername_cursor INTO @servername WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN --Print @servername --SELECT @servername = RTRIM(@servername) […]
2005-02-07
1 reads
Hi, When processes are using the database you cannot restore a backup of it, it is not the same as the backup functionality where you can create backups during working times. Best thing is to ask everything to exit the application. Philippe
2005-02-07
You can also do it this way... FROM dbo.OccMain ocm INNER JOIN dbo.OccMalignant omg ON( ocm.AilmentID = omg.AilmentID) LEFT JOIN dbo.CodeLookUp c ON( c.Code=omg.SentNode AND c.CType = 65)
2005-02-07
Hi all, We are using SQL Server 2000 to run our application for companies across Europe. Users input Dutch, French and English language. Now our company bought a russian company for who the users also need to work in the same database. I searched through the internet and as I found out we need to […]
2005-02-07
1 reads
Who's next....?Not me! ... no sign of collicks yet. Don't know the words in english ...If it is what I think you mean then it is colic (trapped wind). Wind is the gas expelled (either end). And that warm sticky feeling down your back when it's not wind, well ....
2005-02-04
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers