SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Select Query

  Dear All, I have a select query,that select all data from ‘policy’ table based an ‘agentid’. Select…

  gsavitha

  2 replies

  14 years, 7 months ago

  By: Sean Lange

• sysjobhistory with a run_status of 4

  Hi All Just looking through sysjobhistory as our 3rd party is reporting job failures even though th…

  Ant-Green

  3 replies

  14 years, 7 months ago

  By: Ian Scarlett

• xp_deletefile on linked server problem

  Hails, I'm having a problem with the procedure 'master.dbo.xp_delete_file' and I'm receiving the fo…

  arsenaultk9

  2 replies

  14 years, 7 months ago

  By: arsenaultk9

• Dynamic sql string not formatting correctly

  Hi All, I have dynamic sql where the @sql variable is defined as nVarChar(MAX). I am passing i…

  ramadesai108

  3 replies

  14 years, 7 months ago

  By: Sean Lange

• Developer has permission issue when attempting to specify any other SCHMEA name except the default DBO schema.

  I created a Login for a Developer on a Server and Granted him dbcreator and bulk admin but he can c…

  Welsh Corgi

  6 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Using MASTER..XP_CMDSHELL to run store proc

  Hi, Using the command prompt we use 1. Open Run window 2. Type SQLCMD enter 3. Type USE TestDB ente…

  rhd110

  3 replies

  14 years, 7 months ago

  By: Jared

• Dispaly percentage while rollup the columns in SSAS

  Hi Folks, I have a cube which contains 8 dimensions and 5 fact tables.scenario here is . I have att…

  sabarichandru

  1 replies

  14 years, 7 months ago

  By: subah.ramakrishnan

• Stored proc to retrieve 1 value 20% of the time, another value 70%, and another 10% during a specified time range

  I want to design the tables and a stored proc that will facilitate the retrieval of a phone number …

  Jared

  4 replies

  14 years, 7 months ago

  By: Jared

• Truncate log question

  Hi all We have restored a large DB into a DEV environment and changed the recovery model to simple.…

  Kwisatz78

  2 replies

  14 years, 7 months ago

  By: Kwisatz78

• FTP From File Share (or SSRS) via SQL

  We generate a report file to a file share automatically via an SSRS Report Manager subscription, th…

  Rob-350472

  5 replies

  14 years, 7 months ago

  By: sturner

• Windows Auth with no SysAdmin Users! HELP

  Hi all, We have been having a AD clean up and someone has deleted the Windows Group with SysAdmin …

  Staggerlee

  6 replies

  14 years, 7 months ago

  By: Staggerlee

• Triggers to be avoided? ....

  The below observation is more a comment than a question, but I invite any remarks. As a newcomer to…

  raotor

  12 replies

  14 years, 7 months ago

  By: Gail Shaw

• TVF in recursive part of CTE

  Hi, I have checked that a TVF doesn't work in recursive part of cte. Is this a limitation or syntax…

  rhd110

  2 replies

  14 years, 7 months ago

  By: rhd110

• Report Exporting to CSV(Comma seperated) Issue in 2008

  Hi All, Have you ever noted down the difference when you open a CSV file in Excel which is exported…

  Srinivas Dasari

  2 replies

  14 years, 7 months ago

  By: WILLIAM MITCHELL

• Can locks in a table block other tables

  Hello, I have one table which is highly frequently used [usually insert statement within every few …

  sqlnaive

  11 replies

  14 years, 7 months ago

  By: Gail Shaw