Search results for query: *

[SQL Server Destination [52]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to...

Is there a text file stored in a local drive for the execution results after the is package executed? Sometimes the message in execution result is truncated unless I copy and paste the message into a notepad. So I like to see if these results are stored somewhere else? TIA

Created a FK after a 1.5million records table being loaded. Is there any draw backs for doings this? Do I need to rebuild the indexes? or reindex is automatic after creating the FK? TIA

I have a sql task which takes tablename as a parameter and writes in a file with tablename as part of the file name. Unique table names can be available from a table. Right now I am generating one file at a time inputing the table name every time. Can I do this task using a Foreachloop...

If I have a base table customer with custid, name1, name2, add1, add2, begdate, enddate. And I have a update on name2 and add2 then I want to capture the change and write in a staging table with the whole old record except the enddate. Enddate I want to put the current date. Is that old...

I want the syntax for something like this create proc if condition then create trigger else do soemething. TIA

I have a base table and audit table are like this SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Mytest]( [TestID] Int NOT NULL, [TestDesc] [varchar](35) NOT NULL, [EffBegDate] [datetime] NOT NULL, [EffEndDate] [datetime] NOT NULL, PRIMARY KEY CLUSTERED (...

How to select the current publisher? Is there a query? I can look in SSMS under replication/local publications. But is there a query I can use for some programming? TIA

I have a task to generate some sql using some standard statments and some variable names as table name. For example CREATE PROCEDURE DBA.tmpBSPOt ( ) BEGIN IF ( SELECT STRING(Value) FROM @tablename WHERE Name = 'ImplementBSPOT' ) = '1'...

Is there a command in SSMS to write a resultant set to a local file? something like select 'my text' output to 'c:\test\mytext.txt' I can not use the resultant set to "save the result into a file option". Because I have some more script to follow once I saved the results to a file. TIA

I like to delete the views if exists and satisfy a condition. For example if I have a view like LoadInvView or LoadPOView or Load%View then drop them. How do I accomplish this? I think I might have to use a cursor and ExecuteImmediate but I am not sure. Personally I do not like cursors. TIA.

Can I create a user without any password? This user is going to own the schema but we never going to login as this user. This user is not belongs to any windows account TIA

By executing this command SELECT * FROM sys.views where object_id = OBJECT_ID(N'[dbo].[MyView]') I can find the details about MyView. Is there way I can find all the views like MyV% ? I can do this SELECT * FROM sys.views v inner join sys.objects o on v.object_id=o.object_id WHERE...

Is there a way to find the last executed sql in SSMS? Like a history of the sqls? TIA

I am doing to a conversion into Sql server and we have the schema now in MSS. I like to load the data first then want to turn oN the RI later. Is there a way I can accomplish this? TIA

How do I execute only 1 data flow in a package which has many data flows in a control flow. I remember I did execute only one data flow but I do not remember how. TIA

How do a read a file in Management Studio? Is there something like read 'c:\myscripts\script.sql' ? TIA

Is any one used this tool by MSFT? We have an ASA9 and I have difficulty to connect to the Sybase DB. TIA

I have a realtime database application and we are using lots of triggers. We are planning to convert the data into sql server 2008. Can I still use these triggers? or any alternatives? TIA

We are planning to install sql 2008 and want to find out if it is better to have operating system and sql server installed on separte drives? TIA