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

2
votes
1answer
53 views

Migrating data from SQL Server 2000 to SQL Server 2005

I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has ...
2
votes
3answers
79 views

Set up a temporary reliable database server on a budget of $0.00

I am helping run a Model United Nations conference for high school students. The conference is completely organized and staffed by university students. I am writing an application that will keep track ...
2
votes
2answers
92 views

Sql Server Limiting Access

I am not sure if what I want is possible but here we go. At work we have a dedicated SQL Server 2008 box that host the various databases that we need to run. We have a remote person (lets' call them ...
2
votes
3answers
4k views

Can't Open Port 1433 on Window Server 2008 (attempting to connect to SQL Server 2008 Express)

I'm trying to open Port 1433 on windows firewall but not having much luck. I've added a new Inbound Rule (attempting to open TCP 1433) which looks okay and appears to be on but when I run netstat -an ...
2
votes
3answers
2k views

Creating a sql dump of Microsoft Access tables

Is it possible to generate a sql script that contains CREATE and INSERT statements for some tables within an Access database?
2
votes
2answers
2k views

PostgreSQL deleteing old records from log tables

I have a PostgreSQL database which stores my RADIUS connection information. What I want to do is only store a month worth of logs. How would I craft an SQL statement that I can run from cron that ...
2
votes
2answers
682 views

SQL Server 2008: Can't remotely connect via management studio yet can telnet in OK. All settings appear OK

I am in the process of trying to configure SQL Server 2008 to accept remote connections. I have been through all the documentation I can find and yet when I attempt to connect through management ...
2
votes
2answers
4k views

IIS7 ASP - Provider cannot be found. It may not be properly installed

Getting a strange error for an old site I am trying to move to a new server - The new server is Win2008 64bit with IIS7. This site is working perfectly on an IIS6 Win2003 server, but I have just ...
2
votes
1answer
71 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
2
votes
2answers
929 views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ...
2
votes
1answer
64 views

Problems creating a functioning table

This is a pretty simple SQL query I would assume, but I'm having problems getting it to work. if (object_id('#InfoTable')is not null) Begin Drop Table #InfoTable End create table #InfoTable ...
2
votes
1answer
266 views

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 ...
2
votes
1answer
45 views

SQL Server full upgrade

our current SQL server is on windows 2003 32bit hence we have planned to rebuild the server from scratch in 64bit, however we have got about 200 databases running in the server so i may have to backup ...
2
votes
2answers
86 views

Exchange & MS SQL high availability

Could anyone suggest how high availability can be achieved for MS exchange and for MS SQL server between two Data centres when one server each is located in a data centre? Users from a siteA connected ...
2
votes
1answer
358 views

Can't conect to SQL 2008 R2 Express with Encrypt connection checked (Microsoft SQL Server, Error: 11001)

I can connect with "Encrypt connection" if I'm connecting locally, I can connect without "Encrypt connection" remotely, but I can't connect remotely with "Encrypt connection" checked. The error that ...
2
votes
1answer
74 views

Server synchronising

I have two domains, one is a .com and the other is a .net The .com site is running on a dedicated server The .net site is running on a virtual server How can I automatically redirect the .com site to ...
2
votes
3answers
4k views

64K Cluster size for SQL Server Log Files

I was wondering if we put the SQL Server Database Log file and tempdb on RAID 1, should be format it with 64K cluster for better performance? Currently the database and log file are on RAID5 which I ...
2
votes
3answers
4k views

Add the current admin user to SQL Server Express 2008

I have managed (in 'eksperiments') to remove both my Windows users from my SQL Express instance. I am now logged in as windows admin, and have re-created the corresponding SQL login, but I cannot ...
2
votes
1answer
1k views

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server. The log ...
2
votes
1answer
55 views

SQL locks between databases

Can a locked table on one database interfere with the operations of another database? The two databases aren't aware of each other. This is on SQL Server 2005.
2
votes
2answers
710 views

Whats the best application to monitor bandwidth usage on iis6?

Our hosting company is currently stinging us for bandwidth usage on our web servers. At the moment, we have no idea where the bandwidth is going! Does anyone have any good recommendations of programs ...
2
votes
1answer
2k views

SQL Import to update existing records?

I've got a table in a database that contains costs for items that gets updated monthly. To update these costs, we have someone export the table, do some magic in excel, and then import the table back ...
2
votes
1answer
418 views

Full-text catalog timeout, SQL Server 2005

we are re-loading a db with new data using backup/restore process. Once restore is complete, we re-build the full-text catalog. Full text searches work, no timeouts for about a day or so. However if ...
2
votes
1answer
806 views

How to Explain a query in Postgres 8.3 that has bind variables

I need to explain an application generated SQL statement in Postgresql 8.3. I captured the sql statement in the log but it has a lot of bind variables. Is their any way that I can explain this sql ...
2
votes
1answer
116 views

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
2
votes
0answers
144 views

Restricting access through ODBC to only schema views SQL 2008

I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When ...
2
votes
1answer
169 views

Missing MSSQL10.SQLEXPRESS folder

I seem to be missing my C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it. Any ideas?
2
votes
1answer
3k views

SQL Server (2012 Enterprise) Browser service failing

SQL Server (2012 Enterprise) Browser service failing I have a problem as described below: I have an instance of SQL Server 2012 Enterprise (thanks to MSDN) for local development on my PC. I try to ...
2
votes
0answers
38 views

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file <file-name> due to OS error 2 I have tried setting the security rights for the ...
2
votes
2answers
864 views

How do you migrate a SQL Membership database with encrypted passwords where the decryption key is autogenerated?

I have a server where the machine.config states the following: <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="SHA1"/> A decryption ...
2
votes
1answer
297 views

IIS 7.5 ApplicationPoolidentity when SQL Server is on another server

Could someone advise on best practice for setting up the Application Pool Identity for the web service under the following scenario IIS7.5 Web Service requires read/write permission to SQL database ...
2
votes
1answer
501 views

How to store text inputs of unknown & varying size? [closed]

I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
2
votes
1answer
316 views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
2
votes
3answers
81 views

MS SQL 2005 - Backup “being used by another process”

I'm trying to create a backup file of a database in SQL 2005. When I try to execute the backup operation I get an error saying "cannot access this file, it is in use by another process". Any advice ...
2
votes
1answer
97 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
199 views

Dump Microsoft SQL Server database to an SQL script [duplicate]

Possible Duplicate: Dump Microsoft SQL Server database to an SQL script Is there any way to export a Microsoft SQL Server database to an sql script? I'm looking for something which behaves ...
2
votes
1answer
76 views

VM migration of SQL Server

We have two SQL Server VMs (SQL 2005 x64 on Windows 2003x64) both have RDM SAN. The SQL Servers are also clustered. My VM admin will be migrating us to different VMs using Cisco UCS solution. ...
2
votes
1answer
726 views

SQL Server: How to report error from a job's step of PowerShell type

I have a SQL job whose step of 'PowerShell' type does 'exit 1' if encounters an error i.e. $ErrorActionPreference='stop'; trap{"$_"; exit 1} Problem is, SQL Server doesn't pay attention to that exit ...
2
votes
1answer
8k views

SQL, pl/sql, sqlplus: how to return a variable to DOS batch file?

I have a DOS batch file which invokes sqlplus, which executes some basic SQL contained in another .sql file, and I want the last part of it to return a value back to the dos batch file. However, ...
2
votes
2answers
225 views

High performance, fast yet Durable databases?

Up until recently I was using mongo to try and stem to tide of massive MySQL upgrades to system servers, however, after reading this: ...
2
votes
2answers
315 views

Creating sphinx table in mysql crashes mysql - why?

I've got the latest version of sphinx installed. I have created the index with no problems and searchd starts up with no problems. However, whenever I try to create a test table (straight from the ...
2
votes
2answers
101 views

Accessing Sql Server 2008 running on another machine

I have a laptop that I would like to access the full suite (Analysis Services, Management Studio, etc...) from the laptop, but SQL Server 2008 will be running on my local server? How can I accomplish ...
1
vote
4answers
261 views

How to know if I have/need Linux server or Windows server?

I am creating a classifieds website with PHP and MYSQL. How would I know if I need windows server or Linux? I am about to pick a host. Any other suggestions are also appreciated... Thanks
1
vote
6answers
180 views

What DBMS' have tight integration with a dedicated OS'?

It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
1
vote
4answers
6k views

SQL Server Using 100% CPU

Is there any quick way to find out what site on a server would be using all the CPU with a SQL query? As randomly the CPU is just sitting as 100% and I don't know why?
1
vote
3answers
8k views

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to ...
1
vote
3answers
3k views

sql 2008 express into cluster

Is it possible to connect two sql server 2008 express into cluster? Why we want cluster? We have SQL express DB for our software but what if DB crash or something. So we want to have backup in ...
1
vote
2answers
190 views

Group By , COUNT(*) and JOIN

When running the SQL below, any placemark_types.id that doesn't have a id match in placemarks table does not return anything in the results. I'm trying to at least get a type_count of 0 back where ...
1
vote
1answer
47 views

SQL Server database backups storage

This is rather basic question. We do backups of all the databases on the server and size around 20GB every week. All that is scheduled (shrinking,Backing up) We store them on Network drive. Now ...