RE: SQL Agent won't start
Did you find anything in the SQL Server logs, or in the Event Viewer -> Applications log? Specifically, looking for something like 'Bypassing recovery for database 'msdb'...marked as Suspect'?
2003-07-28
1 reads
data quality
RE: Scheduling DTS package
what is the package trying to accomplish? I run into similar problem when trying to call a oracle script using sql+ from DTS package. I forgot 'exit' command on the script.
2003-06-21
RE: SQL and XML format
Hi gljjr I understand the basic syntax of how the EXPLICIT mode works, I just want to know if I need to go change my tables to look like a Universal table, or do I need to create a new Universal table Thanx Ruan
2003-06-20
RE: Documentation of Extended Stored Procedures
Thanks all. I have written a script to read from INI files and posted it on this forum. -- Diwakar Cirium
2003-06-18
RE: Documentation of Extended Stored Procedures
DTS can read INI files. You can read something from an INI file into a global variable and then use the global variable in a stored proc call. Look at dynamic properties in the DTS Designer. I believe dynamic properties was introduced in SQL2k.
2003-06-17
RE: Documentation of Extended Stored Procedures
1. A good source for information on some of the "undocumented stuff" is Ken Henderson's book "The Guru's Guide to SQL Server Stored Procedures XML and HTML" (It's a good refernce book anyway) 2. Have you tried xp_readerrorlog ? (This xp can read text files by setting the first paramter to -1) Remember the caveat […]
2003-06-17
RE: Returning a Cursor from a SP
You can create a Temp table (as per your result set) and store the result from cusror into temp table. Select from temp table.
2003-06-16
RE: How to place a record set from a SP to temp table?
What if it returns two or more record sets, like sp_helplogins?
2003-06-10
RE: Need a Set-based way of number rows
Info you are going to use a temp teable, then the Identity() function might help you out. I've used it before and It provides the identity field for the column. try this: SELECT Col1, Col2, IDENTITY(int, 1,1) AS Sort Into #tmpTable FROM MyTable WHERE Col1 = 'SomeCriteria' ORDER BY Col3 select * from #tmptable lowell@stormrage.com
2003-06-09
RE: Syntax of ms_foreachdb?
FOR SQL Server version 6.5 You will need to create a TEMP table as follows and execute sp_MSDBUserProfile proc. Create Table #SQLOLEDbUserProfile (dbid int NOT NULL PRIMARY KEY, profilebits int NOT NULL) Exec Master..sp_MSDBUserProfile 'init' Exec sp_msforeachdb 'Use ? Select db_id(), ''?'' ' For vesrsions 7.0 and greater you can simply exec. the proc as […]
2003-06-06
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