I am an Oracle DBA. I need to fix a issue in a Sqlserver database and I am a newbee to it. Large number of rows are inserted into some tables in the database and database size keep increasing, say 500 MB in a hour. I didn't have database/application design or table details. I need […]
2001-11-30
When I run a distributed query (a query that uses a linked server), I get the following error in query analyzer: ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 14 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Connection Broken AND IN THE SQL SERVER LOGS: Error: 0, Severity: 19, State: […]
2001-11-20
10 reads
One of the common questions you see in the newsgroups is where should you save your DTS packages. This article covers the most optimal way to save your packages as well as version controlling DTS.
2001-11-15
9,734 reads
When we tried to upgrade our SQLServer 7 SP2 to SQLServer 2000 we got an error when running messages.sql. ('Error running script: messages.sql (1)') After this the installation/upgrade stopped. Now it is no longer possible to start SQLAgent. ErrorMessage: (000)SQLServerAgent cannot start because the instanceof the server() is not the expected instance(MSSQLSERVER) When we want […]
2001-11-07
6 reads
I've just applied SP3 to our SQL Server 7 on NT 4 (SP5), during the process I selected NT Authentication. Since then none of my DTS packages that has "Executes the cn.Open command" is able to run. I get the error msg "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server […]
2001-11-05
2 reads
DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.
2005-07-01 (first published: 2001-11-01)
37,334 reads
I have DB1 and DB2 resides on the same DB server. What tools/methods do I need to use in order for DB1 to trigger DB2 and let DB2 knows that there is oncoming data from DB1 that needs to be processed and accept the data.
2001-10-25
1 reads
I did a restore of databases to a disaster recovery box. Everything came over fine except the security because it was stored in the master of the production box. The disaster recover box has a master that I cant mess with so basically my question is how do I script out the logins from the […]
2001-10-25
1 reads
My name is Fred Adler and I am an independent recruiter. I am seeking to fill a SQL Server DBA position based in Ft. Lauderdale, Fl. with one of the largest Human Capital Management firms in the US. The position will oversee all activities related to the administration of distributed NT /Win2K SQL 6.5/7.0/2000 computer […]
2001-10-25
Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.
2001-10-25
4,975 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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