SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Sql query to get recursive count

  I have 2 tables in the database, UserMast and ProfileMast. UserMast ( UserID uniqueidentifier, …

  ajay.contact

  7 replies

  13 years, 10 months ago

  By: ajay.contact

• backup index

  how to backup the sql 2008 database indexes? thanks

  HBK_4700

  2 replies

  13 years, 10 months ago

  By: Perry Whittle

• Hierarchy/Tree Structure Query

  Hi, We have an ERP which is being used by a school. I have a requirement where there is a page in w…

  vinu512

  5 replies

  13 years, 10 months ago

  By: vinu512

• Validation methods?

  In your experiences, when you get the results of a query, how and who determines if the results are…

  David Lester

  13 replies

  13 years, 10 months ago

  By: Dwain Camps

• Need help finding script to truncate log in SQL Server 2008

  Hi All- I used to have this script but can't find it now. I have a database in simple mode that ha…

  Rogman

  15 replies

  13 years, 10 months ago

  By: SQLRNNR

• Windows could not start SQL Server(Error: 1067 the process terminated unexpectedly).

  Hi.....guys........ Error: 2012-07-10 00:06:57.73 server Microsoft SQL Server 2000 - 8.00.760 (…

  Saggy

  5 replies

  13 years, 10 months ago

  By: SQLRNNR

• How to Suppress Warning Message "join order has been enforced because a local join hint is used"

  We have stored procedures run by SQL Jobs in which there are queries that use inner loop joins. The…

  todd.soderberg

  1 replies

  13 years, 10 months ago

  By: sestell1

• Urgent help needed, Max Growth by DB

  Urgent help needed, Thanks in advance. Can I get T- SQL Script which displays for all the databa…

  anzz

  29 replies

  13 years, 10 months ago

  By: SQLRNNR

• The server principal "" is not able to access the database "" under the current security context.

  I'm getting this error now when I'm installing an ASP.NET MVC application with a built-in installer…

  kahanu14

  4 replies

  13 years, 10 months ago

  By: kahanu14

• Set up odbc connection to SQL

  There are about 10 users need to connect to SQL database using Access. How to run a script to do it…

  adonetok

  5 replies

  13 years, 10 months ago

  By: Sean Lange

• Execute as

  I have a stored proc coded with Execute As SomeValidCRMUser. This stored proc last step is to issue…

  MissyDaisy

  10 replies

  13 years, 10 months ago

  By: MissyDaisy

• stored procedures not saving temp or local file

  When I execute this: Select * into #tbl_casualty From Openquery(oracletable, ' select LPAD(W…

  cljolly

  4 replies

  13 years, 10 months ago

  By: justmohit

• sys.columns X syscolumns

  Hi everybody, I will create an application to list the columns of my database, what the difference …

  JoseACJr

  2 replies

  13 years, 10 months ago

  By: Jack Corbett

• tempdb size and maxsize

  My live server tempdb size and maxsize are almost equal now. Does it mean that sql has no more spa…

  S_Kumar_S

  2 replies

  13 years, 10 months ago

  By: Jack Corbett

• Date formating problem

  Hi, I am trying to do date conversion but with no luck. I want in the format YYYY:MM:DD:HH:MM:SS f…

  ash.rvp1

  5 replies

  13 years, 10 months ago

  By: ChrisM@Work