• Set default value on SQL database table

    I have a SQL database that has a column with several tables. I need to create a trigger (or even a stored procedure) that would set the default value for the column in all these tables. How can I do that? Hope this question makes sense. Thanks.

    ITKE998,015 pointsBadges:
  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • Load SQL Server name

    Hello, if I want to load all SQL server name which is connected with LAN and I'm going to load in combo box in C#. What do I do?

    nayankharche5 pointsBadges:
  • Cannot install SSMS 2008

    I've recently installed Visual Studio 2010 on my local machine and it came with SQL Server 2008 Express. So along with that, I tried to install SSMS 2008 but it's not giving me any options to install it. Nothing is coming up at all. What should I do here?

    ITKE998,015 pointsBadges:
  • Error message when connecting ASP.NET to remote SQL Server

    For the past few days, we've been working on connecting ASP.NET to our remote SQL Server. We keep getting this error message: Exception - Unable to connect to SQL Server database. What should we do?

    ITKE998,015 pointsBadges:
  • Confirm SQL server connection was successful

    To connect to our SQL Server, we've been using a C++ ODBC. Here's what we're trying to figure out. Once we've made the connection, how can we make sure the connection was successful? How can we validate it? Thank you.

    ITKE998,015 pointsBadges:
  • Display SQL Server database open dialog in .NET application

    This is strictly for my .NET application. Can I display the SQL Server database open dialog? This would be similar to the font dialog. Thanks so much.

    ITKE998,015 pointsBadges:
  • Attach remote SQL database

    I have a SQL database that's stored on a remote server. Would I be able to attach it in SSMS? I tried to map it with a drive but that's not showing up as an option.

    ITKE998,015 pointsBadges:
  • Check SQL Server current connection pool size

    Hello, How can my team check the connection pool size in SQL Server? We just need the current size. Is there a query for us to do this? Thanks so much.

    ITKE998,015 pointsBadges:
  • Enabling database logging on ASP.NET app

    Can I enable database logging inside of my ASP.NET app? This is on Visual Studio / SQL Server 2008 and we're trying to see the database activity between the app and the database (particularly the logging).

    ITKE998,015 pointsBadges:
  • Connecting to SQL Server using proxy server

    Can I actually connect to my SQL Server using a proxy server? If it is possible - how can I specify the proxy address and the port in the connection string. Thank you so much.

    ITKE998,015 pointsBadges:
  • Connect LINQpad to SQL Server

    I'm pretty new to LINQpad and I also have SQL Server installed on my other machine. It's on the same domain. But I'm having issues connecting to my server from LINQpad. It said the server is not found or not accessible. What should I do?

    ITKE998,015 pointsBadges:
  • Error message when connecting from TCP/IP to SSMS

    I'm using an older version of SQL Server (2008 to be exact) and I keep getting this error when I'm trying to connect with TCP/IP from SSMS. How can I solve this? A network related or instance specific error when a connection to SQL Server... (provider: Named pipe-provider, error: 40 - SQL Server)...

    ITKE998,015 pointsBadges:
  • Logging SQL Server connection attempts

    Hello experts, I'm using SQL Server and I'm wondering if there's somewhere that my attempted login connections are stored. Is there an external log file for this? Thank you.

    ITKE998,015 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • Connecting to SQL Server through Emacs

    Would I be able to connect to SQL Server through Emacs? What are the steps I should take to do this? Any info would greatly help.

    ITKE998,015 pointsBadges:
  • Schedule a job in SQL

    I have no access to SQL Server Agent, am I able to get a SQL script run every morning 8am?

    SQL12345 pointsBadges:
  • How to replicate database between two SQL Server databases with Oracle ESB middleware?

    I have two SQL Server databases with the same version. There is a Oracle bus service between the two SQL Server database. I want transaction replication between two database, two database located in different cities. How do I configure Transactional Replication between the two Database?

    RezaBavafa13635 pointsBadges:
  • Best way to create a SQL Server ODBC data source

    What would be the best way for me to create a SQL Server ODBC data source? I know I can do this directly (Registry) but I need it to be programatically. Is there an API that can do this? Thanks so much.

    ITKE998,015 pointsBadges:
  • How to setup DSN on SQL Server Express

    How can I setup a DSN for SQL Server Express (I believe it's the 2012 version). This is installed on my machine. I tried to follow the wizard but when I get to which SQL Server it should connect to, my machine isn't there. What should I do?

    ITKE998,015 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following