SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Restoring database keep getting error session in use

  Full error: ' RESTORE cannot process database 'SmecIntranet' because it is in use by this session. …

  Aubergine Blue

  6 replies

  15 years, 10 months ago

  By: Gail Shaw

• Query performance tuning

  Hi SQL Gurus, I'm new to write storeprocedures and Queris.What are the jobs consider While …

  Suresh Mediboyina-615840

  2 replies

  15 years, 10 months ago

  By: NickDBA

• Query to show dates in columns

  Hello SqlServerCentrals Users I have this question/request. Id | Name | StartDate. | …

  aslowmo

  7 replies

  15 years, 10 months ago

  By: Jeff Moden

• how to insert japanese characters from storedprocedure

  Hi i am trying to insert japanese characters ,if i do like below it's working 1.insert into japane…

  keerthi_m

  4 replies

  15 years, 10 months ago

  By: Lamprey13

• I have few sqlzoo query command questions

  Thank You in advance How are you doing ladies and gentleman. I got few exemple queries from a buddy…

  bruce.canyon

  6 replies

  15 years, 10 months ago

  By: bruce.canyon

• Strip Out the First part of a string

  IF OBJECT_ID('TEMPDB..#Test') IS NOT NULL DROP TABLE #Test GO CREATE TABLE #Test ( …

  Ranga846

  3 replies

  15 years, 10 months ago

  By: Nabha

• column width limit on export?

  I am using the Wizard to export a table to a tab-delimited text file. The first of six columns is …

  dglane

  2 replies

  15 years, 10 months ago

  By: dglane

• Connect Database Engine

  Hi I work with several SQL servers and when I load a script file to Management Studio I double clic…

  anders.ostman

  4 replies

  15 years, 10 months ago

  By: anders.ostman

• Serializable Isolation Level

  Dear All I have some confusion about Serializable Isolation level. If I set Serializable Isolation …

  gupta1282

  1 replies

  15 years, 10 months ago

  By: Ian Scarlett

• DBCC error & need to delete rows from sys.columns table

  Getting DBCC error , looks like table got delete & not columns from sys.columns Check Catalog …

  kittu123

  4 replies

  15 years, 10 months ago

  By: WayneS

• SQL 2005 - Looking for a DB deleted - The system cannot find the file specified

  Hi Guys, I'm getting the following error messages when SQL is starting FCB::Open failed: Could not…

  Champs123

  2 replies

  15 years, 10 months ago

  By: Joie Andrew

• substring more than 4000 characters

  i have a data which has 8500 characters and i need the characters from 20 to 8350. how to do? subst…

  kkabdul

  4 replies

  15 years, 10 months ago

  By: Joie Andrew

• Scheduling an Agent Job to run on specific dates across multiple months?

  Hey Guys, I need to schedule a job that executes an SSIS package, and the job needs to run on the…

  DataGuy

  3 replies

  15 years, 10 months ago

  By: Michael Valentine Jones

• Best Way to store

  I have a Hospital Management System. The hospital had multiple branches. I laid the database struct…

  jsheikabdullah

  2 replies

  15 years, 10 months ago

  By: GSquared

• calling webpage from sql server

  Hi I am generating the feedback form for different jobs in the IT Help Desk. ASPX page generates th…

  a2zwd

  1 replies

  15 years, 10 months ago

  By: torpkev