Tagged Questions
1
vote
1answer
244 views
how to add attachment(text file) to database mail?
I have scenario
Daily i run a sql job to apply a new updates to one table - this job will create one text file daily - text file contains all new updates
I can send a mail to client that job is ...
0
votes
2answers
221 views
Remote database connection problem?
I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database.
I am able to use the database on ...
2
votes
1answer
336 views
Solve conflict between affinity mask and I/O affinity mask?
I executed this on one of our SQL Server machines:
EXEC sp_configure 'show advanced options', 1
And then executed RECONFIGURE. This presented me with the following error message:
The affinity ...
-3
votes
1answer
265 views
Single query to copy data from 3 tables into a single empty table
In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table.
I started saying "I will use a temp table or table variables", ...
9
votes
1answer
363 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
2
votes
1answer
178 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
3
votes
1answer
80 views
Inconsistent information from different DMVs
I've a server with 12 GB of physical RAM. I just lowered its 'Max Server Memory (MB)' setting from 10 GB to 8 GB.
If I look at the processes' committed memory in Perfmon, I see:
select *
from ...
2
votes
0answers
607 views
823 errors on tempdb
Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like:
2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2.
2012-05-09 ...
2
votes
2answers
1k views
Why can the SA account no longer access the master database?
I'm somewhat stuck. We have a database server which was set up and configured by a third party. It's for a third party product so unfortunately we're stuck with the way they've configured it.
Their ...
7
votes
2answers
438 views
SQL Server schema intact but every record from every table is gone
We recently set up a new virtual machine running Windows Server 2008 and slapped a copy of SQL server 2005 on it. The server had running and in use without a hitch for about two weeks. The only real ...
