Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

0
votes
1answer
188 views

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and ...
0
votes
1answer
358 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
0
votes
1answer
24 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...
0
votes
1answer
73 views

SQL Server normalizing for performance

I have a table create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null ) All ...
0
votes
1answer
115 views

Grant user Permission using Wild Card on MYSQL

I'd like to Grant for example an insert permission for spacific user in all databases started by WA_ for example in my server I make the following syntax but it dosent work GRANT SELECT ON ...
0
votes
1answer
44 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
0
votes
1answer
360 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
0
votes
1answer
452 views

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out ...
0
votes
1answer
785 views

MySQL Corrupt Table - No Space left - Index File too big

I noticed that one of my servers was running out of disk space, due to heavy MySQL usage. I stopped everything using the database, freed up some space and restarted mysqld. Now, I checked my table ...
0
votes
1answer
678 views

GPO WMI username filter not working over RDP

I'm trying to write a WMI filter to prevent a GPO from applying to certain users SELECT * from Win32_ComputerSystem WHERE NOT UserName LIKE 'domain\\user1_%' AND NOT UserName LIKE 'domain\\user2_%' ...
0
votes
1answer
148 views

Delete data from a SQL Server database on a full partition

I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I ...
0
votes
1answer
136 views

SQL Server 2012 Memory usage

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB ...
0
votes
1answer
43 views

SQL Server 2008 data migration to another SQL 2008 server

I am currently running SQL server 2008 (SQLserverold) which homes databases for systemn center Service Manager 2012 Datawarehouse. This server is very old and needs to be decommisioned. Prior to ...
0
votes
1answer
89 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
0
votes
1answer
109 views

Issue restoring Sql Server DB -

Im trying to restore one our DB on Sql2008r2 but i keep getting this error: " netStagingDB_log.ldf' is claimed by 'ftrow_FTCat_Sheds' and 'ftrow_FTCat_Codes'. The WITH MOVE clause can be used to ...
0
votes
1answer
105 views

How can I lock a SQL Server Login programatically. Emulate a users invalid attempts

I need to programatically lock a SQL Server Login. The goal is to emulate the automatic function in SQL That will lock out a user that makes several connection attempts with a bad password. I can ...
0
votes
1answer
59 views

Why ALTERDB reports “No checkpoints available to delete” even though I have them on the filesystem?

This morning I was greeted by Ingres 10.0.0 with the following: [ingres@denux ~]$ alterdb dejandb -keep=60 Mon May 28 08:54:17 2012 ALTERDB: No checkpoints available to delete. [ingres@denux ~]$ ls ...
0
votes
1answer
281 views

Add a SQL user similar to a current user via PowerShell?

I'm slowly but surely perfecting a new user script. As it is, my script will do everything to add a new user to our domain, except one thing. We have an in-house program, webpage front end that ...
0
votes
1answer
2k views

SQL Server doesn't allow to execute subquery as dynamic SQL

I tried to make a dynamic SQL which gets all tasks for some users The procedure [GetAllSubExecutorsByUserId] returns IDs of all subalterns of curent user I write these IDs into a temporary table, and ...
0
votes
1answer
49 views

Website and DB Backup - Windows Dedicated Servers and SQL Express

I have inherited a number of dedicated windows web servers running websites and local SQL Express Databases. We want to backup both the sites and the databases remotely - maybe to some cloud storage ...
0
votes
1answer
123 views

Is it possible to set a default column value in PostgreSQL using an external non-SQL function?

For example, say I wanted to have one column take the row id and run it through a Python script which returns some information related to that number (random example). Would I need to manually ...
0
votes
1answer
741 views

Cannot connect to sql server from vpn client

I have a client that using openvpn is connecting to a remote lan where i have a openvpn server (zeroshell) i can use any service without troubles. Now i am trying to connect to a sql server sitting on ...
0
votes
1answer
181 views

sp_sqlagent_get_perf_counters sql 2005 running every 20 seconds

A little background info: We are running SQL Server 2005 SP2 on a server with Microsoft Windows Server 2003 SP2. When I run profiler I notice that EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters is ...
0
votes
1answer
103 views

Space availability issue

I am using SQlserver2005. My database are becomeing very large and space is becoming very sparse. Please suggest what to do? (apart from buying space)
0
votes
1answer
215 views

Orphaned SQL Recordsets/Connections with IIS

I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL ...
0
votes
1answer
84 views

SQL Server Subscriber Migration

We're currently have one way transaction replication from a SQL Server 2005 OLTP publisher/distrbituor to two subscribers (one SQL 2005 and the other SQL2008 R2). Replication security is via the SQL ...
0
votes
1answer
991 views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
0
votes
1answer
410 views

SQL Server - Moving and Increasing number of TempDB

Based on best practices recommendation, we want to do the following Move tempDb to new dedicated drive Increase number of tempdb to 4 (all equally sized) Can anyone please share the commands, as I ...
0
votes
1answer
153 views

security in sql server 2008 r2, create special user

I have a system win server 2008/ sql server 2008 r2 where sql server is accessed by remote user (the same but multiple connections). I need to have a user who can create/alert databases but I do not ...
0
votes
1answer
61 views

Transactional replication

I have two databases in same instance of SQL Server 2005, configured for Transactional replication. When data is changed, the changes are replicated properly in both databases. For the new created ...
0
votes
1answer
195 views

SQL Server Backup Strategy for OLAP System

I need advise on what would be the best strategy for backups of OLAP database (WHICH is roughly 500gb in size) Would this be fine: 1. Weekly (Full) 2. Daily (Differential) No need to hourly log file ...
0
votes
1answer
366 views

SQL Server on VMWare - is transaction log corruption possible?

Scenario: SQL Server 2005 or 2008, Windows 2008 OS. Running in a VM hosted on VMWare ESX server. Is there any known issue with VMWare when it caches pass-through write request and it never reaches ...
0
votes
1answer
307 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
0
votes
1answer
96 views

sql 2008 hard drive configuration

I'm building out a new SQL Server 2008R2 64BIT, will be running two user database of about 20gb and 15gb, maybe 50/50 read/write, and about 210 users Base hardware would be DL380, 48GB, and IntelĀ® ...
0
votes
1answer
857 views

Error while installing sql server 2008 - “the collation was not found”

In the server configuration page of my Microsoft sql server 2008 setup, the database engine field in the collation tab is empty. I think it should be having "SQL_Latin1_General_CP1_CI_AS" written ...
0
votes
1answer
42 views

Using a subscriber database as a backup

I am trying to set up a transactional replication database on two MSSQL 2008 Standard servers. We need to be able to query off of the subscriber database, but we would also like to be able to use the ...
0
votes
1answer
63 views

MySQL Column Constraint

I need a table which will allow to insert values into a column with values greater than 10. When I tried in net, they suggested to create table in following way. CREATE TABLE test ( UID int(11) NOT ...
0
votes
1answer
51 views

SQL2008R2 Partitioning query

We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by ...
0
votes
1answer
428 views

Linked server sql server 2008 r2

We have two SQL servers and we've setup a them as linked servers. The queries works just fine if I connect remote desktop to one of them and execute query. If I try to execute query from third machine ...
0
votes
1answer
1k views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
0
votes
1answer
71 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...
0
votes
1answer
44 views

Can't find SQL 2005 client and repoting tools after install

I've gone through the related questions and I'm still stuck. I installed SQL 2008 R2 Express and then it turned out I needed reporting services client tools in SQL 2005. I uninstalled SQL 2008 and ...
0
votes
1answer
80 views

Shrink a DB and Log File in SQL after a database clear

We have a script that we use for client conversions that deletes all date from almost every table from a database. We do this so that we can clear out any data not related to the application ...
0
votes
1answer
59 views

find out which method is pegging my IIS 7 server?

I have a pretty simple web service app running on my server but every once and awhile it pegs one of my cores to 25% constantly until I stop and re-start then it goes back down to between 1% ~7%. I ...
0
votes
1answer
582 views

Gerrit uses wrong collation

I'm trying to authenticate Gerrit users using ldap against Active Directory. I get the following error. ERROR com.google.gerrit.server.cache.PopulatingCache : Cannot lookup ...
0
votes
1answer
406 views

Is it possible to hide a Perspective with XMLA in Analysis Services 2008?

I have a SSAS cube that has 2 perspectives. The second perspective is only used in a secured environment. I would like this perspective to be hidden when new users connect to the general populations ...
0
votes
1answer
4k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
139 views

Can't submit timesheets on Project 2007 and Server 2008R2 new install

I'm trying to test move a SharePoint 2007 and Project 2007 to Server 2008R2 and using SQL 2008 as the backend. I'm setting it up just like I have done numerous times for Server '03 and there are no ...
0
votes
1answer
91 views

Distributed Microsoft SQL server deployment - Cluster?

I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them. My Idea is to ...
0
votes
1answer
110 views

Stop unauthorized attempts to access port 1433

I'm picking up huge amounts of attempts to access our SQL database through port 1433 (Windows Server 2008). How do I configure a firewall rule that only allows access from the box IP only so that the ...