2004-08-26
analytics
qurey hangs with distributed transactions
If I write an insert directly to a linked server then it works. If I do exactly the same via a distributed transaction it hangs. The syntax is 100% correct including the xact_abort on I'm using sql2000 sp2 with a domain service account. I can't believe the answer is upgrade to sp3a. Any suggestions gratefully received.
2004-07-29
2 reads
RE: Permissions in sql server 2000 (URGENT)
HI robbac, yes, Users are under NT group.AppDev How use ddl_admin to create/alter/execute procedure/functions and not to create /alter table/constraints/indexes.Thanks,Sheilesh
2004-07-26
RE: Cursor declaration.....
In effect they are the same as you stated. However you will never have a situation where you mistakenly forget to put "Local" on your declaration and end up with a global cursor and all of a sudden have a problem like Lars did above. I also find it easier to read the syntax as […]
2004-05-17
RE: Error with Oracle linked server & Date
Oracle can use casts to convert dates as well.oracle doesn't have a datatype called datetime. OpenQuery is executed as a passthru query on the remote server. Thats why you are receiving a ora- error. Try removing the cast specification.
2004-02-27
RE: how to find sa password from registry in sql 2000/7.0/6.5 if i forget the sa password?
For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.THe SA will be on the right of the screen vertically.Don't tell anyone this came from me - And I never use it because I never, ever forget my SA password as they are stuck on my screen with […]
2004-01-16
8 reads
Where is the Discussion content... area?
Hi there,on the forums home page I saw Last post made in Discuss content..., but I can't seem to find it on the Active topics page.
2004-01-09
1 reads
RE: help selecting sums from two similar tables
You can use a derived table like this Select Sum(T0.Docamnt)+T1.Docamnt_Sum As Total_Sum, T1.Docamnt_Month As Unique_Month From Table1 T0, (Select Sum(Docamnt) As Docamnt_Sum, -- Derived Table starts here DatePart(mm, Date) As Docamnt_Month From Table2 Group By DatePart(mm, Date)) As T1 -- Derived Table ends here Where DatePart(mm, T0.Date) = T1.Docamnt_Month Group By T1.Docamnt_Sum, T1.Docamnt_Month MW
2003-06-18
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