Viewing 15 posts - 5,221 through 5,235 (of 6,034 total)
Here is another script to compliment the scripting of logins and permissions; it will tell you what domain accounts have sysadmin access.
Query accounts, domain groups, and members who have admin...
March 15, 2012 at 6:39 am
Here is one reference to login error 80040e4d:
The DSN used to connect to the Commerce database is misconfigured to use Windows NT security instead of SQL Server standard security.
March 14, 2012 at 11:11 am
azhar.iqbal499 (11/10/2011)
My boss has given me task of "Create DataWareHouse". Please suggest me basic level tutorials to start with.What are the requirements to create DataWareHousing in SQL SERVER 2008R2.
Thanks
Azhar Iqbal
For...
March 13, 2012 at 2:55 pm
Steve Jones - SSC Editor (3/13/2012)
Another one. If I have remote ATMs and I upload balances to it every night. Someone comes to withdraw $40 from it. Do I need...
March 13, 2012 at 10:21 am
It fails in what way; what is the error?
If multiple processes are simultaneuously selecting and deleting a large number of rows from the same table, there could be blocking...
March 13, 2012 at 8:24 am
Anam Verma (3/5/2012)
What i mean is, say a login XYZ can access multiple databases. If XYZ connects to database...
March 13, 2012 at 7:49 am
In the case of Google and other search engine companies, I don't think they're talking about transactional consistency but rather allowing for some marginal degree of inconsistency across distributed data...
March 13, 2012 at 7:31 am
ron.grace (3/8/2012)
using the following WHERE clause
WHERE HOrder.Acno = @Acno and
SUBSTRING(HDespatch.ArcOrdno,1,4) = @Unit and
SUBSTRING(HDespatch.ArcOrdno,5,8) >= @FromDate...
March 9, 2012 at 4:27 pm
Here is another MSDN tool that provides a visual guide to drilling down on the SQL Server technology stack.
Use these technical reference guides after you have made the conceptual architectural...
March 9, 2012 at 3:58 pm
Old.. stable.. reliable.. and too expensive to replace.. that sounds like a description for most of us SQL Server developers and DBAs who have worked with versions 6.5 - 2008....
March 9, 2012 at 12:54 pm
About four years ago, I was involved in a project to migrate several SQL Server 2000 databases to 2005. One of the 2000 servers hosted a database containing transactional records...
March 9, 2012 at 11:17 am
Steve Jones - SSC Editor (3/7/2012)
Eric M Russell (3/7/2012)
I don't think a US corporation can avoid SOX or HIPAA regulations simply by locating their applications and/or data offshore.
Hope not, but...
March 8, 2012 at 7:22 am
Most companies won't bother trying to avoid laws like this right now, but at some point in the future, the cost of moving an application to another country might be...
March 7, 2012 at 3:31 pm
SSIS connections should be using Windows authentication and use the encrypted option. However, you can at least try locating any .dtsConfig and .dtsx files and looking for properties called "ConnectionString".
March 7, 2012 at 3:12 pm
Lynn Pettis (3/6/2012)
agustingarzon (2/29/2012)
...This would be fool proof, and monitored by DBAs for performance problems, but this is just a small project.
...
I find this part the toughest. There really...
March 6, 2012 at 10:36 am
Viewing 15 posts - 5,221 through 5,235 (of 6,034 total)