SuperSocket Error
I am receiving an error on my event log: Supersocket info:(SpnRegister) : Error 1355. This is only a warning message and does not happen every day.
2002-01-08
4 reads
Interviews
Trans Log Backup Failed
I'm trying to backup the Trans Log files of a brand new install after I backed up the DB. It keeps failing. Seems like Northwind, MAster, and MSDB are the culprits. All other DB's have the Translogs backed up in the job except those 3. Anything?
2002-01-05
4 reads
Using TSQL to Generate Scripts/Backup Jobs
Hi, I am looking for a way to automatically backup jobs that have been created. I see that you can right click in Enterprise Manager and generate a script for all jobs. Does anyone know how to do this through TSQL? I would like to set up a job that calls a stored procedure that […]
2002-01-05
3 reads
Full-Text Indexing Limitations
Hello All, I am involved in a document management project.I am right now weighing the pros and cons of storing the documents on the database/filesystem.I have to implement full text indexing on my documents.We might be having a maximum of 50,000 documents and max document size is 2MB.We are storing all kinds of files(.doc,.txt,.html,.pdf etc). […]
2002-01-05
31 reads
DTS Errors
This came out of a job I scheduled. Any ideas what could be causing these errors? Thanks for your help! DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213242 (80042046) Error string: General error -2147213242 (80042046). Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts.hlp Help context: 0 Error Detail Records: Error: -2147213242 (80042046); Provider […]
2002-01-02
55 reads
Permission Issue
There is an issue coming up just recently that has both me and the DBA scratching our heads. There is a view that has been created that displays every field in the table. It only displays from one table. The user has Select, Insert, Update, and Delete permissions to the view. When she tries to […]
2002-01-02
updatable subscriptions must use trigger?
Playing with updatable subscriptions, I've found an odd thing: It seems I have to alter my existing triggers to exit if they are fired by the repilcation trigger. Is this so? I have a lot of triggers that my users are gun-shy about altering and maintaining. How can I get 2-way replication without changing my […]
2001-12-31
nternet Data Center 1.5 - Reference Architecture Guide
Comments posted to this topic are about the content posted at http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/itsolutions/net/plan/idc/default.asp?frame=true
2001-12-29
4 reads
How do I delete the log file for a dB?
The log file for a database has grown to over 5 GB leaving less than 4 MB of hard disk space on my server. All this happened as a result of copying a large dB. How can I delete the log file. When I choose to delete it using Windows Explorer I get a sharing […]
2001-12-27
How to Install SQL Server 2000 Clustering
Comments posted to this topic are about the content posted at http://www.sql-server-performance.com/sqlserver2000_clustering_install_main.asp
2001-12-21
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Democratizing Core Contributions: A Guide to WordPress.org Badges
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
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