SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Can a Foreign Key be linked to the Primary Key in two different tables?

  Hi, I'm running into a situation where I need a field in one table (Foreign Key) to be pulled from …

  samalex

  3 replies

  15 years, 10 months ago

  By: PaulB-TheOneAndOnly

• MS SQL Server Indexes

  Hello All, It is advised not to have more indexes on a table as it reduces the performance; I have …

  PatelVinayKumar

  4 replies

  15 years, 10 months ago

  By: Ninja's_RGR'us

• CLR SQL unloading and recreating Assemblies

  Has anyone else experienced issues with SQL CLR assemblies constantly being unloaded and created? …

  berokke1

  2 replies

  15 years, 10 months ago

  By: berokke1

• SQL Agent permissions

  Good day, In our environment every developer has a backup. I'm looking for a way to configure permi…

  Henry_Lee

  6 replies

  15 years, 10 months ago

  By: Geoff A

• Advantages On Upgrading to SQL 2008 - Specific to my environment

  We are planning to upgrade to 2008 from 2005. I have read few articles on the new features. Mention…

  curious_sqldba

  4 replies

  15 years, 10 months ago

  By: curious_sqldba

• Script SQL 2008 databases

  Hi All I used SQLpubwiz to script all databases into a SQL file, when i tried to use the …

  CrazyMan

  4 replies

  15 years, 10 months ago

  By: CrazyMan

• New Profiler Trace - but there are no Events listed in the UI

  Within SQL Server Profiler I click on File | Templates | New Template. The "Select Server Type" dro…

  Alex-815008

  3 replies

  15 years, 10 months ago

  By: sgirard 10189

• Query plan changes by usage of variables instead of values, Why?

  Hi, I have the below query: SELECT sms.SenderRef , LEN(sms.SenderRef) , LEFT(sms.SenderRef, 12)…

  sporoy

  2 replies

  15 years, 10 months ago

  By: sporoy

• Export SQL query from Execute SQL in SSIS

  Hi, I am new to SSIS and I was wondering if it was possible to export a SQL query using Execute SQ…

  anthony.hart

  2 replies

  15 years, 10 months ago

  By: anthony.hart

• Create intelligent datatype using .NET

  In my database there's a table called document which contains a varbinary(max) field. Because we ar…

  hrc

  4 replies

  15 years, 10 months ago

  By: hrc

• Grouping

  Hello All, I'm suck and would like to know if there is a way to query one table but have the data G…

  Clkgtrs1

  6 replies

  15 years, 10 months ago

  By: UMG Developer

• SSIS Package configuration error & SQL authentication

  Hi, I have a simple package which reads from SQL Server and loads into a flatfile. The OLE DB sourc…

  BaconPopper

  11 replies

  15 years, 10 months ago

  By: nick.mcdermaid

• IF ELSE .. doesnt update else part

  Hi all, I having trouble with the following code. It has to update the table fileinfo if it fi…

  Eshika

  14 replies

  15 years, 10 months ago

  By: Eshika

• Stored Procedure - Insert and Update w/2 tables involved

  I've been a casual sql user for sometime, but this is my first stored procedure. 😀 I frequently se…

  tshelly

  3 replies

  15 years, 10 months ago

  By: tshelly

• NEED TO CONVERT AN INTERGER TO A STRING THEN USE AS A JOIN TO THE TABLE.

  I have a stored procedure where i am trying to join an order table to a customer table by cust # (d…

  sharonmtowler

  2 replies

  15 years, 10 months ago

  By: sharonmtowler