RE: How do you capture the error string in tsql?
Not sure if I understand. Are you searching for the table sysmessages in master? Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-14
deadlocks
RE: how to do a Common Task with stored procedure
ccundy, Here is a link you may find of interest: http://www.algonet.se/~sommar/arrays-in-sql.html He has a couple of functions that convert lists into tables. --Lenard
2003-08-28
RE: Log Shipping and Replication
Backup is happening on time. Copying is happening on time and restore being attempted on time. The copy on several occasions is 0. But then after that it will show copy of 2 files then a restore of 2 files. I've noticed that the updated time in the log shipping pair properties for last backup […]
2003-08-13
2 reads
RE: BackupDirectory
Hi, I found the answer to the question You dim a sqldmo.sqlserver2 and dim a sqldmo.registry2. Only then can you use registry2.backupdirectory. Regards
2003-07-21
1 reads
RE: dts schedule fails
What is the error you are receiving and walk us thru your process. It could be the MDAC but less likely when a manual run is fine. However if the manual run is done from you local machine and not the server where the scheduled run is done then you have to keep in mind […]
2003-07-17
1 reads
RE: Indexing Bit Patterns
Not that I know of. Just index the field as you normally would, hope for the best. Its an interesting technique used for a lot of things, we had to build a similar solution at work, opted to store one row per answer. Trade of course, but its decent to work with. Also, our typical […]
2003-06-30
RE: Administrator of SQL but not of Windows 2000
I use integrated security but believe I'm not administrator of Windows, I can't install a program, register a dll, ecc...
2003-06-26
RE: DTS-export truncates text columns?
I found the answer myself: http://support.microsoft.com/default.aspx?scid=kb;en-us;247527.
2003-06-24
RE: Lost the MDF, have the LDF
ianscarlett, eljeffo never did a full backup, ever. To my knowledge and according to what I've read in the BOL, you can only restore a transaction log to a full backup. -SQLBill
2003-06-23
RE: SQL Server Agent fails to start - no error msg
Hi Csaba, sorry, from now on I can only guess. quote: This is the content of the latest Agent log (from ...\MSSQL\Log dir): 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID […]
2003-06-20
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