Server Configuration

Refactoring in SQL?!
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 tables, stored procedures ... What a feature! Thank you Regards Raj ... 1 Jul 2010 15:37

shrink problem
Hi, In SQLSERVER 2005 when shrinking I receive : backup log MYDB with truncate_only; DBCC SHRINKFILE ('MYDB_log',3000); Could not locate file 'MYDB_log.ldf' in sysfiles. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Can you help me ? Thank you. ... 1 Jul 2010 03:27

Syntax error, permission violation, or other nonspecific error when preparing a procedure call
We are sometimes getting "Syntax error, permission violation, or other nonspecific error" when a stored procedure call is prepared. We are using the SQL Server Native Client OLE DB provider with MS SQL Server 2008 R2 on Windows Server 2003. The procedure call has one dynamic parameter because it is executed mul... 30 Jun 2010 15:23

Using Machine Name in DOS Batch
Hello, I am running a script against a list of SQL Servers using a DOS Batch file. The .bat generates one output file per SQL Server instance. I can use the destination SQL Server names in the output file names, but I can not use the destination machine names. It brings the lcal machine name and use it on all ... 8 Jul 2010 17:00

Strategy for data partition?
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 (??) are too many to start looking at vertical partinioning and how many rows (counts) are too many for a horizontal paritioning? What is the performance criteria be consid... 5 Jul 2010 01:21

Backups sequence
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, what do I need if I then want to restore that database? Do I just need the full and the diff? Or do I need all the logs in between as well? Thanks in Advance, S... 30 Jun 2010 09:47

Is database available during a backup?
Can you give me some direction with this? I've used perfmon some but not a lot. And what should I be looking for? "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message news:ejbru5toik4a12cstj8v5imepacrv3lp5q(a)4ax.com... On Fri, 14 May 2010 08:51:49 -0400, "Mr. Magic" <Mufasa(a)NoWhere.Com> wrote: I ... 29 Jun 2010 08:33

2 foreign keys point to the same primary key
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 userId in table users it gives me an error, it refuses to make the 2 relationships with the same column !!! what to do ?????????? HELP PLZ -- Message p... 29 Jun 2010 11:52

Moving SSIS 2005 packages from test to prod.
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 code changes that take place when doing the move from test to production. Is there any funtionality within SSIS 2005 to search and replace the server name and database f... 28 Jun 2010 20:35

How to _really_ kill blocking spids?
Are you sure the connection is made and dropped? could it be that the table is linked in the app? MauryMarkowit wrote: Re: How to _really_ kill blocking spids? 01-May-07 "TheSQLGuru" wrote: Well it's hard to say. All I know for sure is that any access to the tables locks the subsequent users. Let me g... 29 Jun 2010 07:27