SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• go back the past 12 months from today

  I have a date stored in the table as 201003, how can I get the month and year of today and go back …

  SQL_NuB

  4 replies

  13 years, 3 months ago

  By: Lynn Pettis

• SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

  Hi all, i'm not sure if this is the right place to put this post, so if anyone has an alternative p…

  extremenovice

  11 replies

  13 years, 3 months ago

  By: mulebhaskarareddy

• Having issues using BCP command to create file

  Hello, I need to add a step to a SQL job that exports a sql table to a share location as a .csv fil…

  latingntlman

  9 replies

  13 years, 3 months ago

  By: Lowell

• A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

  Hi, When I m recreate database then the following error occurred. A transport-level error has occur…

  ARUN.M.11

  4 replies

  13 years, 3 months ago

  By: Perry Whittle

• Having a network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:

  I have been working on it from a DAY but could not figure out the reason Server Error in '/' Applic…

  vineela.tatineni

  4 replies

  13 years, 3 months ago

  By: mulebhaskarareddy

• Database Design Theory - Primary Keys

  hey all - got a theoretical question. Let's say I have a table which has 20 columns. In this table,…

  kramaswamy

  10 replies

  13 years, 3 months ago

  By: Sean Lange

• User permissions required for executing ad hoc OPENROWSET() query?

  I'm trying to execute an OPENROWSET() query as a logged in SQL user, without success. If I log in …

  Rich Mechaber

  2 replies

  13 years, 3 months ago

  By: Rich Mechaber

• dbmail attachment issues for Dynamic file name

  Hi Guys I am trying to send a mail from SQL server via dbmail, but i am facing a issue with attachi…

  nitinuniyal

  4 replies

  13 years, 3 months ago

  By: nitinuniyal

• Cannot Connect to Server using SQL Server 2005 Management Studio

  Getting the following message when trying to use Management Studio. Problems started occurring last…

  barbara johnson

  2 replies

  13 years, 3 months ago

  By: DBA328

• Any way to change Save as default in SSMS ?

  Hi, How to change Save As location in SQL Server Management Studio 2005 for SQL code ? Thanks  …

  Mark Shvarts 1

  4 replies

  13 years, 3 months ago

  By: David Sette

• Creating XML & XSD through SQL Query

  Hi, I am currently been given a task of creating XML file and an XSD which will be consumed by anot…

  Suresh Arumugam

  2 replies

  13 years, 3 months ago

  By: GSquared

• Who is changing the record... ??

  Hi all, I have a record in a table which gets updated every now and then. We have got 3-4 applicati…

  Deepak.Sharma507

  2 replies

  13 years, 3 months ago

  By: Orlando Colamatteo

• Improving Delete Query

  How can I make this query run faster? It is currently taking over an hour to delete about 117,000 r…

  obtllc

  9 replies

  13 years, 3 months ago

  By: Lynn Pettis

• Trigger behaves differently when invoked from an Access form

  I need to amend a trigger on an existing SQL Server /MS Access application that I have inherited. T…

  pauldavies

  10 replies

  13 years, 3 months ago

  By: pauldavies

• Today, Tomorrow, This Week

  I have a load of records in a table. Each with a duedate. The duedate is a datetime field. I want t…

  Sachin 80451

  21 replies

  13 years, 3 months ago

  By: Lynn Pettis