2003-07-23
1 reads
StreamInsight
RE: SQL Newie needs help
Hi Jigman, quote: 'Transaction cannot start while in firehose mode' One of our developers had this when updating a table in EM The only thing I could find in BOL relating to this was... quote: The client cannot send any other Transact-SQL statements on that connection until the application has either processed all the rows […]
2003-07-23
RE: Deleting subscription
The only way is to delete the sp sp_dropsubscription on the publisher in the published db. So, you coud execute the sp remotely from the subscribers, if you have the publisher setted up as a linked server from the subscriber
2003-07-17
RE: dts schedule fails
That is part of the problem, there is no error message. It just hangs on step one. Like I said earlier, it runs manually but not on schedule and there is no error message. Thanks again M
2003-07-17
2 reads
RE: DTS Scheduled Job Failed
I have a bunch of DTS packages running nightly from SQL Agent that work fine but I have had problems in the past. Some problems I have had have been: 1. The DTS run command uses the DTS package GUID to find out which DTS package to run. If you make a change to a […]
2003-07-17
RE: Proper Shutdown of SQL Servers in a Cluster
quote: Can you share an example of that script and does it run from sql server agent? I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to […]
2003-07-16
RE: Proper Shutdown of SQL Servers in a Cluster
I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to bounce between the two. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance […]
2003-07-14
1 reads
RE: Preventing MSAccess Connections
Using an approle from Access is just like any other app, you call the proc (setapprole?) and then you're authorized. But that works to let people in, not keep people out. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-14
RE: write conflict
quote: Hi alicejwz, from what you have sent me off-forum, could it be you have a bit field in one of your tables without a default value? That's working in Access, but not in SQL Server. Cheers, Frank It is possible to store NULL in bit field in SQL2000, but Access doesn't like that, and […]
2003-07-10
RE: Column name lookup
Ok, but what I need is to be able to join the result for each column with it's column name. So each row would have the column name and the column value. How could this be done?
2003-07-09
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