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
693 views

Sql 2008 r2 wildcard certificate

I have installed wildcard certificate in Certificates(Local Computer)\Personal in sql server. We are using Windows 2008R2 server and 2008 R2 SQL. Certificate is issued by StartCom. With certificate ...
0
votes
1answer
144 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
33 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
0
votes
1answer
113 views

AuthDBDUserPWQuery with multiply tables

I have a MySQL authentication for SVN server. Configuration file looks like this: <Location /svn/project> ... AuthDBDUserPWQuery "SELECT Password FROM SVNUsers WHERE Nickname = %s" ....
0
votes
1answer
18 views

Crossserver SQL Procedures Failing Mid Process

Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...
0
votes
1answer
137 views

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server ...
0
votes
1answer
200 views

Delete files except ones created on sundays with in last 4 weeks

I have a script that copies some files around and deletes older files from destination. right now it just deletes everything older than 10 days. to increase backup retention we need to keep files that ...
0
votes
1answer
89 views

SQL, website and desktop application on a Windows Azure server?

I recently started considering Azure over my current VPS host PhotonVPS for Virtual Machines. I assume that Virtual Machines are the same as VPS servers (please correct me if I am wrong about that). ...
0
votes
1answer
239 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
0
votes
1answer
2k views

Sending Email from SQL Server Agent scheduled job

I've scheduled a job in SQL Server Agent that sends the result of a query in an email. If I execute the stored procedure from SSMS, it works fine. But the SQL Server Agent is not able to send emails. ...
0
votes
1answer
206 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
367 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
74 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
121 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 wa_\_%....
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
372 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
485 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
819 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
717 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
154 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
137 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
111 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
106 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
66 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
751 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
187 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
218 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
1k 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
198 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
369 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
315 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
865 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
64 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 month......
0
votes
1answer
431 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 '...