I have two computers. One with Vista 32 bits and one with vista 64 bits. I have build a VB.Net application on the 32 bits computer. The...

Marc Robitaille

07-07-2010 03:18 AM
Erland Sommarskog

Hi, I have the small T-SQL script below to backup my databases: Here is a snippet: BACKUP DATABASE TO DISK...

bob123

07-06-2010 02:39 PM
bob123

Hello, & Iam trying to connect to an Oracle database from SQL2008 Reporting Services but Iam facing an error. This is what I have done: -...

Abba

07-06-2010 10:35 AM
Abba

Dear Experts, Could SQL server allocate resource evenly for each incoming query? Because sometimes when one user perform a long running query (eg....

thomas

07-06-2010 04:07 AM
Erland Sommarskog

Dear All I am trying to attach the database so when i press attach ive got this error MICROSOFT SQL-DMO (odbc sql state 42000) ERROR 5172 :the header...

ashraf_al_ani via SQLMonster.com

07-06-2010 04:06 AM
Erland Sommarskog

i want to create some default values, like the "use custom color" when you open the ssms. the current problem that, when a new user login to a...

peleg

07-05-2010 05:28 AM
peleg

Hi guys, A developer in our office has come to me asking for assistance, and I have no idea what can be causing this. We're running SQL Server 2005...

Craig Lister

07-05-2010 01:27 AM
Tom Cooper

Can someone give practical guidelines on how and when the data partition to be used? I am looking for a specific pointers such as how many cols (??)...

SQL

07-04-2010 11:48 PM
Uri Dimant

I have a IBM Dual Quad Core CPU system running SQL 2000 and all SP/Updates. I'm seeing a log of blocking because of a vendors app that I have no...

Leythos

07-04-2010 10:54 PM
Fred McConville

Hi, I do my backup,check .. with MaintenancePlans I need to execute it by scripts launch by an external scheduler I can start the job from a script...

bob123

07-04-2010 02:00 PM
Erland Sommarskog

We have Read Committed Isolation enabled and I was interested in more closely monitoring TempDB usage. We do NOT have Snapshot Isolation enabled,...

cbrichards via SQLMonster.com

07-03-2010 03:59 PM
Erland Sommarskog

Can someone please give me all the steps and SQL code for copying 2005 databases using detach/attach? I need this for both using a) Management...

SQL

07-03-2010 04:57 AM
John Bell

SQL 2005 64 bit EE I have a large database with several partitions and lots of data. One of the tables that is across the partitions I'd like to...

cw

07-02-2010 06:32 PM
John Bell

I'd like to update a report parameter in SSRS with something similar to the following: @parameter= select Max(date) from table so it may be...

jm27102

07-02-2010 05:02 PM
John Bell

I am a student just downloaded the developer edition of SQL Server2008. Anyway to find out is the version 32 or 64 bit?

Alan T

07-02-2010 04:21 PM
John Bell

Hi Friends, SQL 2008 - TDE encryption I'm trying to apply TDE for one of my databases, all seems run fine, except that when I run SELECT...

Pat.Rick

07-02-2010 02:20 PM
John Bell

Can stored procedures be included in a backup file, .bak? I'm thinking only the data is in the bak file, but is there some way I can include the...

SAC

07-02-2010 01:06 PM
SAC

Does MS SQL 2008 support refactoring?! Ex: Changing a column name or data type of one column in one table will reflect the changes in all the...

Raj

07-01-2010 01:44 PM
Jeroen Mostert

Hi, In SQLSERVER 2005 when shrinking I receive : backup log MYDB with truncate_only; DBCC SHRINKFILE ('MYDB_log',3000); Could not locate file...

big

07-01-2010 07:11 AM
Dan Guzman

We are sometimes getting "Syntax error, permission violation, or other nonspecific error" when a stored procedure call is prepared. We are using the...

Timo Partanen

06-30-2010 01:32 PM
Timo Partanen

Hi, in my table object I have specified two filter conditions: 1. =Fields!INDEX_DURCHDRINGUNG_JAHRMONAT_Q_VJ.Value / BottomN / =CInt(15) and 2....

Bodo

06-30-2010 10:40 AM
Bodo

Hi, If I do a full backup on a SQL 2000 database, then backup the transaction log several times over a few hours, then do a differential backup,...

Steve Gr

06-30-2010 08:04 AM
Steve Gr

i am using sql server 2008 and i'm new to partition functions i have 3 tables, all have dates that i want to partition on. is it considered bad...

Derek

06-30-2010 07:18 AM
Dan Guzman

Hello all, i have question in my database i have table messages have 2 foreign keys (senderId, recieverId) both refrence to the same primary key...

1_2_3_4_5_6 via SQLMonster.com

06-29-2010 10:39 AM
Tom Cooper

I have a multiple instance SQL Serer 2005 server on Windows 2003 that is failing on the attempt of adding a new instance. It starts out by failing...

Paul Bergson [MVP-DS]

06-29-2010 07:13 AM
Paul Bergson [MVP-DS]

I have a maintenance plan that backs up a database. The database is pretty active all the time (it's a 24/7 app so there's no 'down' time). While...

Mr. Magic

06-29-2010 06:48 AM
Mr. Magic

Every so often I get blocks on actions that simply should not cause blocks, like selecting a text field from 100 rows of a 1000 row table. This...

Maury Markowitz

06-29-2010 06:03 AM
Dan

Hi, in the near future we will be implementing a test environment for our SSIS packages. We would like to be able to minimize the amount of...

jam772

06-28-2010 06:39 PM
John Bell

Hello, We are testing the use of Policy management framework and thus my manager has entrusted me to collect some sample policy ideas which can...

Abba

06-28-2010 04:36 PM
Erland Sommarskog

I do a lot of work in Management Studio connected to a SQL 2008 server from my workstation. Sometimes I lose connection after accessing fine all...

DavidC

06-28-2010 04:32 PM
Erland Sommarskog

I am experimenting with upgrading SQL Server 2005 SP3 to SQL Server 2008 SP1 - IN PLACE. The upgrade appears to be completely successful. But...

Flora M

06-28-2010 04:27 PM
Erland Sommarskog

I have event errors set up to trigger e-mails. 1408 was supposed to designate a failover of a database mirror. It was working previously. Now I am...

Aron Tekulsky

06-28-2010 02:10 PM
Aron Tekulsky

Hi, Our sql server 2005 data permissions are set to windows security groups which exist in active directory. Now it’s time to move to new servers...

HDI

06-28-2010 09:20 AM
HDI

Hi, I am trying to change the database collation (+ all defaulting columns). I have created a new database with the new collation and have tried...

JimLad

06-28-2010 08:36 AM
JimLad

Hi guys. We have a requirement to return a string of names, which are spread in different rows, but belong to each other in a foreign key....

Craig Lister

06-27-2010 11:40 PM
Tom Cooper

installation error(SQL SERVER 2000) sent back to sqlstp sqlstp: 20:16:13 Begin Setup 20:16:13 8.00.194 20:16:13 Mode = Normal 20:16:13 ModeType =...

Zaczes

06-27-2010 04:58 PM
Erland Sommarskog

I want to get a list of employees who were all paid on the last payDate in employeeLog before my query date(20100101). I've thought of 2 ways to do...

Cindy Lee

06-27-2010 11:09 AM
Cindy Lee

Hello, Can a SQL 2008 R2 box be joined to an existing SQL 2008 cluster that's not running R2? If so, are there any known issues? My understanding...

Rubens

06-26-2010 05:09 PM
Rubens

for database mirroring, can one mirror server to two principle servers? That means two mirrored servers mirror to one same mirroring server. Is that...

Iter

06-25-2010 06:28 PM
Iter

I have 2 dbs that reside on two servers respectively. Both dbs have the same stucture. There is roughly 20 tables in the db. These two tables...

RG

06-25-2010 05:25 PM
Erland Sommarskog

I have created some databases no init from SQL Server 2005 maintenance plan. I want to do Init backups and override the backups I made in the past...

SQL

06-25-2010 05:01 PM
Erland Sommarskog

Hi, I'm trying to figure out a way for a monitoring app to count messages in our transmission_queue. We want the app to alert us if it's over...

zinck74

06-25-2010 04:59 PM
Erland Sommarskog

I used Visio 2007 to reverse engineer a SQL Server 2005 database. Everything seemed to go fine but some of the tables are nt geeting picked...

Dave1031

06-25-2010 04:22 PM
John Bell

Hi, In the SQL Server 2000, I have some maintenance plans for backup up files to a share folder. How do I manually change those plans so that the...

Jason Huang

06-25-2010 03:43 AM
Jason Huang

I have a question about database mirroring. I am trying to test database mirroring . Somehow it is not working. I am getting 1418 error: SQL...

hayko98

06-24-2010 05:06 PM
hayko98

As I understand SQL2005 maintenance plan backup has a compression future. But why is some dbs are close to the actual size and few others not? How to...

SQL

06-24-2010 04:35 PM
SQL

Hi All, I'm not sure whether this is something possible with SQL Server 2008. I tried it on a test machine and it works ok. But I need a...

Roshan Jayalath

06-24-2010 04:00 PM
Andrew J. Kelly

We have a client with a SQL2000 EE sp3 on Win2003 EE as a 2 node cluster. The the nodes are 16 CPUs each with 18GBs memory. The boot.ini has the...

cw

06-24-2010 03:59 PM
Andrew J. Kelly

I created 2 database views. Each of them uses 256 database tables. From every database table only one column is used in the select list of the view....

Juwe17

06-24-2010 03:54 PM
Erland Sommarskog

Hi SQL Monsters! I am trying to run SQL Profiler from command prompt. I am using the following command. The /M is supposed to stop the trace....

Mitchell_Collen via SQLMonster.com

06-24-2010 03:51 PM
Erland Sommarskog