The query processor ran out of STACK SPACE
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-10-18
json
Hanging application mmc.exe ...
Error going into Windows Application Event Log: Hanging application mmc.exe, version 5.2.3790.0, hang module hungapp, version 0.0.0.0, hang address 0x0000000.Any ideas?Can anyone help get this rock off me Thanks...comming to you as one of the few employeed in ohio
2004-10-11
425 reads
RE: restoring a backupdevice on another machine
Solution:First check if the backupdevice exists on the machine (which it shouldn't, because the restore is taking place on a machine other than the one that the backup was done on.)oBackupDeviceCheck = CreateObject("sqldmo.BackupDevice") For Each oBackupDeviceCheck In oServer.BackupDevices If oBackupDeviceCheck.Name = BackupFileName Then blnBackupDeviceExists = True Exit For End If Next […]
2004-10-08
RE: Backup Coming From Secret Location
I've run into issues before where even if a job is deleted it remains in cache and still runs. I ran into a dba who told me a story that every night they would get a page and a e-mail about a job failing but they also could not find that job anywhere. Once they […]
2004-09-22
2004-09-20
New system dsn will not save settings
Hello All, Over the weekend I installed sql server 2k w/ sp2 for use with a new medical billing program they are implementing. On the server itself during the setup I need to create a new system dsn based on named pipes. I enter all of the information that is required based on the software […]
2004-09-13
77 reads
RE: How to shrink transactional logs
DBCC SHRINKFILE is the command you are after. When used for a transaction log file, it will only release space that is at the end of the log file. If there are transactions in that part of the file that have not been backed up ( I assume you are using FULL Recovery), then the […]
2004-09-08
RE: Updatable Cursor
Aaron Templeton:Thank you for your response!I have done exactly what you showed, multiple times, with no success. Which is why I am pulling my hair out on this. This should be a no-brainer.Here is what I've done:declare apvc_cursor cursor scroll_locks dynamic local for SELECT AlternateKey , DocumentNumber , DocumentType , PayItem […]
2004-09-01
RE: Standards for Backup
You can archive the catalogs (into cab files) and then back these up (this archive can be done manually or via a commandline tool), or alternatively backup the data files that are on disk (ie within the data directory) but when doing this you must ensure that you back up the repository at the same […]
2004-08-21
RE: how: SQL matching two multiple valued strings
After nine months of subscribing to this site. This is my first reply to a post. That was awsome!! I ran each part of the script independently and I still trying to grasp the entire concept. Can you explain spt_values, I attempted to use sp_helptext and the general bol and didn't find it. Thanks
2004-08-11
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