Tagged Questions
0
votes
1answer
17 views
How to create via sql and detect via ERRORLOG SQL Server 2008 Deadlocks
I am designing a monitoring program using HP Sitescope SIS.
The goal is detect deadlocks.
In doing so, I created a deadlock on an existing but nearly unused SQL Server 2008.
I used the following ...
2
votes
2answers
493 views
SQL Server drop and create all users in every DB
I would like to drop and recreate every user in a database without having to manually do this for 500 users. I have this so far:
USE [Maintenance]
GO
IF EXISTS (SELECT * FROM ...
3
votes
1answer
63 views
Many to many unique combination
So I originally thought I was going to have a one to many relationship in a database with the following tables
ENTITY_JSON_MAP
ATTRIBUTE_JSON_MAP
Originally I was going to have an FK in ...
1
vote
1answer
123 views
Database created in sqlcmd but missing in SQL Server Management Studio
I created a database named testbase in sqlcmd in SERVER\MSSQLSERVER. However, I cannot access SERVER\MSSQLSERVER.
I also could not find testbase inside the server connection using Microsoft SQL ...
0
votes
1answer
122 views
Connect to a Windows Authentication SQL server in SQL Server Authentication mode?
Is it possible to connect to a SQL server in SQL Server Authentication if the server has been installed with Windows Authentication?
0
votes
2answers
94 views
SQL Server build
We are building a new server at work and I'm hoping to get ideas of how we should build it out for optimum performance and back-up capability. We have 6 drives and we need to have an OS (Windows ...
2
votes
3answers
181 views
How to validate and upgrade my knowledge of SQL Server with MCSA
My story is that I am working now almost 10 years as an administrator, I deal with SQL Server and other IT stuff, most of my knowledge is self taught by reading books, dealings with problems and ...
6
votes
1answer
348 views
Mirroring problems after removing domain
I successfully created a mirror with certificates between two servers. One of those servers was a domain controller. After removing the domain the mirror was interrupted.After hours of searching i ...
3
votes
1answer
128 views
In which form Microsoft SQL password should be given when creating a user?
I am creating a Microsoft SQL server user with the guidance of this MSDN article and giving the system the following commands:
CREATE LOGIN MyName WITH PASSWORD = 'MyPass';
USE My$DatabaseName;
...
3
votes
2answers
540 views
Why did my UPDATE statement not complete?
Good morning. Running SQL 2008; Mgmt Studio 2008. I am working with a MS SQL job that we have created for our MS CRM 4.0 implementation. For anyone familiar with CRM, this job purges the ...
