SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Unable to change to SA as database owner

  Hi guys, I've encountered problem upon changing database owner from specific user to SA. Lock reque…

  gracey

  5 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Assistance w/query that pulls table name, col name, data type

  Hello Everyone! I'm working on a query to pull table name, schema, column name, data type, and fiel…

  karen.richardson

  1 replies

  12 years, 10 months ago

  By: Lynn Pettis

• Partitioned views and query compile time.

  So I've inherited a SQL Server 2005 DB with a whole bunch of tables in the following format: rank_x…

  blernsball

  1 replies

  12 years, 10 months ago

  By: blernsball

• Create database using Backup file

  Hi, I have backup file of database in my local disk. I want to create a that database in another SQ…

  VRT

  24 replies

  12 years, 10 months ago

  By: raginigupta20

• Severe Server Error with function in default value

  I've been playing around on a test database today, and one of the things I've done is created a fun…

  autoexcrement

  10 replies

  12 years, 10 months ago

  By: autoexcrement

• A domain error occurred in Sql server 2005 while updating the data

  I have created a function like the one below Create FUNCTION fn_Calc (@Lat1 Float, @Lng1 Float,…

  roshan.nc 74309

  1 replies

  12 years, 10 months ago

  By: Jason Wolfkill

• How to get these details in sqlserver

  HI all, 1. CPU and Memory Utilization for Last 15 days of DB server and Application server 2. Top C…

  naga.rohitkumar

  2 replies

  12 years, 10 months ago

  By: Gail Shaw

• NO SMTP Server Available

  I am in an environment that does not have an SMTP Server. We are using SQL 2005 on Server 2003. I…

  jayoub

  1 replies

  12 years, 10 months ago

  By: Lowell

• could not start the SQL Server(MSSQLSERVER) Service on local computer.

  Hi, I installed sql server 2005 on my machine i keep getting the following errors......when i start…

  raym

  14 replies

  12 years, 10 months ago

  By: sayedcom

• Find number of weekdays(Monday,Tuesday..) between two dates monthwise

  Hi All, I need to find average week day count on a monthly basis. My table has the creation date as…

  nikhil_ambaye

  8 replies

  12 years, 10 months ago

  By: ChrisM@Work

• Service Broker Issues - SQL 2005 Enterprise Edition 64 SP3

  Hello, Before to start I just resume actions I made to reduce msdb size (earn space on c: volume). …

  ERIC CRUDELI

  1 replies

  12 years, 10 months ago

  By: Sean Lange

• JOIN on MANY to one and ensuring the JOIN is correct

  Hi All I have a particularly problem with a join which is driving me insane, it involves basically …

  pnr8uk

  7 replies

  12 years, 10 months ago

  By: pnr8uk

• this query is taking time for execution how to trouble shoot

  HI every one application team informed that this query is taking more time than normal so from my e…

  naga.rohitkumar

  1 replies

  12 years, 11 months ago

  By: Jeff Moden

• Writing text files as Unicode

  Hi, I have this stored procedure (attached), that writes a semi colon delimited text file with colu…

  sqldriver

  13 replies

  12 years, 11 months ago

  By: Orlando Colamatteo

• Japanese characters as question marks

  Hi, I'm having a bit of a strange issue with Japanese characters. 1) They're in the Excel file I'm…

  sqldriver

  18 replies

  12 years, 11 months ago

  By: sqldriver