Unknown sa password
I've inherited a box from another of our organizations but nobody knows the sa password. As this is a production server, how do I retrieve or change the sa password without corrupting anything in the databases?
2004-12-03
3 reads
Query Plans
Upgrade 7 to 2K - how hard is it?
We are upgrading our SQL7 to SQL2K on a development server. We want it to be our default instance. I used the Upgrade Wizard with good results when I upgraded my machine.Besides full backups on all system and user dbs, are there any pitfalls to using the Upgrade Wizard to upgrade SQL server in place?I'd […]
2004-11-01
RE: How to run DTS Packages from Query Analyzer
Dear Waseem Thanx for your kind support this has helped me a lot. But still i am new to this environment. Pls can u show me an example how to create DTS Packages and how to save it and run in Query Analyzer. I know from Enterprise Manager we can do it. Regds Dharmendra
2004-10-28
RE: exporting row with newline character to a text file
CHAR(13) "Carriage Return" and possibly follow with CHAR(10) "Line Feed"
2004-10-21
Heres How to Generate lots of data from a tiny table - maybe you already know this
I was doing some time trials today and couldn't get enough data to really "hurt" the procedure, so I hit upon the Cross Join functionality. Say you want a million+ records and your biggest testing table has only 1000.All you have to do is Cross Join it to itself and you get 10002 or a million […]
2004-09-09
1 reads
RE: Question of the Day for 14 Jun 2004
Question is an issue because the answer can be any of the three that are not ints for the func marks. It also is considered bad practice to use bit for a condition since you are limiting your options. Also you should ultimately be controlling thru permissions on the function itself so the design set forth. However take […]
2004-06-14
RE: Thanks for this site ! Any similar for DB2
quote: DB2 on Windows is a mistake, I don't know what IBM was thinking but the problems are infinite. It works, and is stable so don't get me wrong, but compared to SQL server forget it. I guess you know those situation where you cannot argue with sound and logical arguments! Someone who decides, wants […]
2003-08-27
RE: Thanks for this site ! Any similar for DB2
I've just remembered http://www.lazydba.com They have a DB2 mailing list. I just wonder, if it is active ? Cheers, Frank
2003-08-26
1 reads
RE: Executing sql queries using templates
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!
2003-08-18
RE: implementing historical info
If I wanted to keep a record of all the "spUpdateEntity" sprocs that were executed on the database I would have spUpdateEntity log all the parms to a separate table (also with CURRENT_USER and CURRENT_TIMESTAMP columns). If I wanted to keep an audit trail on the entity, regardless of whether it done by spUpdateEntity, I'd […]
2003-08-17
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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