SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to get a count of occurences of a string within multiple substrings

  I have a 168 character varchar field which represents a week broken down into hour long segements (…

  thomas.lemesurier

  1 replies

  16 years, 10 months ago

  By: GSquared

• SQL Server 2005 Database - Unicode Collation?

  Hi guys, I am in the process of changing our database to Unicode. I have all my scripts completed b…

  dharris-623527

  6 replies

  16 years, 10 months ago

  By: Gift Peddie

• installing instance for SQL server

  I have a query for the attached document containing the snap shots for the screens i encountered wh…

  nabajyoti.b

  5 replies

  16 years, 10 months ago

  By: nabajyoti.b

• How to work with column holding comma separated keys to join to another table

  Hi all, Fairly new to SQL Server and have inherited the following. Table A contains a column that h…

  Kevin Webb-483022

  5 replies

  16 years, 10 months ago

  By: Jeff Moden

• Maintenance Plans will not run: Error loading task

  I have Microsoft SQL Server Workgroup Edition version 9.00.3282.00 My maintenance plan for backups …

  Rob Fisk

  3 replies

  16 years, 10 months ago

  By: Rob Fisk

• varchar(8000) charachter limitation

  I am having trouble with an OpenQuery extract from an different data source (Cache). The data pull…

  Howard C. BAchtel-438731

  3 replies

  16 years, 10 months ago

  By: Howard C. BAchtel-438731

• Object not appearing in the object explorer

  I have a table and stored procedure that exist (I can query the table and execute the procedure), b…

  spost-842624

  7 replies

  16 years, 10 months ago

  By: Grant Fritchey

• Stored Procedure SQL

  Does anybody know where SQL Server keeps the formated SQL for a stored procedure? I know where the…

  jeffvale

  6 replies

  16 years, 10 months ago

  By: jeffvale

• Procedure with Table variable as input parameter?

  I would like to create a table valued function that takes a table variable as an input. Anyone kno…

  clayne100

  6 replies

  16 years, 10 months ago

  By: TheSQLGuru

• how do i supress cursor select set results

  Hi all. I have the following code: DECLARE prod_cursor CURSOR FOR SELECT productid <--Problem c…

  brd123

  3 replies

  16 years, 10 months ago

  By: SwePeso

• action plan for migration of Database from sql2000 server to sql2005 server with minimum downtime

  Hi all, We have migrated the database structure in test environment already. Now we have the challe…

  randeep_singh

  1 replies

  16 years, 10 months ago

  By: steve block

• Error when converting (n)text to nvarchar(max)

  I've been trying to go though and cleanup our database and start to remove all (n)text columns and …

  AlanBarber

  9 replies

  16 years, 10 months ago

  By: Johan Bijnens

• query not filtering

  I have a stored procedure that has a query in it like this Declare @sql nvarchar(MAX) Set @sql = …

  SQL_NuB

  5 replies

  16 years, 10 months ago

  By: JestersGrind

• change parameter datatype

  Dear sir, i want to change datatype in my storeprocedure parameter .my database 500 stored procedur…

  lav-888385

  1 replies

  16 years, 10 months ago

  By: Grant Fritchey

• i could not find the create database options ,how to get Management Tool ?

  Hello, i am new to SQL Server , i installed SQL server 2005,it showing Configuration Tool |________…

  ms.win83

  8 replies

  16 years, 10 months ago

  By: ms.win83