SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Uninstalling SSRS

  Hi all I am having major problems with a SSRS install in our Staging enviroment. The databases and…

  Kwisatz78

  1 replies

  15 years ago

  By: george sibbald

• Dump procedures to disk

  SQL Server 2000 used to have a utility to dump all of the procedures to disk in either a single fil…

  schristi69

  2 replies

  15 years ago

  By: schristi69

• Date Conversion to YYYYMMDD

  I need help with a date conversion. I want to convert all dates in my query result to YYYYMMDD. The…

  kbnyny

  3 replies

  15 years ago

  By: Nils Gustav Stråbø

• Unexpected Columns being set to NULL with record updates

  I have a strange problem that doesnt make any sense. I have a partitioned table with 175188842 rows…

  d_s_man

  11 replies

  15 years ago

  By: Jeff Moden

• Concatenate values in the same column

  Hi !! I have 2 tables Table 1 ID Description ---------------- 1 'DATO UNO' 2 'DATO DOS' …

  teresita.castro

  3 replies

  15 years ago

  By: teresita.castro

• CHARINDEX manipulation

  Hi there, I am trying to get Emergency information from one of my sql server 2005 tables. Here are…

  steven.munro-oakley

  2 replies

  15 years ago

  By: steven.munro-oakley

• Index in SQL Server 2005

  Hi all, I have a question and want a support Can we create a Non-Clustered Index which contain a fi…

  Dung Dinh

  5 replies

  15 years ago

  By: Gail Shaw

• Shrink Log file

  Hi, I'm a SharePoint admin and I'm a newbie to the databases. All my SharePoint web applications a…

  smaripalli

  2 replies

  15 years ago

  By: Gail Shaw

• Tips for writing queries needed

  --==== daily query to pull data from database to flat file SELECT V_APPT_BASIC.PERSON_ID, V_APPT_B…

  mashikoo

  21 replies

  15 years ago

  By: Lynn Pettis

• SQL Server 2005 PIVOT/UNPIVOT help needed

  Hi, I have been reading up on PIVOT an UNPIVOT but have not been able to get the results formatted …

  roger.hill

  1 replies

  15 years ago

  By: steve-893342

• Best practices for upgrading log shipping server

  Hi, We have a log shipping server. It just contains all the log shipped databases in standby/rea…

  Skybvi

  6 replies

  15 years ago

  By: Skybvi

• Creating A View within an IF statement

  1 | DECLARE @DBNAME VARCHAR(50) 2 | 3 | SELECT @DBNAME=DB_NAME() 4 | 5 | print @DBNAME 6 | 7 | if(@…

  rbaskett

  3 replies

  15 years ago

  By: rbaskett

• Error:Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) in SQL 2005

  Hi all, Please inform me how can I avoid getting the error message as "Maximum stored procedure, fu…

  mailgokul

  4 replies

  15 years ago

  By: sintia

• NT AUTHORITY\NETWORK ReportServer Activity

  Hello, I have a question about the NT AUTHORITY\NETWORK SERVICE account. We recently upgraded to S…

  amy26

  2 replies

  15 years ago

  By: amy26

• Single huge view or mutiple smaller views

  Hello there, I wonder if there is any performance difference between querying a huge single view or…

  clementstore

  6 replies

  15 years ago

  By: Jeff Moden