• Drop Database Connections

    Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

    Javad5 pointsBadges:
  • How to create new ramco test server?

    Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

    Amitshukla60 pointsBadges:
  • Running queries causing system to hang

    A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The machine is...

    WindowsServerATE335 pointsBadges:
  • Error running an ASP.NET application in SQL Server 2005

    I have SQL Server 2005, version 9.0, installed on my system with VB.NET 2005 and IIS server running. When i tried to run an application created in ASP.NET, it showed me the following error: The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • The XML page cannot be displayed

    I am using sql server 2005 with vb.net 2005 and IIS server installed. I tried to run the application created in Asp.net,but it showed me the following error. The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or...

    Sajad5 pointsBadges:
  • Create text file to OS400 folder by using Microsoft SQL Server 2005

    Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to...

    Sql200920 pointsBadges:
  • HTTP 505 calling SQL Server Web service from SAP PI 7.1 SOAP Adapter

    Hi, I have a SAP PI 71. scenario where I need to call a Web Service exposed by an SQL Server 2005 app running on widows 2003. The SOAP adapter call fails with an HTTP 505 indicating mismatched HTTP versions. it appear that sap is speaking 1.0 and sql server is speaking 1.1. Do you know of any way...

    Ziglmorf5 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • SQL Server Linked Server Security Context

    Hey everyone, I'm working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use...

    Lvance16115 pointsBadges:
  • SQL Server 2008 extended stored procedures

    I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP's from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the DLL is not there is...

    KH155 pointsBadges:
  • SQL Server 2005 – Analysis Services can’t Right click and create new Data Source

    In SQL Server 2005, under the analysis server, we cannot right click on Data Sources and choose "new Data source". Only Reports and Refresh are available.

    Swish19765 pointsBadges:
  • IBM System x3400 connectivity

    We have brought IBM server x3400(7975PAT) which is running on windows server 2003 with SQL sewrver 2005 which is connected to 15 kiosks. I want to connect it to the one more server 2003 installed system to transfer data from the ibm server. How to connect ?

    Ppaul5 pointsBadges:
  • Error while referencing external assembly in SQL Server 2005.

    Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I am...

    Batsa15 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • SQL Server with domain accounts

    When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up...

    Andrewn20005 pointsBadges:
  • split column into column

    I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.

    Shamilh10 pointsBadges:
  • Searching for a T-SQL query to find data from multiple SQL 2005 servers

    I need a T-SQL query to find a list of all database names and sizes from multiple SQL 2005 servers that are connected in a local network. Does one exist?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 log shipping network pass thru security

    I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts. I have configured the SQL Agent on each machine to use a local account (.\SQLAgent) with the passwords the same on both machine. The secondary machine can read the network share that...

    Jando9995 pointsBadges:
  • SQL Server 2005 Select Multiple views or Tables

    in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...

    SapwizSAP5 pointsBadges:
  • SQL Server 2005 SP3 installation on Vista – error message

    A user recently submitted this question via e-mail: This Program has known compatibility issues. Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005...

    JennyMack4,280 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following