|
Question about transactionnel replication Hi, I'm new in Replication word and I have a few questions for you I've setup a transactionnel replication that is working fine, I know that data changes is pushed from Publisher to Subscriber by the Log Reader agent, but how about schema changes? if I alter an exiting article or add a new one, is the log r... 13 Aug 2010 15:47
Count on Iif Statement in Access to Case Statement What is the SQL Case Statement equivalent to the following SQL expression in Access? Thanks for any help. Count(IIf([HourCreated]=7,0)) AS 7 ... 13 Aug 2010 14:41
Update whit values from other table I have one table named estoque with this fields Produto int ICM int and the second table produtov1 with this fields Produto int ICM int I want to update all the column ICM of the second table produtov1 where the field produto is = , I have write this but not work UPDATE produtov1 SE... 13 Aug 2010 09:13
Creating indexes increasing size of datafile Hi All, I have a production database which was of 20 GB of size. I tried to put up one clustered indexe with three key coulmn, few other non-clustered indexes. After running for about 2 hours the size of datafiles grew up to 103 GB!! Can someone advise why this happened and any solution to bring the size ... 13 Aug 2010 01:42
Reduce log file size I cannot reduce the size of my log file which has grown to 43GB. I tried using DBCC SHRINKDATABASE but got the following message and not sure how to shrink it. Any help is appreciated. DBCC SHRINKDATABASE: File ID 1 of database ID 10 was skipped because the file does not have enough free space to reclaim. Ca... 13 Aug 2010 11:25
import file problem I need to import a text file every 30 minutes into SQL. The text file looks like this One, two, three One, two, three One, two, three, four, five, six, seven One, two, three One, two three, One, two, three, four So you see number of columns varies. But the SQL import wizard sets up the number of column... 13 Aug 2010 12:30
Defining a date variable as null in SQL Server 2008 I have a custom program that inserts data to a table in SQL Server 2000. One of the fields is a date field, and we are passing it 8 spaces in the flat file. The program in SQL Server 2000 converts this to null, and does so using the following code: begin-procedure Default_Date(:$DateVar, $DefaultDate) if isbla... 13 Aug 2010 02:46
Using Parameters and Loop to find all SQL Server versions Hello, looking for a quick way to find out all the SQL server versions in a domain.... Currently I have a table with all the SQL names in the first column, such as: Table Name: SERVERS SERVERS SQLSERVER1 SQLSERVER2 SQLSERVER3 SQLSERVER4 SQLSERVER5 SQLSERVER6 ... 12 Aug 2010 11:29
script default constraints There is an article here that has the very simple script to find the default constraints. Hope this helps! http://thiagsundar.wordpress.com/script-to-find-the-default-constraint-and-drop/ On Thursday, March 01, 2007 8:55 AM Jac wrote: Hi, I am creating drop and create statements for default constrai... 12 Aug 2010 10:23
install ssis on windows server 2003 Hi there, I can't install SSIS service on my windows 2003 server. SSIS service won't show up in the SQL Server Configuration Manager's services list after i perform a full install from SQL Server 2005 SE installation CD on my server. During this install I've selected a choice for 'Integration Services'. I have Mi... 12 Aug 2010 04:57
Question of Views Are there issues with Views? I have heard that views can be a problem because they use a lot of memory and that it is better to write the queries against the actual tables instead of using views. That views are inefficient. I had thought that it is identical to the code it replaces however, so not sure if ... 13 Aug 2010 01:42
Operand type clash: int is incompatible with ntext I have a query that involves 3 tables. I am only mentioning data types of columns that are involved in the query. Table customer with column customerid(int), table discount with column validforcutomers(ntext), registration with email(varchar(50)). I am ruunning a query which is giving me the error mentioned in the ... 13 Aug 2010 09:13
Trigger that acts on either the NEW pk or the existing pk Hello folks, I have not posted for a while, I hope this group is as good as it used to be. I want to write a trigger that performs an insert or update or delete on another table. The trigger would fire on insert, update, or delete. The table has a pk field called idx. So after the sql statement is complet... 13 Aug 2010 14:41
ALTER TABLE statements showing up in my stored procedures Hi, Recently, I noticed some ALTER TABLE statements in my stored procedures. I have no idea where they came from. The only thing I can think of is that I do generate scripts to keep my local copy of the database where I develop my application and the production server in sync. I think these statements start... 12 Aug 2010 18:06
how to dateadd with bigint i have a list of unix timestamps that i need to convert to datetimes. 16699435200 is the largest number. SELECT DATEADD(minute, CAST(16699435200 AS BIGINT), '19700101') Based on a powershell attempt at this i don't even think a CLR function will help. PS D:\Source\5.3_trunk\Database\RMSchema\Common> (get-da... 13 Aug 2010 09:13 |