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

SQL Server - Cant connect to instance with either windows auth or SA account

I have just installed SQL Server 2012 and I cannot connect to the new instance using any method. The instance is MSSQLServer I have attempted \MSSQLSERVER, .\MSSQLSERVER, localhost\MSSQLSERVER and ...
0
votes
1answer
20 views

Can SQL Server 2008 R2 be used to allocate resources by specific program?

Recently, I have come into a scenario where I have been brought in to help manage a hosted system where we host our own product for our customer. Each customer is given a unique user to a specific ...
0
votes
1answer
30 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
1answer
135 views

Azure Database Permissions

Is it possible to create a Server Login with a Master database user that is able to create a Server Login with a Master database user ? I have not been able to do this, I always need to use the Admin ...
0
votes
1answer
146 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
762 views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
0
votes
1answer
71 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
14 views

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS running 4x SQL 2008R2 instances. i need another for the antispam product but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all ...
0
votes
1answer
248 views

How to rebuild MS Agent Jobs from MSDB table?

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
0
votes
1answer
67 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
15 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
64 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
123 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
68 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
140 views

PORT 1433 in use by LSASS.EXE, therefore cannot start SQL Server Service

Sysinternals's TCPView shows that port 1433 is used by this OpSys process, both local and remote addresses contain my FQDN, which is a Win Server 2008-R2 fully patched, has someone faced such a ...
0
votes
1answer
157 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
1k 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
93 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
262 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
20 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
61 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
85 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
40 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
262 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
259 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
434 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
447 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
94 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
112 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
41 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
87 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
99 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
95 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
43 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
266 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
1k 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
48 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
115 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
590 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
144 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
164 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
65 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
663 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
367 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
150 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
59 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
171 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
322 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
190 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 ...