• MS SQL Server

    I want to rename SQL Server i.e give name other than the name of the machine on which installed.

    98484200940 pointsBadges:
  • Import of Microsoft Access database file to SQL Server is slow

    I've noticed that there's an issue whenever I'm trying to import my Microsoft Access database file into SQL Server. My Access file has a ton of data but whenever I try to do the import, it takes a long time. Is there a way for me to speed it up? Thanks very much.

    ITKE1,004,430 pointsBadges:
  • Trigger events in SQL Server

    How do I find trigger name with table name and trigger events in SQL Server?

    MaD1435 pointsBadges:
  • Import text file data into SQL Server table

    My table in SQL Server has several columns and a text file. Now, I need to import information from the text file into that table. It's basically two columns that need to be imported. How can I do that? What's the best approach?

    ITKE1,004,430 pointsBadges:
  • Get SMS jobs status in SQL Server 2014

    I have several SQL Agent jobs that are running on SQL Server 2014. Now, I need to get the SMS once a job has completed. This would include the job status and if went successfully through. How can I get that?

    ITKE1,004,430 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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.

    ITKE1,004,430 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?

    ITKE1,004,430 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?

    ITKE1,004,430 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.

    ITKE1,004,430 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.

    ITKE1,004,430 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.

    ITKE1,004,430 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.

    ITKE1,004,430 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).

    ITKE1,004,430 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.

    ITKE1,004,430 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?

    ITKE1,004,430 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)...

    ITKE1,004,430 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.

    ITKE1,004,430 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