SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Create multi column view from single column data

  I have the following result from my SQL query: EventID P_NumPN_NameCount1PN_Name …

  GTJohnson73

  17 replies

  12 years, 8 months ago

  By: Sean Lange

• Converting Non-Spatial Data to Spatial Data

  I have been looking in my SSRS book and online and can not find a clear answer to this question. I …

  thomashohner

  6 replies

  12 years, 8 months ago

  By: thomashohner

• Strange Job Slowdown 30 secs to 30 minutes

  I have a job that runs 22 times a day. Four of those times, it is kicked off by another job. We rec…

  Sioban Krzywicki

  50 replies

  12 years, 8 months ago

  By: Erland Sommarskog

• Triggers on Tables

  Is there a way to turn a table trigger off in a stored procedure, then turn it back on after it ski…

  cdl_9009

  7 replies

  12 years, 8 months ago

  By: ScottPletcher

• VMWare administrator moved my server without telling me

  Good Morning, How would you be able to determine that the server that houses your SQL Server has be…

  Mike Hays

  6 replies

  12 years, 8 months ago

  By: Mike Hays

• Sql Server 2008 R2 Partitioning

  Hi, I have a Sql Server 2008 R2 instance and in one of my databases I have a table which has >10…

  Chris Kitchen

  11 replies

  12 years, 8 months ago

  By: Chris Kitchen

• Do we have any chance to remove a physical file that has data

  Hi All, Do we have any chance to remove a physical file that has data... Can any one please suggest…

  mohan.bndr

  1 replies

  12 years, 8 months ago

  By: starflyer

• Select statement can't modify

  I ran a select statement like below in query window but it can't be modified. select * from Order I…

  adonetok

  14 replies

  12 years, 8 months ago

  By: adonetok

• Email notification in job manager

  I want to send an email notification in job manager as following instructions but there is no email…

  adonetok

  1 replies

  12 years, 8 months ago

  By: s_osborne2

• Is overpunch amenable to cross apply?

  I have a file that needs to have its contents converted to money from overpunch characters. I start…

  drew.georgopulos

  18 replies

  12 years, 8 months ago

  By: Dwain Camps

• LIKE Operator

  Hi, I want to display list of tables , which having "_" in the part of table name? Thanks. RR

  PRAMANA.DBA

  6 replies

  12 years, 8 months ago

  By: kapil_kk

• SQL Native Client Configuration

  Hi All, I would like to know in SQL ...If we change the order of the Protocols in the SQL Native Cl…

  mohan.bndr

  1 replies

  12 years, 8 months ago

  By: Koen Verbeeck

• Linked Servers with service account - Error 18456 state 6

  Hi guys, I have a central server and n other servers that are collected on using linked server conn…

  Dird

  4 replies

  12 years, 8 months ago

  By: Dird

• SHRINKDATABASE killed but rollback appears to be stuck

  Hello...I've found several useful tips/tricks on this site over the years, and am hoping someone ca…

  mpizzolo

  3 replies

  12 years, 8 months ago

  By: Gail Shaw

• After killing my process in SQL erver its showing hung stage(Killed/Rollback) from 2hours. When i tryed to kill the process from Windows its showing 2 process with same name. Please let us know how to identify which process need to be kill.

  Hi All, Today I got a request to kill SSIS process which SID is XXX. After killing my process in SQ…

  rajeshjaiswalraj

  2 replies

  12 years, 8 months ago

  By: Gail Shaw