Viewing 15 posts - 2,176 through 2,190 (of 6,105 total)
When a client first connects to a SQL Server, it talks to the server's UDP/1434 port. That's the destination port for the client. The source port on the client is...
April 21, 2006 at 10:55 am
And you won't be able to. Without a domain controller, that means all computers are in a workgroup. Even if they all are in the same workgroup, there is no...
April 19, 2006 at 1:46 pm
I cover mine in my eBook, but it doesn't cover scans in the detail you're looking for... I was more geared towards overall health of the server. My homepage (Professional...
April 19, 2006 at 1:38 pm
When a login doesn't map into a database by any other context (user), if guest is enabled for the database, the user gets the rights assigned to guest. The databases...
April 17, 2006 at 1:05 pm
The best architecture books are:
Inside SQL Server 2000 by Kalen Delaney
The Guru's Guide series by Ken Henderson. The last of the series is specific to internals.
SQL Server 2005 books...
April 17, 2006 at 12:51 pm
Most tend to be cumulative... kind like how they deal with DNS. Closest thing to versioning:
About the only other thing you can do is find out...
April 13, 2006 at 5:34 pm
SQL Server you can usually tell by the results of @@VERSION. Or are you speaking of the OS?
April 13, 2006 at 8:51 am
This is all true... however, I can personally attest to the fact that my organization was required to ensure no personably identifiable information of this sort was allowed out. Since...
April 12, 2006 at 8:35 pm
No reason to cross-post.
April 12, 2006 at 8:32 pm
Domain local groups should be seen by the SQL Server if it's in the same domain. The mode (native vs. mixed) doesn't have an impact on the domain local group......
April 12, 2006 at 8:24 pm
I look for periods where I know there's going to be "dead time." For instance, when you get into a meeting and you wait for everyone to show up... that's...
April 10, 2006 at 10:50 pm
The DTSRun utility is making a connection back to the SQL Server you have specified with the /S parameter. The DTS package is stored in the msdb database and as...
April 10, 2006 at 12:24 pm
Gone through both as well as a couple of Systrust categories. SAS70, in general, was not as strict as SOX. Ours did a review of access, as indicated by kc,...
April 10, 2006 at 10:11 am
When you get the error, does it indicate the login failed for that particular user or does it give a different error message? When you say "all the users in...
April 10, 2006 at 9:55 am
The problem is DTS executes through the use of an executible, dtsrun.exe. Therefore, from within a stored procedure the only way to do this is to you xp_cmdshell... not exactly...
April 10, 2006 at 9:49 am
Viewing 15 posts - 2,176 through 2,190 (of 6,105 total)