Let's say I have information in a table that is in the wrong database (like Customer info in the Items database). I really want to move this information, but I need to figure out who's using it. If I use this code to search for the table name, say CustomerContactNumbers, is there any possibility of things slipping by? I'm going to ignore...
Hello, We use MS Dynamics 4.0 at work for our CRM. This handles all contact management, marketing, resource sharing w/ sharepoint integration, workflow management / collaboration and essentially is used by every department in the firm in some way or another. We have requirements from business for a new application that we have a tight ...
Hi, I am having an issue with the below mentioned sql query. Basically I am trying to list all the system users that have captured data in the current week and previous week for each day. Problem with my query below I get the "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. ". I ...
I'm looking for easy way to count all rows within one SQL Server 2005/2008 database (skipping the system tables of course)? I know i could use SELECT COUNT (COLUMN) FROM TABLE and do it for each table and then add it up but would prefer some automated way? Is there one? ...
what is the difference about SCHEMA in sql server 2005 and sql server 2008? ...
I wonder what "the big guys" use to generate documents. Like credit card statements, insurance documentation, etc. We're investigating changing solutions. Here are the two that I know of: SSRS Crystal Reports Neither of these seem to be able to handle widow/orphan control well. Crystal certainly can't deal with dynamically sized p...
I'm looking for a way to non-destructively alter data. I have one table that has data that shouldn't be edited - it is the master data. I would like to have user edits on this data, but in order to maintain the integrity of the master data I've created a second table that is a mirror of the structure of the master table. My thinking i...
I have approximately 7 terabytes of various media files (pdf's, jpg's, tiff's) that currently reside on a very beefed up file server. I am looking at moving the data to SQL Server 2008 and using the Filestream attribute to help me manage the data. I want to do this because I have webpages that manage this media, and they (the webpages) a...
How can I script out my loaded SQLCLR assembly without having to go through the GUI? We like to keep the .SQL files in our source control and I would like to be able to regenerate the generated .sql for an assembly after each build/deploy of the assembly to the test database. It would be nice to know how to use relative paths (and/or ...
I'm using ADO .NET and MS SQL Server 2008. I have a connection object to a server and a command: SqlConnection conn = /* my connection*/; string cmd = "some_sql_command"; I want to check if SQL Server can execute cmd. I don't want to execute cmd, but I want to know If SQL Server can execute it. cmd can be any single SQL statement, i...
In one of my application Iam using SQL SERVER 2008, I like to implement audit tables for few tables. One option I have to create triggers on the respective tables. Can anyone suggest me any other good, robust and secure option. ...
Possible Duplicate: How to do Merge Replication? I've followed the instructions to setup merge replication. Finally, when I viewed the "Launch Replication Monitor", it is showing the warning as "Uninitialized subscription" Doesn anyone know the cause of this warning? Also, the table is not getting update,,,,, ...
Is there any in built functions in SQL server to find whether the given value is integer or currency or date or decimal? ...
I'm new to the stop list functionality in SQL 2008 and seem to be missing something obvious. I'm trying to exectue the following statement: CREATE FULLTEXT STOPLIST myStoplist3 FROM SYSTEM STOPLIST; GO and I'm getting the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'STOPLIST'. Any ideas? ...
I have a table "Scholars", that has many foreign keys to look-up tables such as Courses and Colleges. When I create a view on that table to return a subset of the Scholars (eg those who are still living), the view doesn't seem to have the same foreign keys as the table. Am I quite new to SQL Server and not sure if I am doing something w...
This thread is a continuation of http://stackoverflow.com/questions/2220422/is-there-a-reason-to-check-for-null-inside-multiple-using-clausule-in-c I've noticed that resharper lets me define using without opening any opening/closing bracket like in the method below (but then i can't use defined vars later on if the brackets ain't there,...
We have a new filestream database that will be initially loaded with 65GB data, for which we'd like to configure log shipping to a remote (different continent) location. For the initial setup of log shipping, is there any threshold for the time between the backup of the primary and it's restore onto the secondary? The new database will ...
Suppose I have a SQL query that looks like this: SELECT fName from employees where ssn=123456789; Suppose I want to follow the previous query with another one: SELECT fName from records WHERE ssn=123456789; SELECT lName from records WHERE fName=(the result of the previous query) What do I put in for (the result of the previous query)...
I am displaying a property from the following table given below. Now what i have to do is, find the property in the same location(suppose my property is located in sec-19, match for sec-19 and if none of them found there then search for the entire city) with the following condition that it should be posted 10 days back or if none is post...
I have an on update trigger in SQL Server 2008. I only need to perform the trigger action if certain columns have been modified. Thus I'd like to check what has changed. T-SQL offers an "if update( columnName )" construct. However, if many rows have been updated and only a single one of them has the particular column value changed "if...