RE: marked SUSPECT by recovery
I think you have to take the Database out of suspect using sp_resetstatus [ @DBName = ] 'database' and then run dbcc's
2003-07-09
1 reads
Analysis Services (SSAS)
2003-07-08
1 reads
RE: vanishing databases and servers
is it possible to reconfigure SQL server to work disconnected from the network I am using ASP & IIS 5.0 to generate web pages with data from SQL Server and i want to be able to view them on the same machine as i am developing at home.
2003-07-08
RE: Starting trouble
One curious error we are getting in the procedure 3,its in an insert statement which is includes a select statement date time out of range. The interesting thing is there is only one date filed in the table and the corresponding field in the select also belongs to same type ! . As per the […]
2003-07-08
2003-07-08
RE: SQL Profiler Trace
What about running the trace on the server, storing the results in a table and querying the results from the client using Excel or Access ? Then you only need MDAC loaded on the client and not Profiler. Check out this article for more information on how to run the trace on the server:
2003-07-07
RE: setting parameters in steps
Try wrapping your query in your Execute SQL Task in a stored procedure and then pass in the parameter...this should work fine using the EXEC usp_mysproc ? syntax... hth, Michael Michael Weiss
2003-07-07
1 reads
RE: ADO Code
Mine was a serious answer. I have found, via this forum, that I do too much by assumption and default which can lead to inefficiency. All I was trying to point out is that in the case of the use of 'Server.', if the server has to do extra processing because 'Server.' is not specified […]
2003-07-07
RE: ADO Code
Hi David, quote: Yes, laziness on my part. If you leave off 'Server.' it is assumed (bad practice ). it was a serious question. I am a lazy coder, too! Cheers, Frank
2003-07-07
RE: ADO Code
Hi Frank, Yes, laziness on my part. If you leave off 'Server.' it is assumed (bad practice ). I know ASSuME makes an ASS of you and ME and Assumption is the mother of all F*** ups. p.s. This is server side scripting. Edited by - davidburrows on 07/07/2003 06:29:03 AM
2003-07-07
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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