Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).
1
vote
1answer
13 views
After moving a DB to a new disk, the log file isn't dumping data to the DB
I recently added a new disk to our SQL Server box and followed these steps from Microsoft to move the .mdf file to the new drive. I opted to leave the log file on the original disk for performance ...
1
vote
1answer
23 views
How do I specify a linked server in SQL Server 2008 R2 to a remote database over tcp/ip?
I have a remote database running on a IAAS provider and I need to be able to execute joined queries from my local workstation. I am having trouble because when I attempt to create the link it is ...
0
votes
1answer
22 views
Accidentally Deleted SQL Server Log Reader Service Account
Uh, I accidentally deleted the Security Login in my SQL server that allows for the reading of log files.
Now, I can no longer see any of the log files in my SQL Server Logs node of SMSS:(
What ...
1
vote
1answer
30 views
sql web-application Connection String for member of a domain group
In my testing environment, I have a local sql express (2008R) server instance. I've created a domain group and given it a login in the database.
But now, how do I consctruct the connection string ...
4
votes
1answer
75 views
Accidentally turned down SQL memory too low to log in, how do I fix?
I turned down the Maximum Memory of the my SQL Server instance to 15 MB... Now I can't log in to increase it. How can I increase the maximum memory without logging in?
Version is SQL 2008 R2
3
votes
2answers
62 views
Why use separate databases for high traffic/volume tables?
While looking at the database structure of an application I am using I recognized that it uses 3 different databases on the same SQL Server instance for different things.
The first one contains the ...
1
vote
2answers
68 views
Clustered vs Nonclustered Index
My database currently has a primary Key/Clustered index on the ID column for each table. However, the application that connects to the database is always looking at views defined as:
SELECT * FROM ...
3
votes
1answer
30 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
2
votes
1answer
40 views
How Should I Configure Memory for Multiple Instances of SQL Server?
We have a set of SQL Server instances (2008 R2) that run on the same virtual server. Each instance represents a stage in our development cycle (Dev/Test/Stage/etc.). The instances all need to be ...
0
votes
0answers
9 views
SQLCMD command is not able to insert accents
I am trying to run sqlcmd.exe in order to setup a new database from command line. I am using SQL SERVER Express 2012 on Windows 7 64 bits.
Here's the command I use:
SQLCMD -S .\MSSQLSERVER08 -V 17 ...
1
vote
1answer
26 views
Limiting user access to tables based on a ROLE
I have a SQL Server 2005 database to which I would like to LIMIT access. I have done the following:
Created a database role called NO_HR
Added the tables to this role under Securables that should be ...
1
vote
1answer
45 views
SQL Server to compress the backup file from procedure
Is it possible to compress a backup file to .zip (or another) in a stored procedure invoked from a maintenance plan?
My maintenance plan contains these steps:
check DB (consistency, re_index, maybe ...
-2
votes
1answer
49 views
SQL Server backup devices autentification by user without access to local computer account or AD
Please is there way to create procedure to create Backup Device by using different user account, for user account without acces to local computer and not defined in AD too, because description from ...
0
votes
2answers
33 views
Server side trace to database
How can I set up a server side trace that dumps to a database instead of a trace file?
I set-up and tested a trace configuration I want with Sql Server Profiler that dumps only needed info straight ...
1
vote
1answer
32 views
I'm trying to disable xp_Cmdshell and rpc_out and when i run the commands on query analyzer it shows its diabled
I'm trying to disable xp_Cmdshell and rpc_out and when i run the commands on query analyzer it shows its diabled
But after this i need to run a security scan report which provides me the following ...
