SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Help with NTILE

  I am using NTILE to split my result set into smaller chunks to pass to SAP BAPI which can only hand…

  MissyDaisy

  3 replies

  15 years, 10 months ago

  By: MissyDaisy

• How to protect a table

  I've a table in my database. Many people use that table for insertion and updation. How do I protec…

  renuukamutyala

  4 replies

  15 years, 10 months ago

  By: Ross McMicken

• create files with bcp

  Hi, I have a table that have rows. With it must create various files in txt. How can i create vario…

  Helical Johan

  2 replies

  15 years, 10 months ago

  By: Helical Johan

• SQL Server 2005 SP2 Developer Vista-Win7 upgrade

  Hello, I'm currently running SQL Server 2005 SP2 Developer x64 on a Windows Vista Ultimate x64 mach…

  Dom Horton

  2 replies

  15 years, 10 months ago

  By: Dom Horton

• Trouble with a GROUP BY

  EDIT: Nevermind. I figured it out. http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleas…

  LightningFingers

  1 replies

  15 years, 10 months ago

  By: gorthog

• Pulling first word from a text field with SSRS query

  Hi Everyone, I'm trying to figure out if there is a way to have SSRS pull the first word from a tex…

  iklektic

  3 replies

  15 years, 10 months ago

  By: iklektic

• Create SQL job in SQL SERVER 2005

  I am new to SQL Server 2005 and I want to schedule one .exe file with scheduled job of SQL Server. …

  Tushar Bedekar

  4 replies

  15 years, 10 months ago

  By: homebrew01

• New Code not running

  I have updated a procedure to change from MAXDOP 0 to MAXDOP 2. It has been in production for over …

  andegre

  12 replies

  15 years, 10 months ago

  By: Gail Shaw

• Is there a T-SQL command that will report drive fullness without having to have access to xp_cmdshell or the server console?

  We use SQL Server 2005 in a locked down shop, and xp_cmdshell is turned off by design. The DBAs do …

  shew

  4 replies

  15 years, 10 months ago

  By: Old McDonald

• Replication Monitor

  Hi people. I have this problem. During my test i create some pubblication in my sql server. Now, so…

  Alberto.Omini

  5 replies

  15 years, 10 months ago

  By: Ian Scarlett

• script copying tables From to server on other machine.

  Is it possible to script operation of copying table from a database on a Sql Server to other Sql Se…

  mazenob

  3 replies

  15 years, 10 months ago

  By: homebrew01

• sp_send_dbmail question

  I have a question regarding sp_send_dbmail. I've just used it for the first time and everything wo…

  William Plourde

  4 replies

  15 years, 10 months ago

  By: Jack Corbett

• Streams VS Sparse File

  Can somebody help me to understand, is there any difference between "SPARSE FILE" and "Streams", ar…

  Subhash-63067

  2 replies

  15 years, 10 months ago

  By: Gail Shaw

• How to hide owner name in object explorer ?

  SQL 2005 Management studio, Object Explorer tree is showing owner name in front of the objects. Is …

  Veronka

  5 replies

  15 years, 10 months ago

  By: pef

• Reading HTML file stored as VARBINARY(MAX)

  Hi, We have a table that stores html email templates in varbinary(max) column. We are inserting the…

  sabyasm

  2 replies

  15 years, 10 months ago

  By: sabyasm