Hello Friends I am looking for viewing the text of the system views and procedures in SQL Server 2005 using the object explorer or using sp_helptext. actually i am coming from the SQL Server 2000 background, where we have the feature of retreiving the code of the view and the stored procedure using SQL Server 2000 Enterprise manager di...
Hi, I have a design issue that I would appreciate some input on. I would like to make an calendar event system based on the following 4 tables: tb_events id, date, summary, tb_group id, name, parent, lineage, tb_course id, name, tb_staff id, name, email, The event class is currently set up as id summary date calDetails IL...
In sql server 2005 , inside an update trigger is there a way to find the list of fields\columns those are modified by the original update query. I have a table with 150 columns and inside the trigger need to konw if ONLY one particular field was updated or not ( and no-other field was modified ) I can write a long sql to compare 150 c...
How to decide whether to choose a Replication or Mirroring in SQL Server 2005 to provide data availabilty and performance at the same time. ...
How does one compare the text field of one record to all the other records in SQL server to return, for example, the top 5 most related records? An example of the functionality I'm after are the various Related Posts plugins for Wordpress that produce a list of links to posts related to the post currently being viewed. Cheers, Iain ...
I'm Using SQL Server 2005. The query would look like this Select col1, col2, col3 from where (col1,col2) in SQL Server doesn't seem to like that, any way of implementing that that anyone knows of that doesn't involve converting to varchars or anything else messy? This is the actual query. SELECT * FROM ( SELECT NEWI...
I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error: Failed to get data. *Data provider could not be initialized *SQL Server does not exist, or access denied on my Office Web Components (MDAC). I am guessing there is some security or server configuration error...
I have a customer that has a SQL database on a hosted server; call the db "myDatabase". The hosting co. has locked down object explorer - I can't myDatabase thed database listed (I see tempdb and master). However, if I "use myDatabase" and then "select * from myTable", all works fine. Since we have no access to object explorer, I can'...
I'm always making manual changes to a lot of data as part of my job. One thing I've noticed is that I can use the arrow keys to browse around to different cells when viewing the data. But when I go to a new cell, the entire text in it is highlighted. How can I use my keyboard to say I want a cursor so I can modify the text without clicki...
I am supposed to perform ETL where source is a large and badly designed sql 2k database and a a better designed sql 2k5 database. I think SSIS is the way to go. Can anyone suggest a to-do list or a checklist or things to watchout for so that I dont forget anything? How should I approach this so that it does not bite me in the rear later ...
I have a nullable DateTime column in my SQL Server 2005 table called DateTimeDeleted. I'd like to have a BIT type computed column that is 1 if DateTimeDeleted is not null, otherwise 0. However, I can't seem to get the syntax for the formula correct. I've tried: (TsDeleted IS NULL) = 0 but it gives me a syntax error. Help! :) ...
Dear StackOverflow, I'm trying to do the following in the VS2008 Linq O/R designer, SQL 2005: I have a table called "Entity" with an autoincrementing primary key named "PKey", and another field called "Parent" I've made a View from this table, calling it vwEmployees, with a simple where clause. Add both to O/R designer. in O/R, set th...
I have an XML source in a Microsoft SSIS 2005 package and when I debug the package I am receiving warnings like: [DTS.Pipeline] Warning: The output column "AccBasicRateDesc" (15229) on output "AccFwdDetail" (303) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increas...
I have a column containing items that can be sorted by the user: DOC_ID DOC_Order DOC_Name 1 1 aaa 2 3 bbb 3 2 ccc I'm trying to figure out a way to properly initialize DOC_Order when the entry is created. A good value would either be the corresponding DO-CID (since it is autoassigned),...
I have a SQLServer with a linked server onto another database somewhere else. I have created a view on that linked server create view vw_foo as select [id], [name] from LINKEDSERVER.RemoteDatabase.dbo.tbl_bar I'd like to to the following alter table [baz] add foo_id int not null go alter table [baz] with check add constraint [fk1_...
I'm developing a custom component that inherits from a PipelineComponent in SSIS. This is the "ProvideComponentProperties" snippet of code: IDTSOutput90 output = ComponentMetaData.OutputCollection.New(); output.Name = "Output"; output.SynchronousInputID = input.ID; output.ExclusionGroup =0; m_DefaultOutputId = outpu...
I have been told and I'm not sure I believe this: Removing white space from my stored procedures in sql server 2005, before I submit them, will make them run faster and improve performance. I am wondering what everyone else thinks? Thanks, Scott ...
I have my development database, I want to spin off a duplicate for testing. I want to do this often. What's the fastest and easiest way to do this often? I can get the job done by generating scripts w/ data included but I feel like there must be a better way. Should I back up database 1 then screw around with it so I can restore it a...
I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server? ...
I have a stored procedure that does a lot more reads when the NOLOCK hint is added to the query. I'm baffled - does anyone know why, please? Details: The query is: SELECT * FROM dbo.<table-name> WITH (NOLOCK). It was doing 40,000 reads and there are less than 2,000 rows. I established that most of these reads are caused by 3 TEXT co...