Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

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. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1292 questions
16
votes
9 answers

Where are credentials for SQL Management Studio saved?

When we logged into SQL Management Studio(using Server Name, Login and Password) with checked "Remember Password". I need to know, where it save in PC. I need to format my PC. And when we install SQL Management Studio, then I will lose my all…
Gaurang Mistry
  • 303
4
votes
5 answers

Can I rollback last update on SQL database?

Possible Duplicate: How to rollback a deleted table data? I accidentally ran an update statement against my database. Is there a way to roll back this single update without disrupting the rest of the database?
Eugene
3
votes
6 answers

How do I report SQL Injection attacks (e.g. to User's ISP)?

EDIT : Sorry, my question clearly wasn't clear. I don't want to report attempted server attacks internally; we already have systems that log. record and report that activity. What I was keen to do was to report the attacks to the perpetrator's ISP…
Kristen
  • 187
1
vote
0 answers

PHP Fatal error: Uncaught exception

AFter building and hosting one of my zend application website, few days after, when tring to load the website, it resolves: ' No such file or directory ' on the homepage. then i had to check up the error log. i got some error logs below here is the…
Tevis L
  • 11
1
vote
1 answer

SQL Server Error 40 - Could Not Open A Connection

I have a point of sale system installed on a virtual machine on my LAN. The point of sale software references a SQL Server installed on the same virtual machine (localhost). Using this system that references the database works perfectly from the…
Daniel
  • 11
1
vote
1 answer

Why Sql browser local connection works when turned off

I recently get to interesting issue with Sql server browser. I have Win 2008 R2 datacenter server running multiple instances of Sql server and Sql browser. The instances are running under dynamic port numbers. I am using these instances as bases for…
Jan Bohac
  • 65
1
vote
2 answers

SQL Edition, serverproperty

I am trying to find all the sql installations in our network. I found more than 100 machine names which has sql installation. I tried to connect to those machines via client tool, but was not able to. This may happen either I do not have the rights…
harsha
  • 11
1
vote
1 answer

SQL Database Core Usage

Is there any way to change what cores SQL 2012 Enterprise uses? Suppose you have 16 cores on a server, what is the process of going through and telling the database to only actively use 2 cores? Is that even possible?
Adam Hart
  • 93
1
vote
1 answer

Anybody know of a free SDF file viewer?

I have an SDF file and am looking for a free viewer to just view the db? Thanks
Beginner
  • 133
1
vote
2 answers

How to define datatype to match the data length?

I need to create a new table include some sharepath (e.g. \\network\sharespace\test1), To avoid query results follow some blank spaces after the path(e.g. I cann't accept \\network\sharespace\test1__________like this),I need to set its datatype to…
pansal
  • 269
1
vote
2 answers

Can you have two sql instances on 1 server, with an IP each for local network access?

This is partway setup, but not sure what I've been asked to achieve to 100% possible. 1 server 2 instances of SQL Server 1 internal IP for each sql instance 1 external IP for each sql instance Both instances are installed and working for remote…
Dan Harris
  • 155
1
vote
3 answers

Check sql server instance conectivity

Our daily checks involve checking all servers in our network for conectivity. At present we manually log on to each server and their instance to check. Is there a tool that will automaticaly check all servers and their instances on the network or…
Andy
  • 199
1
vote
1 answer

SQL SERVER Restore Problems

I have created a backup of my production database and whenever I try to restore it on my local machine I get the following error: The media family on device C:\projects.......name_of_the_database_.bak is incorrectly formed. SQL SERVER cannot process…
user21004
  • 153
0
votes
1 answer

Autotask PSA SQL query errors

We paid $150 to Autotask (now Datto) for a backup / export of our PSA data which they provided in the format of a .BAK file which is an SQL database. We need to extract data from the Autotask PSA assets' user-defined fields (UDFs) so, in a…
mythofechelon
  • 905
0
votes
1 answer

Cloned Server Cannot connect to SQL Server 2017 Instance

I just recently cloned a dev server from a production Microsoft Dynamics 365 server having SQL Server 2017 installed on it. Now when I log in to the dev Server and to SQL Server via the SSMS I am getting the following error. A network-related or…
Pro Funter
  • 1
1
2 3