I am backing up from one server to another server across the network. This has been working for months. Then on Monday night netweork backups began failing with an error like this:Processed 829088 pages for database 'molert', file 'molert_data_1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 959 pages for database 'molert', file 'molert_log_1' on […]
2004-08-18
50 reads
Hi I am Wrting a StoredProcedure ,But i use this stored procedures output into a temp table for using this output into another Storedprocedure,
2004-08-18
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-08-16
Hi EverybodyI hope there is somebody out there who can help me. I am trying to setup notification on MS SQL Server 2000-8.00.760 (Intel x86). Enterprise Edition on Windows NT5.0 (Build 2195:Serice PAck 4).I have setup a mail profile using Internet mail server (POP3/SMTP). The client on the SQL server is Outlook 2000. Our e-mail […]
2004-08-13
44 reads
Hi, I have a situation where I need to calculate some of the Time Differences based on the Timezoneinfo in the registryI tried using the following after browsing few sites, however the return value is not in readable format and may not be of any help for meDECLARE @v varbinary(4000) EXEC master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Windows […]
2004-08-06
7 reads
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
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
Here is a quick and easy question (I hope) for you experts. Can you delete the "master" database?I'm doing some CYA for myself. I was deleting a bunch of spurious databases using the Enterprise Manager on a development box when it became corrupted - no connections, nothing. The application programmer says "I corrupted the the […]
2004-06-15
3 reads
What versions of SQL are you running on the box and have you installed alternate client tools at any point. Also, is this a domain account or local account and does it have full admin rights to the local machine?
2004-03-22
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
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers