Your search for "users" returned 100 results:
Hey Gurus, I have a query that performs differently depending upon the user executing it. This was first brought to my attention because an Excel spreadsheet was taking a long time to load data (Excel 2010, Sql Server 2008 R2). The query was awful, I rewrote it and got better performance. But when the user […]
2013-09-04
3,219 reads
I have been tasked to remove all Orphaned users on all the databases in several instances on our production servers and wanted to ask how will I ensure that I do not break any application if i do so. I have the script to check for Orphaned users in every database and I generated a list […]
2017-06-29
690 reads
Greetings! Just a quick question this time. The majority of our users finish work at 5.30 so I suggested to my superior that we should start the daily differential backup job at 6PM. She said: Surely this isn't an issue as we're using SQL Server 2005 and SQL Server 2008 R2? Thanks.
2012-08-30
2,409 reads
I didn't think opening a database up to all users would be this hard, but I'm getting nowhere fast so I figure I'll post here. I have a database that I want to allow anyone to select from certain tables. To clarify, by "anyone", I mean anyone that can already login to the server. There […]
2012-04-13
3,490 reads
I have some time on my hands (sadly) and am using some of it to clean up my computer. The computer in question runs Windows 7 (no, 'upgrading' to Windows 10 is not an option) and I have used it for many years. Over time, I have installed at least three versions of MS SQL, […]
2020-08-06
391 reads
Hi I'm trying to set up Windows-based SQL logins on an existing SQL 2008 installation. The installation was created by cloning a previous virtual machine, and where and how was set up, only God knows... The New Login screen can't seem to see the list of domain users. I browse to the domain, it can […]
2012-05-18
4,548 reads
I'm working on a new WPF application, which uses a SQL Server 2008 R2 Express database, stored locally on the user's machine. In testing it has worked fine for me (naturally), but when users have tried to use it, it has failed. I've contacted Microsoft Tech support, and they've found that the issue is when […]
2013-07-09
458 reads
Hi all I need to create a schema to store a set of tables but I don't want anyone (including those in the DB_Owner role) to be able to see it.The only people able to see the schema is anyone with SysAdmin access (that's us developers who also double as part-time DBAs). Is what I […]
2018-09-05
2,051 reads
I mean how to get a list of all users with sa privilege, not manually?
2006-11-07
2,631 reads
I'm a newbie who has setup SQL server 2008 Express on a Vista machine. I installed the express edition on under my adminstrator account, and set it to use windows authentication. Then, as a test, I created a limited account (aka a standard account on Vista) and tried to connect to the database engine and […]
2010-02-03
2,376 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I took a backup with the CHECKSUM option, which was successful and showed no...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers