SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Is it possible to SUM(@variable)?

  I am thinking of setting up a control table which has 2 columns: - MeasureID - MeasureName The Meas…

  commonman00

  7 replies

  13 years, 5 months ago

  By: Lynn Pettis

• Running same SQL code against a number of tables

  I have a number of tables (around 40) containing snapshot data about 40 million plus vehicles. Each…

  Daryl Lloyd

  8 replies

  13 years, 5 months ago

  By: Daryl Lloyd

• Using column alias in my where filter

  Hello, I have an alias for 2 calculations. I would like to filter only those results that are >1…

  t-pinto

  12 replies

  13 years, 5 months ago

  By: MMartin1

• Grant execute permission to all sql logins for a stored proc

  I have to grant execute permissions to all sql logins on a particular store proc. Can someone help …

  Pink123

  5 replies

  13 years, 5 months ago

  By: Pink123

• How to reoke permissions on a particular Role

  Hi All, I have a user role,for that role having full permission. That role is using in all th…

  SqlSpider...

  1 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Strange behavior in query results - "not in" vs "left join"

  I'm seeing some strange behavior on a client's SQL 2005 server and wondered if anyone else has ever…

  K Currie

  6 replies

  13 years, 5 months ago

  By: K Currie

• WHy on earth?!

  I am not sure why this is happening, but I am trying to execute this store procedure, and I am rece…

  donato1026

  5 replies

  13 years, 5 months ago

  By: donato1026

• trigger failing on data transfer

  I have a trigger that gets executed when a serena SBM workflow item is created. Serena has no help …

  rebecca.moore.ctr

  9 replies

  13 years, 5 months ago

  By: rebecca.moore.ctr

• Disable constraints

  Hi, A unique constraint automatically creates an index. What happens with the index if the unique c…

  Jurgen H.

  1 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Convert a Firebird database to MS SQL database

  Does anyone know of a tool that will not only convert the table structure into MS SQL from Firebird…

  DanielP

  1 replies

  13 years, 5 months ago

  By: daleto

• Increase in the size of '.mdf' file when trying to add a column to a table

  I was trying to add a new column to a table 'x' in a database 'dbx', but I failed to add the new co…

  Annee

  10 replies

  13 years, 5 months ago

  By: Annee

• TEMPDB

  I've been reading and hearing several different takes on whether you should have 1 single tempdb re…

  frank.pron

  6 replies

  13 years, 5 months ago

  By: SQLRNNR

• Backup Maintenance Plan Error

  Hi, i'm trying to set up Maintenance Plan for Backup Database but when i run the Maintenance Plan i…

  antony.otto

  2 replies

  13 years, 5 months ago

  By: SQlLogic

• Update statistics is not showing for a table.

  Hi all, In our server (SQL 2008 Standard) we are facing a problm with one table. Issue:It is having…

  Minto Minto(quendans)

  1 replies

  13 years, 5 months ago

  By: Suresh B.

• How to Create Custom System Function in SQL Server 2005

  Hi, all. I need to create a function that is available across all database without two-part name. I…

  sql v-line

  1 replies

  13 years, 5 months ago

  By: bprov