RE: Clustered Data Server
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-06-30
PASS
RE: Can't open EM or QA after deleting default db
I have tried to change the default database of Administrator but as I mentioned I get an error message.
2003-06-29
RE: Can't open EM or QA after deleting default db
Every login (SQL or Windows) has a default database property. When the connection is made to SQL Server, the login is verified via sysxlogins, and then taken to the default database. If that db has been deleted, you will start seeing the error messages that you are getting. You must change the default database property […]
2003-06-28
RE: Old and Unwanted Logins
You might consider using the undocumented extended SP "xp_readerrorlog" for reading the ERRORLOG file. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-06-27
1 reads
RE: Old and Unwanted Logins
quote: I think ISS reads the ERRORLOG file looking for "Login succeeded for user" messages to keep track of the last time a user logged in. Anyone could just do this, but first you need to turn on auditing of successful logins. Gregory Larsen, DBA If you looking for SQL Server Examples check out my […]
2003-06-27
1 reads
RE: UDP Question...
Put it in a Postal scenario, TCP is like 'registered mail with a return receipt' and UDP is like 'regular mail' which doesn't guarentee dilivery.
2003-06-25
1 reads
RE: INSERT query
I'm not sure quite what you're trying to do but the following code should create the the records you want INSERT INTO Table1( RELATEDRECORDID, FIELDID, SOURCERECORDID) SELECT 1, 614, ID FROM TABLE2 WHERE PROJECTID IN (18, 26, 20, 22, 35, 38, 148, 149, 155, 278) I have found it is possible to please all of […]
2003-06-25
1 reads
RE: better locking model
CKempste will you supply a bit more info. on your environment, standards, etc.
2003-06-23
1 reads
RE: Error messages
This link has lists of assertion errors: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q290/2/12.ASP&NoWebContent=1 MW
2003-06-23
2 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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