Microsoft SQL Server Administration

Create a comma delimited *field*

Julie - 5 May 2007 11:42 PM - 3 messages

Help! (again...) I have data that looks like this: date snum 5/9/2007 3064 5/9/2007 3072 ...

Who knows Sharepoint SQL Server Cluster.

Iter - 5 May 2007 4:49 PM - 2 messages

Does anybody know Sharepoint SQL Server Cluster? what is it? Thanks. ...

maintenanace

pardhiveswar via SQLMonster.com - 5 May 2007 7:44 AM - 6 messages

Hi, we have a sqlserver 2000 server which is 24*7 running .we have to do dbcc maintenanace but our management is not accepting for that. Luckly in sql2005 there is a new feature called mirroring.is it possible to ...

Question about indexed view

Lee - 5 May 2007 3:27 AM - 8 messages

guys, I have a table without any index, I have an indexed view just select all data from that table. my question is when the indexed view will rebuild the index? when I add new records to the table, or when I ...

Trying my post again: View from a table

Hassan - 5 May 2007 2:01 AM - 3 messages

If I have a table say Create table TableA ( col1 int, col2 varchar(50),col3 varchar(100)) and then create a view say Create view ViewA as select col1,col2,col3 from tableA Can i perform all the operations against ViewA that I could have otherwise ...

SQL Server 2005 does not allow connections

Joe K. - 5 May 2007 1:31 AM - 2 messages

After installing SQL Server 2005 Enterprise Edition on a Winows 2000 Advanced Server I was unable to connection to SQL Server Management Studio with the Database Engine with Windows Autentication. I received the error listed below trying to log into the Database Engine. ...

Re: Upsized primary key fields and "aaaaa"

newscorrespondent - 5 May 2007 12:53 AM - 2 messages

Beauty is in the eye of the beholder. I can get excellent performance and very good response to business change using normal forms. You fail to mention what you have replaced them with and where we can find the rational to abandon them and adopt what ever you are using. ...

alter login disabel

Joe - 4 May 2007 9:46 PM - 3 messages

hello all, When I RT click a login in management studio \script login as \create to new query window\ the script generated has ALTER LOGIN [ID] DISABLE after the creat login statement. I know the login was created enabled. ...

Grant create proc to

Joe - 4 May 2007 9:42 PM - 2 messages

Hello all, Is there a place to view in SQL Management studio that I have geranted create proc rights to a certain user? TIA ...

Regenerating a table

John - 4 May 2007 8:03 PM - 3 messages

Hi We have a table in the db that we suspect is corrupt. There are only about 40 or so records in there. What is the way to completely recreate this table so it is all clean? We also need the data that is already in the table after ...

The file "sysft_svc_category" failed to initialize correctly

pedonester - 4 May 2007 7:28 PM - 2 messages

I receive the error: The file "sysft_svc_category" failed to initialize correctly when attempting to restore a database. Has anyone ever had this problem? Thanks. ...

Log file size gets reduced

sharman - 4 May 2007 6:37 PM - 4 messages

Hi, I increased the total log file size of a database from 30 MB to 300 MB from Enterprise Manager. I check it in Enterprise manager and it shows the size as 300 MB. However, every time I do that it gets reduced to 30 MB after some ...

Restore ...

Me - 4 May 2007 5:32 PM - 3 messages

1. I backedup databases from mssql7 default pathname with default pathname onto tape. 2. I installed sql 2000 server onto another computer. 3. I restored data into the default directory that was created with MSSQL7 c:\...\MSSQL7\.... from tape created in step 1. ...

Migrating DTS packages and SQL Jobs

rgn - 4 May 2007 5:05 PM - 2 messages

Hello All, We are in the process of migrating our SQLServer2000 production server to a better hardware and Windows 2003. We have lot of DTS packages and SQL Jobs that needs to be migrated as well. I can script the Jobs and run the script ...

Backing up the Services Master Key

DBA GUY - 4 May 2007 4:57 PM - 2 messages

What happens if you don't backup the Service Master Key, or don't know where the backup is? Will this keep you from restoring the Master Database? How does this backup play in the disaster recovery? ...

Emailing results from query

Ana - 4 May 2007 4:36 PM - 3 messages

Hi, I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I also managed to create a job which would execute a query. I'd like now the sql server send to several email addresses the ...

SQL Server 2005 does not allow remote connections

Joe K. - 4 May 2007 2:14 PM - 3 messages

After loading SQL Server 2005 SP2 I received the error message listed below. Please help me resolve this error. Thanks, Error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, the failure may be caused by the fact that ...

Problem with Configuration Manager

Ken Powers - 4 May 2007 2:01 PM - 8 messages

I am experiencing a frustrating error when I try to change the SQL Server service account using SQL Server Configuration Manager. I created a local Windows account for the SQL Server service. I then opened Configuration Manager and tried to assign the account to the service. When I click ...

Table Partitioning vs. RAID Technology

Leila - 4 May 2007 11:59 AM - 9 messages

Hi, I'm wondered that which strategy (only in terms of performance) is better: Suppose that you have 5 disks on your SQL Server. 1 goes for the Log File, but for the other 4 disks, you can choose RAID 0 (Striping) that has great ...

finding a string somewhere in the MS SQL user tables

Chiken Koma - 4 May 2007 10:39 AM - 8 messages

Hi, I have an application which shows a certain piece of data on the screen, but I do not know which table it comes from (281 user tables). How can I easily find which table has this data ? (without opening each table and scanning through 1000's of rows ...

Creating an Alias for a (non-default) SQL Server 2005 Instance

charlieopenshaw - 4 May 2007 9:46 AM - 3 messages

I am trying to create an alias for a particular SQL Server 2005 Instance. I've tried doing this in the host file but this was unsucessful because all the host file seems to do is give you an IP address for ...

SQL - Linking Tables

Stuart - 4 May 2007 9:28 AM - 4 messages

Hi there I have a simple SQL statement which isn't really working for me right now - not fully. I have two tables which I am trying to link, Most of the columns are unique however I am linking them using two ...

Error installing SQL 2005 SP2 KB 921896

rlusian - 4 May 2007 2:13 AM - 3 messages

I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am getting repeated failures applying SQL 2005 SP2. The error is always the same (see below). I have made sure that there are no disabled services in the SQL Server ...

Reporting Services Report Model

David - 4 May 2007 12:50 AM - 2 messages

Hi All Is it possible to connect to a Reporting Services Report Model using Excel? If so how do I go about achieving this? Thanks ...

AMD vs Intel for SQL Servers

Hassan - 4 May 2007 12:12 AM - 5 messages

I know at one time AMD used to be power players for SQL Servers, but of late, I am hearing that Intel chips are also proving to be efficient. Can you share what you have seen in your benchmarks on some of the new ...

APP_NAME() empty when deleting

Jon Davis - 3 May 2007 9:53 PM - 2 messages

I was trying to set up auditing triggers on a table and was using APP_NAME() to get the name of the application that performed the action. APP_NAME() always returns "SQL Server Management Studio - Query" when I'm testing in that environment and executing INSERTs or UPDATEs. But for some unknown ...

Need SQL Server 2005 tool similar to Oracle's Connection Manager

Jason - 3 May 2007 9:39 PM - 2 messages

I would like to know if there is a comparable tool in SQL Server 2005 to the Oracle Connection Manager (link to Overview on Oracle product below) [link] ...

RECEIVE in transactions

Ola Hallengren - 3 May 2007 8:55 PM - 4 messages

Hello! I have an an event notifications audit solution that I'm working on. I am using this activation procedure. CREATE PROCEDURE dbo.AuditReceive AS DECLARE @AuditMessage TABLE (EventData xml); RECEIVE CAST(message_body AS XML) FROM AuditQueue ...

SQL Server 2005 - newbie question

spacemarine - 3 May 2007 8:41 PM - 5 messages

hello, ive just installed my dev copy of SQL Server 2005. evidently it doesnt install the sample AdventureWorks db by default. unfortunately, installing it is proving to be somewhat troublesome. i have gone thru the Ad/Remove wizard and i now have the data files in ...

CR & LF Problems

Paul - 3 May 2007 8:40 PM - 3 messages

I'm trying to concatenate three address fields into one for a SELECT statement. Below is that part: CASE WHEN ADDR1 IS NULL THEN '' ELSE ADDR1 + CHAR(13) + CHAR(10) ...

Case Statement Woes

thejamie - 3 May 2007 8:24 PM - 3 messages

I have the case statement below and when the processing runs (set transname=(case stmt...) or insert into table (col1,col2...) select col1,case stmt from anothertable, the processing from within the part of the case statement that is below the "when isnull(trans_id,0)=1105" runs, it does not ...

Reporting Services Login

Audrey Ng - 3 May 2007 8:20 PM - 2 messages

Hi all, I am trying to deploy a report that I have created. When I right-click on the Report and click on Deploy, I get a Reporting Services login dialog box. I tried all login/passwords possible and it keeps on ...

SQL Server 2005 Sgent will not start - Service Time out error

pjslak - 3 May 2007 7:45 PM - 4 messages

I have multiple instance of SQL2005 installed on my server all services use the same User name and password. The SQL Agent Services for all of the instances will not start. When I try to start the services from Mgmt Studio I get ...

Difference between Index & Statistics

JayKon - 3 May 2007 6:23 PM - 4 messages

2000 & 2005 (The DDL was pulled from the 2005 box, but should be the same, or very close, on the 2000 box) I know what statistics are: distribution of values used by the Query Optimizer. I know what indexes are. ...

Bandwidth Utilization...

zomer - 3 May 2007 6:01 PM - 3 messages

I have two identical SQL Servers... same OS.... same config.... when i run my SSIS package on one server... Bandwidth utilization goes upto 20 mb.... and package completes in 10 mins. Its getting data from oracle DB. I will be migrating this package to another the other ...

Scripting/copying maintenance plans

Tim Greenwood - 3 May 2007 5:38 PM - 3 messages

Since maintenance plans are stored in MSDB and that shouldn't be copied from server to server, isn't there an easy way to copy maintenance plans created with the SSIS UI from one server to another? I tried doing it from the ...

Could not allocate space for object 'xxx' in database 'abc' becaus

sysbox27 - 3 May 2007 3:56 PM - 5 messages

Error 1105 Could not allocate space for object 'xxx' in database 'abc' because the 'PRIMARY' filegroup is full.. Hello, I hope somebody can help me with this issue: The message above appears on a db that has separately located data and log ...

Is there a way to view SP usage stats?

John Rossitter - 3 May 2007 2:16 PM - 4 messages

I have been tasked to cleanup our db (SQL 2000 SP4) which has about 2000 SPs in it. I was hoping that there was an internal tool in SQL Server which tracked the usage of stored procedures to help isolate which ones are being ...

Insert into sys.messages on SQL2005?

Chai - 3 May 2007 1:56 PM - 3 messages

Hello: On our current production server which is SQL 2000, we added a few rows into sysmessages table in Master db for error handling in our in-house application. Now we plan to have a new production sever which will be SQL 2005, so I will ...

CPU usage and troubleshoot (sp_who2, profiling)

tabarnak@gmail.com - 3 May 2007 1:47 PM - 5 messages

(I have only little knowledge in mssql) Hello, We have a 2 members MS SQL Cluster, which sometimes has its CPU usage sticked at 100% during few hours. The dbs are used by customers, we didn't designed them, we just manage the system until middleware level ...

nocheck when creating a constraint

Derek - 3 May 2007 1:43 PM - 3 messages

i was looking at a database creation script and i have a bunch of constraints being created with a nocheck on them. i think i know what the nocheck does (don't check for data issues). i'm not sure why the ...

dbcc dbreindex and tables with no clustered index

Derek - 3 May 2007 1:39 PM - 3 messages

i have tables in my data base with no clustered indexes just some non clustered ones. is there any benefit to running dbcc dbreindex on these tables? ...

SQL Server 2005 Linked Server IDENTITY_INSERT

AG - 3 May 2007 12:57 PM - 10 messages

Hi all, Using SQL Server 2005 Management Studio. I am trying to transfer data from my local SQL 2005 to a remote linked server, but an having a problem with IDENTITY_INSERT. In a query window connected to my local db, statements like ...

how can I tell if a query is running

Dan D. - 3 May 2007 12:28 PM - 10 messages

Using SS2000 SP4. If I look in EM under current activity or use sp_who2 it will look like processes are sleeping. I'm not sure what they're doing when they're sleeping but I've rebooted a machine before and then have someone ...

How to read SQL file ?

bildos - 3 May 2007 11:31 AM - 4 messages

Hello, I recived SQL file (riped database). Can you recommand me any software how to view this database from SQL file ? Currentlly I don't have any database software ...

Outer Join Problem - hardest query ever?

BlackKnight - 3 May 2007 11:19 AM - 3 messages

Hi - I'm struggling with a query, which is as follows. (I have changed the context slightly for simplicity) I have 4 tables: users, scores, trials, tests Each pair of users takes a series of upto 4 tests in 1 trial, getting a ...

many BULK INSERTs and error "cannot obtain a lock"...

PiErre - 3 May 2007 9:33 AM - 3 messages

Hi, I still have problem with my script that perform a sequence of many data files with a BULK INSERT in a loop and rarely (about 10% of times) fails with "cannot obtain a lock" (see the original post ...

SQL Server high utilization

Komandur Kannan - 3 May 2007 7:49 AM - 11 messages

Hello, We have an access control system installed by a provider which uses SQL server Desktop Edition. Below are the version details of the SQL server installed: Information extracted from server as below: Version: 8.00.760 Product Level: SP3 ...

Log file Problem

Me On Line - 3 May 2007 5:47 AM - 3 messages

Hi EveryBody... I am using SQL server 2000 and i was working on Strore procedure and manupulating tables.Sql Server shows me messages that ur log size is Increased and as a result it does not allow me to do any manupulations.so ...

The data types text and nvarchar are incompatible in the equal to operator.

Alex - 3 May 2007 3:11 AM - 4 messages

I'm stumped on this error message. I've looked everywhere and I can't figure out why this is happening. I've set all fields in my sql table to text and all fields in my vb dataset to string, but I still get ...

"downgrading" 2005 to 2000

childofthe1980s - 2 May 2007 7:52 PM - 2 messages

Hello: It's a long story, as to why we ask this. But, here it goes. About a week ago, we upgraded a Windows Server 2003 box from SQL 2000 to SQL 2005 service pack 2. Is it possible to go back to SQL 2000? Restoring a ...

Changing the default database

spdude - 2 May 2007 6:55 PM - 5 messages

I have a large number of databases on my localhost. Whenever I open up Management Studio, there is one database that is selected by default (under Available Databases). But this is not the database that I use regularly. Everytime I run a query, I have to make sure that the ...

SQL2005 Memory Question Again

skeeve - 2 May 2007 6:45 PM - 3 messages

Hi, Some facts regarding my problem: - I am running the 64bit version of SQL2005 on a Win2k3 Enterprise 64bit installation with 8GB of RAM. - I have configured the min/max values, but they seem to be ignored. - The sqlserv.exe task never takes more than 200 to 300 MB, even after ...

Sql2k Maintenance plan error

Graham (Pete) Berry - 2 May 2007 6:27 PM - 3 messages

In trying to create a new maintenance plan via the wizard, the retention type field for both the DB and the TL is blank. The plan seems to create, but then updating it causes a Sql-DMO (ODBC SqlState:42000) ...

Table Index Questions

Ben - 2 May 2007 5:13 PM - 3 messages

Hi, I'm not soo familiar with how the indexes work... I'm seeing some slow performance on one of the DBs (netiq appmanager product). The Disk queues & memory on the server seem fine. But the processor maxes periodically with sqlserver.exe and queries time out. ...

can not view DTS Packages and Jobs

RK73 - 2 May 2007 5:11 PM - 4 messages

I have SQL 2k SP4 on Windows 2003 Can A sqlserver user, with out having SA role, see the DTS packages, Job and their status ? ...

connect to a specific port on sql server/endpoint

adba - 2 May 2007 5:11 PM - 9 messages

i have created a new tcp endpoint using the following: CREATE ENDPOINT [CustomConnection1] STATE = STARTED AS TCP (LISTENER_PORT = 1444, LISTENER_IP =ALL) FOR TSQL() ; And I got warning about permissions being revoked for the default tcp endpoint, but I was okay with that since I really wanted all users to go ...

Locks and Blocks

Audrey Ng - 2 May 2007 3:56 PM - 5 messages

Hi all, I don't understand this. I had SPID 104 blocked by SPID 87. However, SPID 87 was sleeping. How can that be? Please advise. Audrey *** Sent via Developersdex [link] *** ...

Can not run DBCC Checkdb on database

Russell - 2 May 2007 3:29 PM - 3 messages

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition Can not run DBCC Checkdb on database because receiving the following error messages: Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. ...

AgentMail Problem (SQL2K)

Leila - 2 May 2007 3:28 PM - 4 messages

Hi, I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL Mail and Agent Mail can use the file of mail profile to send email. But on one of client's computer, when outlook is open, it locks ...

SQL 2005 developer edition . . . SLOW

SQL Dude - 2 May 2007 2:50 PM - 6 messages

I recently purchased a new development workstation (dual processor) and installed the developer edition of SQL Server 2005 that comes with Visual Studio. I also installed the Management Studio Express tools. Everything SQL-related that I do on this new machine (application ...

DTS Migration Wizard question

dc - 2 May 2007 2:24 PM - 2 messages

Hi, I've upgraded from 2000 to 2005, 2005 on a new server too. I have moved a DTS package from the 2000 box to 2005 box & have performed th DTS Migration Wizard. Now I want to fiddle with the design of the package in Business Intelligence ...

Is there a run command to open enterprise manager?

Learner - 2 May 2007 1:44 PM - 4 messages

Hello , I know that to open Management studio I use "sqlwb" in the run window from the start menu. Is there a run command to open up Enterprise Manager? Thanks -L ...

Transaction log backup larger than actual transaction log

Markus - 2 May 2007 1:42 PM - 6 messages

I have a SQL database = 100gb and a transaction log file = 10gb running on SQL Server 2005. When I perform a backup of each I get a database backup = 10gb and a transaction log backup = 36gb. Why is my transaction log backup ...

SQL SRVR 2005 Standard - scheduled backup

r042wal - 2 May 2007 12:54 PM - 3 messages

I have SQL Server 2005 Standard Edition installed and I am trying to become familiar with many of the new features. For now, I would like to schedule a full backup to run daily. I have found the option to back up the database ...

SQL Locking Issues

johncarter - 2 May 2007 12:03 PM - 13 messages

I have a strange problem with locking. I have a client server application that uses SQL Server as the back end. For 5 years this application has used SQL 7.0 without EVER one occurance of locking to ...

Difference between SQL Server 2000 and 2005

Viraj Rao - 2 May 2007 11:02 AM - 3 messages

Hi, I would like to know new features available in SQL Server 2005, compared to those available in SQL Server 2000. ...

strange result with sp_dbcmptlevel

Radovan Dobriæ - 2 May 2007 6:32 AM - 4 messages

Hi, I am very confused with the result of 'sp_dbcmptlevel' I have many databases on several servers (all upgraded from 2000 to 2005). the stored sp_dbcmptlevel returs following: exec sp_dbcmplevel @dbname='mydatabase' The current compatibility level is 90. Books on line have this sentence. ...

join (?)

eHannes - 2 May 2007 6:14 AM - 3 messages

Hi, I have a question about joining tables and i cannot figure it out how to solve this. Hope somebody can help me: I have two tables table1 ------------------- fieldid | shortlist ------------------- name | y adress | n city | n ...

Is Null

arijitchatterjee123 - 2 May 2007 6:11 AM - 4 messages

Hi, I have a silly doubt. Please tell me whether "Is Null" is a contraint or not? If yes then why it does not show in sysconstraints view? Regards Arijit Chatterjee ...

Lock being acquired in DBCC SHOWCONTIG and sys.dm_db_index_physica

bill k. - 2 May 2007 5:40 AM - 3 messages

Hi, Can anyone explain below why the different explanation in terms of S and IS lock on the table? Or simply an errata in the 2005 BOL or the best practice? Â· From SQL 2005 BOL, ...

problem with procedure

meendar - 2 May 2007 5:04 AM - 3 messages

Hi, I have selected a field name and declared it as varchar, since it is varchar in table and performed some numeric operation with numbers, even after i cast the sql in below code, it throws an exception as "Error converting data type varchar to numeric." ...

SQL Service Account Rights

JD - 2 May 2007 12:59 AM - 2 messages

Hello. We are trying to maximize the security in our active directory infrastructure. Occasionally we have analysts logging onto production servers with the SQL service account to get stuff done since their regular user ID doesn't have those permissions. Ideally, I would like ...

update records

morphius - 2 May 2007 12:31 AM - 3 messages

table1 (tbl1_ID int primary, name varchar, address varchar) table2 (tbl2_ID int primary, name varchar, address varchar) I need to update table1 with data from table2. However tbl2_ID does not match tbl1_ID EX. table1's records (1001, joe smo, 123 my street) ...

Asynchronous / non-blocking trigger

Jon Davis - 1 May 2007 11:52 PM - 4 messages

Is it possible to create an asynchronous / non-blocking trigger in SQL Server 2005 that will allow operations to continue asynchronously while the trigger can still read the in-memory "inserted" and "deleted" virtual tables? Thanks, Jon ...

How do I create scheduled backups in SQL 2005 Express?

Ed Enstrom - 1 May 2007 11:16 PM - 4 messages

My company uses SQL 2000 as its standard db. We have a third-party door security system that used SQL 2000 Desktop. I was able to create scheduled backups of this db using SQL 2000 utilities. The vendor just updated the security system and they now use SQL 2005 Express Edition. Their system has a utility to ...

Compare data between two views on two different databases

Sehboo - 1 May 2007 10:24 PM - 4 messages

How can I compare data returned by two views on two different databases? I want to compare column by column or the whole dataset. I need to do that in query. Thanks ...

SQL Server does not exist or access denied on one computer only

don - 1 May 2007 10:20 PM - 3 messages

Hi, We have a vb application running on 3 computers on our client's site, connecting to a sql server 2000 db on a server. It has been running well starting from last year until last week, when one computer showed this error. ...

Job failed with error 3624

Iter - 1 May 2007 9:07 PM - 5 messages

Hi Guys, In my develoment server, I got error with 3624 when job running, error message is like: Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624) Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression: ...

Calculate fiscal periods (T-SQL)

Thanh Nguyen - 1 May 2007 8:33 PM - 4 messages

Hi Experts, I would like to be able to take in a year and figure out its 12 month period based on Sunday as starting day of the 1st week of that month and each period has 4 weeks. For example: ...

Backup fails: "A nonrecoverable I/O error occurred on file"

nexdeveloper - 1 May 2007 7:52 PM - 6 messages

We have been having a problem with one of our backups: A nonrecoverable I/O error occurred on file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SOMEDB_Data.mdf" It's on the same external storage drive as all of our databases yet it's the ...

Increase one month

Michael - 1 May 2007 7:44 PM - 4 messages

Hi, I have a date value of 4/1/2005, I wanted to increase just one month to 5/1/2005. I have millions of records like that to increase just one month. Is there a function I can use? ...

Delete duplicate records

Michael - 1 May 2007 7:43 PM - 3 messages

Hi, I have 2000 obs, among which 1000 is just a duplicate of the left 1000. How to delete 1000 duplicate records? Thanks a lot!! Michael ...

error with calling stored proc with exec

d.s. - 1 May 2007 7:31 PM - 6 messages

Ok, I previously had a thread about "Column name as variable". Here's a proc I wrote, and it compiles ok: alter PROCEDURE rptRRTP_By_Date_Range -- Add the parameters for the stored procedure here @Update_Field as sysname, ...

64 Bit patches. Are these SQL?

Bob - 1 May 2007 7:05 PM - 8 messages

I noticed that my 64 bit version of Win 2003 Server is creating a lot of patch folders under C:\Windows. What are these all about and why do I not see similar folder names on my 32 bit server? ...

Binary Value Manipulation

tfeller - 1 May 2007 7:01 PM - 3 messages

I would like to drop the leading 0x on a binary value so I can do a bitwise operation. Here is simplified code: select right(0x88186000,8) I expected to get back 88186000, this was not the case. The command ...

Problem with DatabaseMail (SQL2K5)

Leila - 1 May 2007 5:35 PM - 8 messages

Hi, I use my gmail account to send email from outlook express. But when I try this account from DatabaseMail, it fails with the following error: The mail could not be sent to the recipients because of the mail server ...

Run a Maint Plan from a bat file?

donsql22222 - 1 May 2007 5:33 PM - 3 messages

Is it possible to run a Maintenance Plan Job called from a bat file? I need to have a Perl script finish running its job before the Maintenance Plan is called so there's no interference because of the locked tables while ...

SQL Server and VMware

Suresh - 1 May 2007 4:55 PM - 4 messages

I am planning to install SQL Server 2000 and 2005 on VMware. I was wondering if some one could point me to the right resources where i can find help about how to install it on VMware. Any help is appreciated. ...

Column name as variable

d.s. - 1 May 2007 4:47 PM - 3 messages

Does anyone know if I can use a variable for a column name in a query? I'm wanting to reuse some code that updates a table, but, depending on conditions, I want it to update a different column. Something like: ...

question sql server

soalvajavab1 - 1 May 2007 4:27 PM - 4 messages

what is the best way to distribute one stored procedure to 50 different databases in 50 different servers? ...

How can I pre-allocate file size of TempDB in SQL 2000?

Chai - 1 May 2007 3:48 PM - 3 messages

Hello: We reboot our production server on Mondays. I would like to pre-allocate (set original) file size for TempDB to a reasonable size to avoid frequent expand of this DB. How can I achieve that? I couldn't find any setting in ...

Urgent help needed do delete a sub-string from long string in many records.

Zoro - 1 May 2007 3:11 PM - 4 messages

I have a sub-string in a varchar() filed that is causing a problem to an important process. it's in many thousands of records so I can't do it manually. So I'm looking for an sql that can remove a sub-string from a long ...

SQL 2000 Encrypted Fields?

Gav - 1 May 2007 2:51 PM - 2 messages

I am writing an application which is going to work with employees salaries. Are there any built in SQL functions that would allow me to encrypt and decrypt the contents of a field? I was planning on writing a few stored ...

latest entry per distinct ID

Kim - 1 May 2007 2:12 PM - 7 messages

I need to retrieve the latest email record for each formID At the end of this email is table script and data. I need to end up with these results. How do I write a query tro retrieve this? THANK you in advance... ...

Regarding how to compress the data file

Iter - 1 May 2007 2:11 PM - 3 messages

Hi Guys, I have question Regarding how to compress the data file. IN my company, the data file is getting bigger and bigger. Is that a way to compress the database file to make it smaller so that we can save some disk space. Thanks. ...

Transaction Log getting bigger

fniles - 1 May 2007 1:57 PM - 11 messages

I am using SQL Server 2005. I created a Maintenance Plan to backup the Transaction Log every 4 hours with "Verify backup integrity" checked. I thought after the backup the transaction log will be truncated, but when I check the size of my DeskMZ_log.ldf it is 102 Meg, while the size of ...

Removing a SQL server backup

r042wal - 1 May 2007 1:19 PM - 2 messages

In SQL Enterprise Manager, an employee right-clicked the 'Database' object and created a scheduled backup. Then they expanded the 'Database' object, found the target database 'XYZdatabase', right-clicked that too and scheduled a second backup to a different drive. ...

Barcode Help

Miike - 1 May 2007 1:17 PM - 2 messages

I am using Centura Report Builder to pull data from a SQL Database. I need to print barcodes from a field and cantinate an * at the begining and end of this field. I cant figure this out. Thanks, MIke Sorry if this is not the right group ...

DBCC CLEANTABLE (SQL Server 2000) question

JimLad - 1 May 2007 1:12 PM - 4 messages

Hi, I've got a 40mill row table and I've normalised one of the columns out to a separate table. I have then dropped the original varchar(100) column. I want to reclaim the space as efficiently as possible. ...

Database growth and Replication

printing members of server roles in 2005

clustering

service pack4

SET 'QUOTED_IDENTIFIER' error, in the Optimization Maintenance Plan

View in 2005 says cell is read only

How to pause database mirroring ?

Error copying SQL 2000 DB to SQL 2005

Not showing database backup file name for restore

ANSI vs SQL 92 ambiguity ?!? yeah right

How can I do This (Newbie)

How to _really_ kill blocking spids?

Help With SQL Command

serser 2005 sp1

SQL 2000 Trace Flag

SQL 2005 Standard Multi-Instance Licensing

How to deal with Log Flushes issue?

Upload Tables in SQL 2005

named instance installed no access to perf. counters ?

Adding a column to VLDB 200GB table

OPTION OPTIMIZE FOR can't utilize negative values

DBA for multiple servers

Can I Merge a table with itself ?

rowmodctr

Linked server and MDAC driver.

Create CI and CS DB in same MSS instance

sql workgroup/standard 2005 editions no of processors allowed

Help With Query and/or Design

Question

clustered index choice

Can I Mirror my Databases With a Third Party Affordably?

View in 2005 says cell is read only

xp_cmdshell working directory

Removing SQLServer 2005 Express Registry Keys

Help with a Query

Want some suggestoins

how do I run the sql server 2005 tutorials?

concating columns

Error message

ODBC DSN for SQL Server via script

memory on 2005

sp_OACreate and Security?

SARG

Index usage in Like operator.

Creating Data Sources (ODBC) via code