SQL Newsgroups: Microsoft SQL Server Administration

Please help, database will not truncate free space at end of file

fnadal via SQLMonster.com - 16 Sep 2006 5:26 PM - 4 messages

I'll explain the process, then I'll explain the problem. SQL Server Enterprise Edition, Windows NT, SP2 We have a main database server A, and a report server B. This is all done through Enterprise Manager: We reindex database A, which causes it to grow in size, backup the ...

2000 to 2005: The query processor could not produce a query plan

lindseyc5 - 16 Sep 2006 3:50 PM - 2 messages

Hi, We are trying to upgrade from 2000 to 2005 and get the following error message when we try to execute an insert statement against certain tables in a query window. The query processor could not produce a query plan ...

Restore master backup of 2000 to 2005

Hitesh - 16 Sep 2006 6:13 AM - 5 messages

Just wondering has anyone ever tried to restoring master db to SQL 2005 from backup of SQL 2000? This might sound stupid but just wondering. Thank you, hj ...

Maintenance Plan job order

Victor D - 15 Sep 2006 10:16 PM - 2 messages

What's the preferred order for the following jobs: Integrity Check Data Optimization Complete Backup The databases I'm now administering are set up to perform the Integrity Check, followed by the Data Optimization which is barely 25% done when the ...

Help With SQL Query

Charles A. Lackman - 15 Sep 2006 8:58 PM - 3 messages

Hello, With the following table how would I create a query that would return all rows whos EndDate minus StartDate is more than 28 Days. TableName: Customers ID - Integer CustomerID - VarChar StartDate - Date EndDate - Date Table: ID CustomerID StartDate EndDate ...

SSIS text file manipulation

jeff - 15 Sep 2006 8:42 PM - 2 messages

Running into an issue where I'm reading in text file to be loaded into an Oracle table. The file is provided by a customer, so I can't control its format, so wondering short of writing some script is there ...

DBCC ShrinkFile not shrinking my file

jhoge123 - 15 Sep 2006 8:21 PM - 2 messages

I have a lot of unused space in my data file for my Sql Server 2005 database, but if I try to get rid of it the mdb file does not get any smaller. I tried to use dbcc shrinkdatabase (dbname) and dbcc ...

File numbers in backup files

SalamElias - 15 Sep 2006 8:19 PM - 3 messages

When i backup, everyday, A db to the same file(using noinit option), how can I know the nmber of each file in order to be able to restore the the one I want using with file = 1 or 5 or 6. Is there a sp or a sus table ...

scramble ssn with sql server

dmalhotr2001 - 15 Sep 2006 8:17 PM - 4 messages

Hi, I'm trying to scramble the ssn#s within our database. I would need a 9 digit number to be converted into another 9 digit number in our dev database. Example #1: ssn: 123456789 converts to 987654321 Also there is a catch, there is a possibility that there could be ...

scramble ssn with sql server

dmalhotr2001 - 15 Sep 2006 8:11 PM - 2 messages

Hi, I'm trying to scramble the ssn#s within our database. I would need a 9 digit number to be converted into another 9 digit number in our dev database. Example #1: ssn: 123456789 converts to 987654321 Also there is a catch, there is a possibility that there could be ...

Need help to restore master database

circulent - 15 Sep 2006 7:31 PM - 6 messages

We backed up our SQL 2005 DB (master.bak, msdb.bak, etc.) and now we have problems restoring. First we logged on as a local admin, we tried to change to change to single-user mode by stopping the MSSQLSERVER service (logged as ...

modifying an exisiting stored procedure

Brian L - 15 Sep 2006 7:23 PM - 3 messages

In Ent Mgr 2000, to modify a stored procedure it was plainly simple. But in SQL 2005, when I click modify, make my change then click save, i'm prompted to save it as a new file. What gives? ...

Manual backup works, automatic scheduled doesn't

Sarah Baker - 15 Sep 2006 4:46 PM - 3 messages

I am not able to perform automatic scheduled backups of one of our databases. This database is called StarTeam_stardraw60_db and is located within VSDEV\STARTEAM instance of MS SQL server. I also tried to perform an automatic backup of another database within ...

Create assembly problem on SQL2005

artek - 15 Sep 2006 4:01 PM - 7 messages

Hello, when I try to create an assembly: Create assembly LibSql FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' WITH PERMISSION_SET = External_Access I got the following error Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL server to use CLR integration ...

Updating a colum from another database

John Steen - 15 Sep 2006 3:40 PM - 5 messages

I have two databases (DB1 and DB2) on two different servers. Both have identical schemas but different data. There is a string of data in a varchar column of DB1 that I need to add to the corresponding column in DB2. ...

Need help in setting up row level security ...

Me - 15 Sep 2006 3:39 PM - 5 messages

I would like to implement row level security. Can someone help me please? I have a situation wherein a Project is created as confidential. Only a few people should be able to access it. I have this information in another table ...

unable to backup ...

Me - 15 Sep 2006 3:30 PM - 3 messages

I am trying to backup a database using Enterprise manager -> Tools -> Backup option. I enter the backup filename, etc. and run. Within no time I get the message window - "backup completed successfully". But the backup file is only 1780K. ...

Replicationtables with diff schema

mecn - 15 Sep 2006 2:49 PM - 4 messages

Hi, Thanks for all the reponses yesterday regarding replication tables of diff schema. I understand now. Now we have 3 tables out of 56 in diff schema. I need to replicate the whole databse. What should I do? replication all ...

Slower dual-core or faster single-core CPU

vlad - 15 Sep 2006 2:45 PM - 8 messages

I'm in the process of ordering a new 4 CPU 4GB RAM box for running SQL Server 2000 (upgrading to SQL Server 2005 next year) and debating between Dual-Core Xeon 7020 2.67 GHz ( 667 MHz ) - L2 2 MB ( 2 x 1 MB ) ...

Increasing writes by lazy writer and threads

DaveF - 15 Sep 2006 1:24 PM - 13 messages

My SQL Server 2000 database does transaction processing. I have observed transactions taking longer than expected on a periodic basis, say every 10-30 minutes depending on load. It appears that the CHECKPOINT process is writing out a large amount of data on those ...

sp_spaceused showing 80 gig of unallocated space

zomer - 15 Sep 2006 1:17 PM - 2 messages

Hi, I have a large 95 gig DB. When I run sp_spaceused it shows 80 gig of unallocated space. I ran it with @updateusage = 'TRUE' but i still get the same results. How can I retrieve it back? Should I use DBCC ...

1,2,3 SQL Query

A388517 - 15 Sep 2006 12:05 PM - 3 messages

table: users columns: IsOwner, IsAdmin, NetID Query: create a fourth column As Logintype when, IsAdmin = 'y' insert a "3" IsOwner = 'y' insert a "2" neither IsOwner or IsAdmin = 'y' insert a "1" both IsOwner and IsAdmin = 'y' insert a "3" ...

Indexed view and database options

jcvoon - 15 Sep 2006 11:03 AM - 5 messages

Hi: I'm using SQL2000 Ent, and I've created a indexed view in my database, my question is: Is it ok to set the following options at database level (By default all is OFF, correct me if I'm wrong) ? ...

Differential backups and transaction logs.

bungy - 15 Sep 2006 9:35 AM - 3 messages

Hello. it would be great if someone could help me. I have a large database (18GB) which is being backed up on the Monday of every week. Transactions logs are taken every 15mins during the day and then a diff at the end of the day. My question is this, if a take ...

How to set a photo path when creating table

jyetying - 15 Sep 2006 8:50 AM - 3 messages

Hi all, I am doing a project which need to use Microsoft SQL Server 2000 as my database. Now, I am creating a table, that I need to put in a photo. So, I am facing a problem of setting the photo path. Can u all give me ...

How to change SQL Server 2005 Server side Collaction?

ABC - 15 Sep 2006 8:34 AM - 2 messages

How to change SQL Server 2005 Server side Collaction? As the previous staff installed SQL Server 2005 using invalid collaction, now, We want to change the server side collaction to correct one. How should I do? ...

Limit number of backups saved

Still Love VB6 - 15 Sep 2006 7:24 AM - 4 messages

Hi All Sorry if this question has been asked before...I did look for it. In 2000 you could stipulate to keep backup copies for n days(or any other period) We are used to backing up the transaction log every (eg) 15minutes and ...

Mirroring/Replication

T Morris - 14 Sep 2006 11:06 PM - 2 messages

We need to move several read-only operations off a 1TB database yet still maintain access to timely data - perhaps 1 hours latency is acceptable. My thought is create a mirror then use transaction or merge replication to create the database clones - we may need two or three. ...

SQL Server 2005 - replication jobs

tootsuite - 14 Sep 2006 11:05 PM - 3 messages

Hello, SQL Server 2005 question I am wondering if anyone knows if it's necessary to manually set up jobs to re-start replication jobs (such as REPL-Distribution and REPL -LogReader) in the event that the server is rebooted or the SQL Agent ...

SQL2005 Ent Saving Diagram reports 'isBusy'

Robin Ramsey - 14 Sep 2006 10:35 PM - 3 messages

Problem: When saving a database diagram about 50% of the time the SqlServer Mgmt Studio locks up. In the lower right hand corner the animated gif shows it's trying to save. When you hover on the SqlServer icon the tooltip indicates ...

Migrate from Sql Server 2005 to Sql Server 2000

Massa Batheli - 14 Sep 2006 10:07 PM - 8 messages

We are moving from 2000 to 2005 .And I have to come up with an escape route if after a week or two it is decided performance/other issues are worse. ..SSIS transfer sql server objects does not cut it for some unknown ...

SQL Server 2005 Express SP1 running out of memory on a VPS

craigkenisston - 14 Sep 2006 10:03 PM - 3 messages

Using SQL Server 2005 Express SP1 on x32, with 320MB of RAM. Hi, I have one of those VPS hosting accounts, with a small amount of disk space and ram. Specifically 2gb of space and 320MB of free RAM for my ...

Full-Text Catalogs

jet007 - 14 Sep 2006 8:41 PM - 3 messages

I am currently having an issue with getting Full-Text Catalogs to work on SQL Server 2000. I follow all of the normal setup procedures and populate the catalog, but when I go to query it, it returns zero records. When I check to ...

SQL Server Backup - 100Gb Database

Interflex - 14 Sep 2006 8:38 PM - 9 messages

We are amalgamating several databases into one large database which will be in the area of 100Gb. Does anyone have good suggestions for backup strategies? Thanks for responses. ...

Help on sql sync

mecn - 14 Sep 2006 7:34 PM - 4 messages

Hi, all We have prod. database and test db(new version of prod, table fields changed). Production db has users connected and updating records and I need to have user transactions in production db updated in test db as well. ...

dbcc checkdb on a large table

pnat331 - 14 Sep 2006 5:40 PM - 2 messages

We have a 200 GB database with a single table that spans 36 partitions. Each time we run a dbcc checkdb on this database, the process takes close to 40 hours to finish, and in the course of doing it expands ...

Weekday DateDiff Function

mkhuber - 14 Sep 2006 5:32 PM - 2 messages

Basically this function provides functionality similar to the DATEDIFF function with the exception of only counting week days and not counting Saturdays or Sundays in the equation. Is there a more effient method to do this? CREATE FUNCTION dbo.udfDateDiffWeekDay ...

Removed mirror, still showing restoring?

Olav - 14 Sep 2006 5:11 PM - 2 messages

I have removed the mirroring from a database (synchronous). When I look at the target server, it still shows the database in Restoring mode and I'm not able to do anything with it. Why does the target server status show restoring when I have removed the ...

web

Richard Douglass - 14 Sep 2006 4:56 PM - 2 messages

Hey can someone remind of the website that works with the forums here? They have all kinds of info, code samples, etc. I have been wracking my brain and I cant remember!!! Thanks Richard ...

data modeling training

greg - 14 Sep 2006 4:52 PM - 2 messages

I thought i would post this here. not necessarily a SQL question. but kinda related. Can someone recomend a good data modeling book? Good for beginners. thanks ...

Collation

Me - 14 Sep 2006 4:39 PM - 2 messages

Is it ok to change the database collation from ...Latin1_CP1_AS to Latin1_General_BIN? Just issueing the ALTER DABASE ... command is sufficient or I need to change something else? Will I be able to retrieve case sensitive data? For ex. if the field name has ...

default database problem

Randall Arnold - 14 Sep 2006 4:03 PM - 6 messages

I did a stupid thing yesterday: I had to detach a database, and forgot it was the default for that login account (Windows authentication). After it was detached, I was unable to connect to that server through enterprise manager afterward with that login. ...

Management of SQL2000 RS

WANNABE - 14 Sep 2006 3:52 PM - 5 messages

SQL2000 sp4 is running on one server and RS is running on another with SharePoint. Does it matter if RS is running as a local system service or should it be a domain account?? Sorry if this seems like another stupid ...

Notification Services & Service Broker

Artificer - 14 Sep 2006 3:52 PM - 3 messages

I want to know what is the difference between notification services and Service Broker in SQL 2005 and how both compare to Microsoft Message Quee. Please :) ...

SQL Servers 2000 and 2005

ngorbunov via SQLMonster.com - 14 Sep 2006 3:03 PM - 6 messages

Our network guy first installed 2005 on our server. I created a database, we had some sort of issues and so decided to install 2000. I removed the db I created on 2005 and restored it on 2000 instead. Here's my problem....When I log in to query analyzer(sql 2000) using my ...

q; rounding up

JIM.H. - 14 Sep 2006 2:55 PM - 3 messages

X is a float and I need to perform x/20 and round the result up to the integer. So if result is 0.4 -> 1, if 1.1 -> 2. How can I do this with SQL? ...

Initial size for a DB

SalamElias - 14 Sep 2006 2:50 PM - 5 messages

Hi, how can I know the initial size of a database when it was created. I thionk when we look in the properties page it is the current DB size and not the initial size Thanks ...

SQL Version

George Schneider - 14 Sep 2006 2:44 PM - 3 messages

How can Itell if I have Standard or Enterprise edition of SQL 2000 installed on a server? ...

DB Mail config

Tim Kelley - 14 Sep 2006 2:34 PM - 3 messages

I am trying to setup db mail and I cannot get it to send an email. I have enabled e-mail using the surface area configurator. I went through the db mail setup wizard and entered all the appropiate info, but when I try to ...

Distributed query memory leak?

Mark Baldwin - 14 Sep 2006 2:32 PM - 5 messages

I have written an OLEDB data provider using the provider templates installed with VS.NET 2005. The provider appears to leak memory! To find the cause of the leak I have created a simple provider using *only* the templates that come with VS. So all I have done is create a new project ...

SQL Server 2005 fails to use index with simple query containing TO

Andy McMullan - 14 Sep 2006 1:48 PM - 26 messages

Hi I have the following simple query on a table: SELECT TOP 10 col1,col2,col3 FROM myTable WHERE col2 = 100 There are two indexes on the table - a clustered index on col1, and an index on col2. The table contains 700,000 rows, and 100,000 rows match the filter (col2 = ...

SQL 2000 working slow on 2003 Server

Dogan SOYKAN - 14 Sep 2006 12:39 PM - 25 messages

Hi, I have a server with the following configuration: - 4 Intel CPU, each 3.7 GHz - 6 GB of RAM - Fastest SCSI disk - Windows 2003 Server (64 bit) - Microsoft SQL 2000 Server (Enterprise Edition) This server is a brand new server with everything installed just a few ...

xp_sendmail

vinu thomas - 14 Sep 2006 9:25 AM - 2 messages

Hi xp_sendmail is failing with following error. xp_sendmail: failed with mail error 0x80040111 Our Windows server runs five SQL server instance. I have configured the MAPI profile on the windows server and specified the profile name in support service, SQL mail as well. Both SQL start up service and agent service uses ...

SSIS package for making adwentureWorksDW DB

Vicko - 14 Sep 2006 8:54 AM - 2 messages

Is Microsoft published example of SSIS package (or packages) for making adwentureWorksDW database from AdwentureWorks db? Where can I find it? Thanks ...

user does not have permission to perform this action

kalaivanan - 14 Sep 2006 3:48 AM - 3 messages

hi, i am getting the follwing error while i am trying to add a remote server. user does not have permission to perform this action what is the solution for this problem? Regards, Kalaivanan.R ...

access denied to sqlcmd line

Harry - 14 Sep 2006 1:12 AM - 3 messages

I have turned on everything this server has, to no avail. Just how does one get to the command line on SQL2005? Thanks, Harry Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\mackey>sqlcmd ...

AWE and Target Server Memory

cbrichards via SQLMonster.com - 13 Sep 2006 10:06 PM - 2 messages

Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB. This is the script we used to enable AWE and set Max Memory, essentially leaving 2GB for the OS. sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 ...

AWE and Target Server Memory

cbrichards via SQLMonster.com - 13 Sep 2006 10:05 PM - 9 messages

Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB. This is the script we used to enable AWE and set Max Memory, essentially leaving 2GB for the OS. sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 ...

Message size limitations on Service Broker?

ricolee99 - 13 Sep 2006 9:56 PM - 2 messages

Hi Everyone Does anyone know if there is/isn't a size limitation on the Service Broker. I have a remote machine running with express 2005 and I would like to send message to/from the machine in Head Office running SQL ...

xp_cmdshell bcp output redirect '>' failing w/o UNC name

Dave Engh - 13 Sep 2006 8:57 PM - 3 messages

We have a process that uses bcp to load user data in batch at night. It's been running for years using either mapped-drive naming ('c:\...') or UNC naming ('\\dengh\...'). We redirect the bcp output to a file for review ...

CURRENT_USER issue

Kyle K. - 13 Sep 2006 8:44 PM - 3 messages

I've inherited Database for a Web Application (with no support) that makes heavy use of the following function, at least in the report views that have been defined: ALTER FUNCTION [dbo].[fn_UserIsSysAdmin] () RETURNS bit AS BEGIN DECLARE @UserId int ...

2005 install - Can you specify a directory for the data and one for the logs?

Paul T. - 13 Sep 2006 7:04 PM - 4 messages

Hi, I am setting up a template.ini file that I am going to use for some unattended installs of SQL Server 2005. I believe using the 'INSTALLSQLDATADIR' I can get the system databases setup with their data files and log in the directory I specify. Is there a way to ...

Cannot access file location

TLuebke - 13 Sep 2006 6:51 PM - 4 messages

I'm in an academic setting and we have students log into an SQL 2005 box. Using SQL authentication and individual accounts. They can back-up dBs that they create but when going to restore they get an error. "C:\Program Files\Microsoft SQL Server\MSSQL\Backup ...

Replicating Linked Servers

Rob - 13 Sep 2006 6:38 PM - 3 messages

Hi, Is there a way to script linked servers so that it can be created on another server? TIA Regards ...

How can I 'copy' a SQL Express database to SQL Everywhere?

John Austin - 13 Sep 2006 5:40 PM - 8 messages

Now that SQL Everywhere can be used on the desktop, how can I create an 'Everywhere' version of a database that I have set up in Express or 2000? Clearly, as' Everywhere' is a subset, the mobile version may not be ...

SQL 2000 & SAN Performance

XP User - 13 Sep 2006 5:26 PM - 2 messages

Hi, I've been reading a number of posts and articles that talk about various different types of performance related items with SAN solutions and SQL. My situation is that we have large several hundred databases/servers that range in size from 20GB to over 120GB. Those databases hold long ...

SQL 2000 Reporting Service Management ??

WANNABE - 13 Sep 2006 5:25 PM - 4 messages

When reporting service was first installed it was installed to use the SQL sa login, and I need to change that, Can someone please direct me to a good starting place, tell me what to look for. PLEASE... I am having a very ...

DBCC Error

Richard Douglass - 13 Sep 2006 4:45 PM - 3 messages

Anyone seen this before? What causes it? How do I fix it? Thanks!! Richard DBCC results for 'ivTransitItems'. Msg 2537, Level 16, State 24, Line 5 Table error: object ID 295528682, index ID 0, partition ID 19367767703552, alloc unit ID 19367767703552 (type In-row data), page (1:22320), row 0. The ...

sql agent job

mecn - 13 Sep 2006 4:35 PM - 6 messages

Hi, what is the max number of words in sql job/step. When I copy over code. It cut over. Not sure what is the maximum? Thanks ...

updating top 10 rows

Ton - 13 Sep 2006 3:55 PM - 2 messages

Hi! What statements do I need to run if I want to change the value in one of the columns for just top ten rows? Thank you, ...

Copying database from 2005 -> 2005 - loses things like identity columns.

UJ - 13 Sep 2006 3:40 PM - 4 messages

I am copy a database from one server to another and when I do, I lose all of my identity column specifications. The column is still there, but it's no longer an identity column. Am I missing something? TIA - Jeff. ...

Shrink database SQL 2000 with minus sign in databasename

pvuvb - 13 Sep 2006 3:19 PM - 4 messages

Hello, i want backup my log files and shrink my database, but it doen't work. the database name is named : "greet-levelcom" Because there is an - sign in the database name, sql explorer give an error when shrinking the database. ...

Weird SQL Server problem

Dominic30 - 13 Sep 2006 2:14 PM - 4 messages

Hi, Since yesterday, I experiment a problem connecting with a SQL Server 2000 database. The DB is located in a server (Win2000 Server). Our software (designed with VB.NET 2003) connect to this DB for the production, is installed on a WinXP SP2 IBM PC. But now, I get the ...

Running SSIS as an Agent job using a proxy

Asher F. - 13 Sep 2006 1:31 PM - 2 messages

Hello, I built a simple SSIS package using BIDS. The package does a backup of a DB to a network share. I imported the dtsx file into SQL Server using SQL Server WB (connected to the SSIS server) I created a SQL Agent job to run the SSIS package. ...

grant permission to all objects

kalaivanan - 13 Sep 2006 1:05 PM - 3 messages

hi, how should i grant permission to all objects in a database for an existing user. R.Kalaivanan Kalaivanan. ...

DBCC showcontig

jumblesale - 13 Sep 2006 11:26 AM - 4 messages

Hello, I have a very fragmented database and am running dbcc dbreindex but getting a very odd issue. When running DBCC SHOWCONTIG before and after reindexing the tables, there is no difference in the statistics. The scan fragmentation levels (in fact all of the statistics) are exactly the same. ...

SQL 2005: SP_Attach_DB no longer works correctly

Catadmin - 13 Sep 2006 10:56 AM - 6 messages

I'm confused and a bit frustrated, so any help would be appreciated. I have a job which takes a recent backup of production and restores it on our Dev server. Part of the job detaches the "old" dev database, renames the ...

Data files & Log Files in SQL2000

Ivan - 13 Sep 2006 9:02 AM - 8 messages

Dear all, I have a question of the Data files & Log Files in SQL2000. Is that once someone got the data files and log files of the database, and he had a SQL server 2000 installed, he can use sp_attach_db command to ...

Authenication Mode

Brett I. Holcomb - 13 Sep 2006 3:18 AM - 3 messages

I've been reading on the authentication modes - Windows and mixed (sql server). I'd like some comments on the pros and cons of each and which most people use. As I understand it with Windows your windows login is used to get you into ...

Help a Newbie Out... SQL Learning...

RompStar - 12 Sep 2006 10:49 PM - 6 messages

I am attanding school for Database Administration, still taking all the English Classes and other requirements, but soon that will be over with. I wanted to get a head start with SQL, I installed SQL 2005 Server Standard Edition, not the Enterprise one. ...

TSql code question

mecn - 12 Sep 2006 9:05 PM - 3 messages

Hi, I need to automate a sql job by using t-sql. Here is the code, declare @intcounter int declare @maxcount int declare @intct int declare @RestoreDevice varchar(100) select @RestoreDevice1 ='\\backup2\SqlBackup\GrtPlnDb\LogAppend\AccT_log.bak' select @RestoreDevice2 ='\\backup2\SqlBackup\GrtPlnDb\LogAppend\S_lognd.BAK' ...

Monitor database file size

Tim Kelley - 12 Sep 2006 8:55 PM - 2 messages

Is there a best practice for monitoring how much space is free in a database file? I can get this info for the log file using the performance monitor and send me a message when the free space is low. I don't want to have to ...

Problems with sql server 2005 linked servers

EagleGT - 12 Sep 2006 8:17 PM - 4 messages

I have just installed Sql Server 2005 SP1 on Windows 2003 SP1 I have set up several linked servers to our AS400 and they work correctly as long as I am connected to the database as "sa" via Sql Server security. ...

Getting the OUT parameter of stored proc in .cmd file.

rvivek2000 - 12 Sep 2006 8:15 PM - 3 messages

Hi, Iam new to BCP and .cmd commands in sqlserver. I want to know how to access the output parameter of stored proc in .cmd command. Based on the value i need to terminate the program. Below are the details. ...

DROPCLEANBUFFERS doesn't seem to clear cache

element533 - 12 Sep 2006 6:48 PM - 6 messages

I have a query that I'm trying to benchmark. The first time I run it, it takes 40 seconds to run. The next time I run it, it returns in 0 seconds. I execute the following: CHECKPOINT ...

trouble migrating application/database

mdwarne - 12 Sep 2006 6:19 PM - 2 messages

Hi, I am trying to move an application from one server to another. I have also restored the databse to the new server. The application uses mixed methods to access the database. In some places it uses the format 'select xyz.events', in other areas of the ...

sql statement (how to)

sampras - 12 Sep 2006 5:59 PM - 9 messages

I have a table with following sample records, How to select the desired result by sql statement, any suggestion ? Thanks in advance. Sample records number Year qty ...

Help (error 17883, under sql 2000 sp4 US)

Eric - 12 Sep 2006 5:55 PM - 2 messages

Hello, I have this error: [link] But microsoft france is close at this time and support say that they send me a patch tomorrow, ... :( If you have this magic patch you can send me (zipped) at: ...

Views and Stored Procs

bpdee - 12 Sep 2006 5:01 PM - 5 messages

Hi All, Is it possible that a stored proc can be called when creating a view? We need to create a view that calls a stored proc. In our application, we've created stored procs for generating reports. Now, we'd like to be able to ...

Profiler out of memory entries

BillyDees - 12 Sep 2006 5:00 PM - 7 messages

Hi all, Every now and then when I'm running profiler for a few hours I get the following error in the trace: Some trace events have not been reported to SQL Profiler because the server has reached its maximum amount of available memory for the ...

defrag system tables indexes

nikolakg - 12 Sep 2006 4:16 PM - 8 messages

does anyone know how could i defrag system tables indexes.. because dbcc indexdefrag or rebuild can't be used, thks ...

Clever Query

gurdipv - 12 Sep 2006 3:40 PM - 2 messages

MEMBER_ID FRIEND_ID 285 1 285 2 285 3 Member 285 has 3 friends. Table is set out as above. ...

Storing large text fields

Tzanko - 12 Sep 2006 3:32 PM - 7 messages

As we all know, there is a 8060 bytes size limit on SQL Server rows. I have a table which requires a number of text fields (5 or 6). Each of these text fields should support a max of 4000 characters. We currently ...

Migrating SQL Server 2000 to new hardware

Hitesh - 12 Sep 2006 2:30 PM - 12 messages

Hi, I have to move an SQL server 2000 to new hardware. I have read that I could do this if I can keep the same server name and same dir path. But in our case both will be different. ...

How to generate data for testing purposes

Neile Bermudes - 12 Sep 2006 2:15 PM - 3 messages

Hi all, Does anyone know of a way of generating copious amounts of SQL data? I need to test SQL LiteSpeed which we will be using for a VLDB we are going to house within the next few months and i'd like to generate a test database in the ...

Best indexes to use

jumblesale - 12 Sep 2006 2:03 PM - 10 messages

Hello, I am currently working on some database tables that are suffering from performance issues and would like some advice on which indexes are best to use. There exists a composite key on three fields out of 7 in the table and ...

reindexing job taking too long

jj - 12 Sep 2006 1:21 PM - 3 messages

I have an optimization job on a 4 way SQL 2000 box that takes 7-12 hours. The db is 150 gigs. I can't figure out why sometimes it finishes 5 hours earlier than other times. Backups are not contending with this optimization ...

Migrate SQL Server 2000 to SQL Server 2005: login

Malin Davidsson - 12 Sep 2006 12:03 PM - 4 messages

Hi! I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL Server 2005 and have had some problems with the logins and users, so I wonder which is the "correct" way to make it right =) ...

Exclude table from transaction log

DANR via SQLMonster.com - 12 Sep 2006 11:23 AM - 7 messages

Hi Does anyone know if it is possible that changes to a specific table are not recorded in the transaction log while changes to other tables are ? If yes how can this be done? Thanks Daniel ...

as DTS in MS SQl Server what is ther in oracle

sainiprakash - 12 Sep 2006 11:17 AM - 2 messages

Hi All, I used DTS tool of SQL server.using DTS we can map two tables on column by column basis. I want to know what tool is there to map two oracle tables on colum by column basis. Thanks & Regards, ...

SQLServerAgent could not be started

MYSQL - DTS - MSSQL help needed Warning novice inside!!

The Point of Active/Passive Clustering

Inserting Data in to multiple tables from a single file using SSIS package

WaitTime CXPacket

Updating Records

"cycles or multiple cascade paths" Error

License

Performance on Windows 2003 Standard w/ SQL SERVER 2000 Enterprise

SQL Server 2005 varchar(max) type

Restore user db'd on servers with different service pack levels

SQL server defrag

mirroring question

Question about backing up translog vs. full backup

SQL Query ( for a beginner)

Limits

SQL 2005 Full Backup and Active Transactions

Data Acess aplication block __How to use it on server without Microsoft Visual Studio 2003

Database Id prb !

Import CSV file into SQL TABLE

MSDE to SQL Server

MS SQL 2005 caching dependancy....

Backup of mssql server in LAN

Passing SELECTed rows to a calling SP

SQL - Disk configuration and performance.

Deployment Scripts

Upgrading SQL 2000 database to SQL 2005

how to create a database diagram

cross server update problem

Computed Column Specification

Choosing Indexes

How to : Reporting Services reports being accessed by ASP.NET, VB, VC

Running SSIS as an Agent job using a proxy

Tables and inheritence

Can someone help!