RE: QOD 6/17
Supplying the password in sp_change_users_login is new with SP3. I guess to be completely up to date they should have included that.
2003-06-17
FILESTREAM
RE: What makes a good developer?
dalecorey, I am still struggling with your interpretation for the need of intelligence. Obviously, a programmer needs to be intelligent in the way that he can perform the analysis (and in heaps of other ways too). But the analysis should not (and does not) rely on the programming language you will be using. As we […]
2003-06-17
RE: Stored Procedure
Some comments: 1) You're bringing back a LOT of data. Compare the run times just bringing back a pkey or whatever, you'll see the difference. If you have to have it, you have to have it, but I'd look for ideas to trim some. 2) Qualify the tables with the owner - ala dbo.tablename. You'll […]
2003-06-14
RE: QOD 6/13
I think that the people that answered with the 3rd option should have their answers made correct. This was a trick question. There are multiple ways to do this. Here are some I found with a Google Search. INCREASE THE NUMBER OF ERRORLOGS THAT SQL SERVER MAINTAINS There are two methods for adding the number […]
2003-06-13
1 reads
RE: Status: Performing completion actions.....
Been there ! take a look inside the process and check if it's trying to send notification mails. If the mail server is down (or other problems related to mail sent) the job remains in that state
2003-06-11
1 reads
RE: SS 2000 - sp3 Caused a problem
Not sure what you mean, but I haven't seen any issues like this and we've deployed SP3 to a couple dozen servers. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-29
RE: Is there a way to turn off the logging of an inser
Hi Brad, SQL Server is a little different than Oracle and wasn't sure which 'Bulk Insert' you were referring too... You can set the database into a 'BULK' recovery model with: ALTER DATABASE <dbName> SET RECOVERY BULK LOGGED. As long as your other jobs are not Bulk inserts you will still be able to recover […]
2003-05-28
RE: Evaluating a string arithmatic expression
Hi David, quote: Hey try this surreal solution. I doubt perfomance would justify it. your solution has indeed something Dali would be proud of Cheers, Frank
2003-05-28
RE: NT Groups and SQL Server Access Right
(1) Yes, I’ve Terminal Services installed. And Yes, I can log in with my Domain Account (It’s also a Local Admin on the SQL Server Computer) (2) Yes I can easily map to the system network share c$, d$,.. Did you have already succeeded put in place, what I'm trying to do?
2003-05-20
RE: NT Groups and SQL Server Access Right
The SQL Server computer account is what may be fried. This is just a stab. When I say administrator, I mean the Windows administrator account. You know, before going down that road, let me ask these questions: (1) If you have Terminal Services on the SQL Server computer, can anyone log in using a domain […]
2003-05-20
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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