RE: Controlling Unusually Long Running Jobs
Will do it. It become interesting.I am in class for 3 days. But then I will make some experiments and let you know. Thanks for the remark. Sorry for the error (if it is)
2005-05-09
PerfMon
RE: Stored procedures permissions
At the DB level you can use sp_helprotect. Therefore, if you automate the tying of login to user, you should be able to script something to go through each database and report back.
2005-01-11
RE: Database Implementation Question
For the purpose of comparison you DON'T NEED anything to grab the mdf files !!!!
2004-02-12
RE: Problem deleting rows on subscriber in transactional replication
If rows do not match between Publisher and Subscriber then the Subscribers are most likely out of sync!Lets start from the beginning.(A) Did this error occur immediately after installing and configuring replication?(B) Were the subscribers dropped from the publication at any time? If so then thats most likely why they are out of sync!(C) how […]
2004-02-08
RE: Distributed Query Error
I am running the code in QA currently but if it works i will place it in an SP.
2004-01-07
2 reads
RE: DTS Numbers export to Excel ends up as text
I posted this under another Excel question and it works pretty slick. You can apply formatting (Inserting rows, Titles, formatting to the detail, etc) to the excel file and it will be maintained even after the excel table is dropped and recreated. ================================================================ Use an Execute SQL task against the Excel connection: DROP TABLE table_name […]
2003-12-01
1 reads
RE: SQL server 7 on windows 2000
Do you mean Windows 2000 Professional or Server? My understanding is that it can't run on 2000 Professional. Edited by - amackay_1 on 11/18/2003 08:09:52 AM
2003-11-18
1 reads
RE: Single User Bug????
quote: ...Is there any possibility that DBCC is trying to fix some minor errors, and SQL Server changing to Single User Mode & not changing it back?! Just a Thought.... That is EXACTLY what is happening. When you check "Attempt to repair minor problems" under the Integrity tab, the maint plan job will try to […]
2003-07-30
RE: many login and logout
I guess that the connection is used vb is not correct . please answer the reason of this problem. hjg
2003-07-24
2 reads
RE: Do you think education matters?
Firing sometimes happens. One of the times the person who recommended her came to me and said that it wasn't working. It's always a risk. You just try and make sure the house wins (if you are the house). Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-06-26
1 reads
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