SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• MAX vs TOP question

  Hello I have a query that it's built in runtime, i need to get the greatest date from a previous to…

  rootfixxxer

  15 replies

  14 years, 8 months ago

  By: Johan Bijnens

• Migrating Databases from SQL 7 to SQL 2005?

  I would like to migrate our sql server 7 databases, dts pakages, jobs, logins to SQL 2005 Enterpris…

  apat

  4 replies

  14 years, 8 months ago

  By: Perry Whittle

• concatenating question

  Just a quick question about concatenating. I need the results from the User Role row to be concaten…

  jess.

  6 replies

  14 years, 8 months ago

  By: jess.

• calling stored procedure in a cursor

  Hi All, I have created a stored procedure which finds dependent objects on a particular table. I wa…

  anjaliv

  14 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• Can you attach a db in "NORECOVERY" mode after it has been detached in "RECOVERY" mode?

  Thanks! -David

  davidsalazar01

  2 replies

  14 years, 8 months ago

  By: davidsalazar01

• Report on sysjobs, sysjobhistory

  Hi I want to create a report that not only show me what jobs are running, failed and so on, but al…

  @DJ

  12 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 - Error Message

  Hi Guys, Can you guys assist me with this error message please. Failed Virtual Allocate Bytes: FAIL…

  sun_kuang

  2 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• Need Help with view or stored proc

  Hi Guys, I have the following requirement: My main table is called File. This is the structure: CRE…

  niteshrajgopal

  5 replies

  14 years, 8 months ago

  By: Abhijit More

• Change Default owner 'Username' to 'dbo'

  Hello friends, I have created a database with name caspa_in_caspa that is associaded with a user ca…

  shubham.saxena67

  4 replies

  14 years, 8 months ago

  By: shubham.saxena67

• Memoery Allocation For columns Which we Declared in Table Design

  Morning Everybody, I have a doubt regarding the memory allcation in Sql server tables designing.. …

  SqlSpider...

  3 replies

  14 years, 8 months ago

  By: Gail Shaw

• varchar(max) problem with row length

  I have a database which has two varchar(max) fields to hold longer text blocks. I know this is wor…

  wayne.mcdaniel

  1 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• backup timing out on log file

  A recently functioning backup script stopped working and started timing out on a log file. All the …

  daninmanchester

  4 replies

  14 years, 8 months ago

  By: daninmanchester

• One database or more databases

  I'm migrating our SQL server from version 2000 to 2008 R2 Standard Edition. On 2000 we have 10 data…

  dussan

  3 replies

  14 years, 8 months ago

  By: Pam Brisjar

• Comapare Datetime type

  Hi.. How to compare datetime type with NULL.. i just want to fetch records , only compare wit…

  sh_kishor

  2 replies

  14 years, 8 months ago

  By: Johan Bijnens

• delimiter in a variable

  Hi All, In the following query, SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysob…

  anjaliv

  7 replies

  14 years, 8 months ago

  By: anjaliv