SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Can we use Auto update stasitsic in Production server where it runs 24/7 can any one say the steps to follow

  Hi all, Can we use Auto update stasitsic in Production server where it runs 24/7 In our organizatio…

  naga.rohitkumar

  1 replies

  10 years, 12 months ago

  By: Igor Micev

• How to unistall sqlserver cluster in 2005

  Hi all I just need to uninstall SQL server 2005 Cluster from Active /Passive Can any one please men…

  naga.rohitkumar

  3 replies

  10 years, 12 months ago

  By: spaghettidba

• synonyms not showing in Excel

  Morning all, We have a third party app that was installed and uses some really generic names. We ha…

  Dan.Humphries

  10 replies

  11 years ago

  By: rxm119528

• Changing recovery model

  Hi, Do I have any impact on changing recovery model in SQL Server 2005 when the database is online?…

  Anbarasan.Thangaraju

  7 replies

  11 years ago

  By: Gail Shaw

• How to use SSIS to output to UTF-8 flat file

  I have a table (dbo.BatchOutput) with a single column of data (dat). It is NVARCHAR(MAX). I need to…

  blaforge

  11 replies

  11 years ago

  By: Pulivarthi Sasidhar

• Selecting all data from employee where forign key = null

  Hi guys i have view like following : SELECT dbo.Nationality.NationalityName, dbo.Employee.Driv…

  ahmed_elbarbary.2010

  3 replies

  11 years ago

  By: ChrisM@Work

• Inconsistency between sys.database_files and sys.master_files

  I tried to shrink the log file on one of our databases but after running the following USE [JKV_DA…

  gemisigo

  2 replies

  11 years ago

  By: gemisigo

• Arabic langauge not display when i make search by arabic langauge why

  Hi guys I have database hr has table Employee this table has field EmployeeName EmployeeName nva…

  ahmed_elbarbary.2010

  1 replies

  11 years ago

  By: TomThomson

• SQL Server 2008 Management Data Warehouse problem

  Hi All, We have set up sql server 2008 management dataware house (mdw) a month ago, it was working …

  sporoy

  10 replies

  11 years ago

  By: MSSQL dude

• How to make search between two dates accept null not obligatory search proplem

  Hi guys when i search record between two dates it works ok success but you must enter date from and…

  ahmed_elbarbary.2010

  2 replies

  11 years ago

  By: Jack Corbett

• Cannot use xp_blowfishdecrypt.dll

  I am tring to execute the extended stored procedure master.dbo.xp_blowfishdecrypt and its returning…

  ruser

  3 replies

  11 years ago

  By: Tolomei Dragos

• Conversion failed when converting date and/or time from character string

  Hi guy when i run this Stored procedure it give me message error conversion faild when converting …

  ahmed_elbarbary.2010

  1 replies

  11 years ago

  By: Adi Cohn-120898

• Begin tran/Rollback in SSMS after security update?

  Just did a number of updates on my workstation that I have been putting off. Some were SQL 2005 pat…

  Tim Goldstein-414423

  13 replies

  11 years ago

  By: ANn -425914

• How to send email using dbmail to email using from same table

  I have belwo codes which i want to convert to variable email IDs using same table. can some one hel…

  farhana.sethi

  2 replies

  11 years ago

  By: LutzM

• How to add a variable to @subject in sp_send_dbmail

  I've been using sp_send_dbmail and now I need to include a varchar(20) variable to the @subject EXE…

  Sir Hossfly

  11 replies

  11 years ago

  By: farhana.sethi