SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• I need to change the package

  Hi all, I have a package which is configured and scheduled in sql agent .. Now i need to modify the…

  srilu_bannu

  4 replies

  14 years, 11 months ago

  By: emily-1119612

• Cant delete table due to lock issue

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Table …

  Digs

  1 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• SCHEMABINDING question

  If I just change the data type of a field in a table, does that break the schemabinding on a view t…

  Ray Cacciatore

  6 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• Scan for percentage differenced

  Please down load text file attached 'TestData.txt', set up table. GO CREATE TABLE [dbo].[DIM_Data_…

  Digs

  4 replies

  14 years, 11 months ago

  By: UMG Developer

• Losing dependencies when changing table schema

  I need to change the data type of one of my table fields from MONEY to DECIMAL(20,5). Before making…

  Ray Cacciatore

  2 replies

  14 years, 11 months ago

  By: Ray Cacciatore

• Need to split and combine some data in a query

  I have a query that is pulling data from various tables to use in a variable print program. So, I …

  Kit G

  27 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• String Parsing

  I have a string similar to C:\Documents and Settings\file.xls I need to write a query to find the s…

  dave.molyneaux

  8 replies

  14 years, 12 months ago

  By: ColdCoffee

• Merge replication and subscription configured, by can't modify subsciption tables

  I have set up database ReplTesting to replicate a publication of three articles (Production.Locatio…

  cranmer.mark

  12 replies

  14 years, 12 months ago

  By: Brandie Tarvin

• Full backup file extension question

  I took a full database backup using the GUI: Right click my database -> Tasks -> Back up I ch…

  SQLDCH

  14 replies

  14 years, 12 months ago

  By: SQLDCH

• collation issue

  Hi friends, I'm changing the column collation for some tables manually, I'm able to change the col…

  newbieuser

  2 replies

  15 years ago

  By: Brandie Tarvin

• What Table(s) Store the DBMAIL Info

  Hi Folks when using: EXEC msdb.dbo.sp_send_dbmail it says "Mail queued" Can someone tell me where t…

  JC-3113

  4 replies

  15 years ago

  By: JC-3113

• Maint Plan Issues With Disabling Databases

  Hi Folks can someone please tell me why the heck SQL Server tries to execute a Maint Plan on Databa…

  JC-3113

  10 replies

  15 years ago

  By: JC-3113

• Combining the use of ROWNUMBER() for paging, with a search result record set

  Hi, Come across two elegant solutions which combined will give me paged search results. One using t…

  pixelene

  4 replies

  15 years ago

  By: WayneS

• Log Backup Frequency and Max Data Loss

  Hello all, I've just read a post by one of the many prolific and helpful responders in this forum. …

  SteveBell

  7 replies

  15 years ago

  By: Gail Shaw

• How Do You Delete A Maint Plan Task Connection No Longer In Use

  Hi Folks I have some Maint Plans in SSMS that have more than one available Connection for a Task in…

  JC-3113

  8 replies

  15 years ago

  By: JC-3113