Archive of microsoft.public.sqlserver.programming for February 2008
The following articles have been archived for February 2008 from microsoft.public.sqlserver.programming:
- ORDER BY error posted on Fri, 29 Feb 2008
- Table scan on indexed column posted on Fri, 29 Feb 2008
- sqlBulkCopy fails on 2005 posted on Fri, 29 Feb 2008
- Like TOTALLY Newbie question - query creation tools posted on Fri, 29 Feb 2008
- 3rd Normal Form, Process a column to create more rows posted on Fri, 29 Feb 2008
- getting rid of repeats in a self-join posted on Fri, 29 Feb 2008
- How to calculate sum of Amount for a group of lines? posted on Fri, 29 Feb 2008
- Simple way to swap rows to columns (not cross-tab) posted on Fri, 29 Feb 2008
- What is this code attempting to do? CASE posted on Fri, 29 Feb 2008
- passing parameters to proc posted on Fri, 29 Feb 2008
- Windows Authentication Mode. posted on Fri, 29 Feb 2008
- XQuery on Execution Plans XML posted on Fri, 29 Feb 2008
- temp database posted on Fri, 29 Feb 2008
- select top n unique records from table posted on Fri, 29 Feb 2008
- XQUERY big problem posted on Fri, 29 Feb 2008
- How to use result set posted on Fri, 29 Feb 2008
- Communication Link failure posted on Thu, 28 Feb 2008
- Changing an existing column to Identity posted on Thu, 28 Feb 2008
- Delete togethre will are Foreign Key posted on Thu, 28 Feb 2008
- evaluation expression with <> OR = posted on Thu, 28 Feb 2008
- Question About Deleting Similar Records posted on Thu, 28 Feb 2008
- Select Most Recent posted on Thu, 28 Feb 2008
- Ficticious Test Data posted on Thu, 28 Feb 2008
- Duplicate row using ASP---Indexes---Performance posted on Thu, 28 Feb 2008
- Altering data type length in a replicated database posted on Thu, 28 Feb 2008
- Proper method of reserving IDs posted on Thu, 28 Feb 2008
- Analyzing membership "churn" -- gap duration and frequency posted on Thu, 28 Feb 2008
- prob selecting only rows where values contain '_' underscore char posted on Thu, 28 Feb 2008
- Regarding Table partitioning posted on Thu, 28 Feb 2008
- problem with if...else logic posted on Thu, 28 Feb 2008
- Refresh Table Contents posted on Thu, 28 Feb 2008
- search for string in all objects on server posted on Thu, 28 Feb 2008
- Profiler posted on Thu, 28 Feb 2008
- Detach/Attach SQL Server Express DB from VB6 posted on Thu, 28 Feb 2008
- Help with update query posted on Thu, 28 Feb 2008
- Database Mail. How do you restart. posted on Thu, 28 Feb 2008
- very easy question posted on Thu, 28 Feb 2008
- problem inserting into a temporary table posted on Thu, 28 Feb 2008
- querying database constraints from information_schema posted on Thu, 28 Feb 2008
- Hunting an example to show the different use of trigger in sql. posted on Thu, 28 Feb 2008
- UDF performance greatly depends on the length of varchar parameter. Is it normal posted on Wed, 27 Feb 2008
- Test to Binary posted on Wed, 27 Feb 2008
- Performance of a UDF has degraded suddenly posted on Wed, 27 Feb 2008
- sp_executesql and return code posted on Wed, 27 Feb 2008
- New Search Functions posted on Wed, 27 Feb 2008
- Filters reset to defaults in ASP files posted on Wed, 27 Feb 2008
- Maitenance task not running correctly after t-sql task executes posted on Wed, 27 Feb 2008
- Table not showing up in system view posted on Wed, 27 Feb 2008
- Can't delete record posted on Wed, 27 Feb 2008
- Table partitioning in SQL 2005 posted on Wed, 27 Feb 2008
- SQL Replication and Views posted on Wed, 27 Feb 2008
- Selecting data from temp table into permanent table posted on Wed, 27 Feb 2008
- Having a job sending seperate emails based on when it completes & posted on Wed, 27 Feb 2008
- Help in speeding up a SP. posted on Wed, 27 Feb 2008
- LIKE Statement with a variable? posted on Wed, 27 Feb 2008
- updating records with 1 to 01 for proper ordering posted on Wed, 27 Feb 2008
- copy record procedure posted on Wed, 27 Feb 2008
- You have been choose as... or Deadlock detection posted on Wed, 27 Feb 2008
- exec, parseonly and try/catch posted on Wed, 27 Feb 2008
- Select Recordset problem.... posted on Wed, 27 Feb 2008
- select in case statement not working posted on Wed, 27 Feb 2008
- Getting the record from a set with the latest date posted on Wed, 27 Feb 2008
- Should every database dbo user be mapped to the sa login? posted on Wed, 27 Feb 2008
- Split column into multiple rows and also keep other columns as wel posted on Wed, 27 Feb 2008
- Insert into master-slave (base class-subclass) structure posted on Wed, 27 Feb 2008
- ANSI SQL execution sequence? posted on Wed, 27 Feb 2008
- find - replace posted on Wed, 27 Feb 2008
- OUTER JOIN Confusion posted on Wed, 27 Feb 2008
- bcp and global temp tables posted on Wed, 27 Feb 2008
- NO CHECK WHEN ALTER posted on Wed, 27 Feb 2008
- How to use query return value within second query? posted on Wed, 27 Feb 2008
- Querying Currently Logged in User posted on Wed, 27 Feb 2008
- How to insert these records? posted on Tue, 26 Feb 2008
- Creating a Unique Constraint posted on Tue, 26 Feb 2008
- Delete Tables posted on Tue, 26 Feb 2008
- BULK INSERT and Identity posted on Tue, 26 Feb 2008
- OPENROWSET CSV posted on Tue, 26 Feb 2008
- top posted on Tue, 26 Feb 2008
- SQL Server 2005 Partitioned Tables posted on Tue, 26 Feb 2008
- What sql command tells us the table structure? posted on Tue, 26 Feb 2008
- script or way to find 'Hint' and keyword from SPs posted on Tue, 26 Feb 2008
- UDF/Stored Proc recommendations posted on Tue, 26 Feb 2008
- Breakpoint & Stepping posted on Tue, 26 Feb 2008
- Function Call in Where Clause posted on Tue, 26 Feb 2008
- Where would a backup job be located? posted on Tue, 26 Feb 2008
- Help converting lists to features and retaining existing content posted on Tue, 26 Feb 2008
- Database for Hotel Online Availability posted on Tue, 26 Feb 2008
- Define variable posted on Tue, 26 Feb 2008
- Unable to initiate DCOM communication trying to debug t-sql posted on Tue, 26 Feb 2008
- CAN't create a new project posted on Tue, 26 Feb 2008
- Number to nvarchar posted on Tue, 26 Feb 2008
- Use function posted on Tue, 26 Feb 2008
- Join two columns from two queries posted on Tue, 26 Feb 2008
- Variable like Record (in Pascal) in T-SQL posted on Tue, 26 Feb 2008
- Question on database design posted on Tue, 26 Feb 2008
- SELECT ... GROUP BY int, char, char posted on Tue, 26 Feb 2008
- SQL server 2000 suser_sname does not capture windows group posted on Tue, 26 Feb 2008
- SQLDateTime Overflow inserting DateTime that is Nothing posted on Tue, 26 Feb 2008
- paralel execution posted on Tue, 26 Feb 2008
- Database already in use posted on Tue, 26 Feb 2008
- can some one help me plz posted on Mon, 25 Feb 2008
- conditional TSQL posted on Mon, 25 Feb 2008
- Incorrect syntax near the keyword 'ORDER'. posted on Mon, 25 Feb 2008
- give me an example of using the index in sql posted on Mon, 25 Feb 2008
- FindStr posted on Mon, 25 Feb 2008
- Log changes to a table posted on Mon, 25 Feb 2008
- Execution plan: strange timings posted on Mon, 25 Feb 2008
- 32 bit on 64 bit posted on Mon, 25 Feb 2008
- SQL2000.AS-KB884525-SP4-x86-ENU.EXE posted on Mon, 25 Feb 2008
- Do I need a Go? posted on Mon, 25 Feb 2008
- DataType for ID field for Journal entries posted on Mon, 25 Feb 2008
- Double Decker CTEs? posted on Mon, 25 Feb 2008
- TSQL question posted on Mon, 25 Feb 2008
- Random Numbers and Dates posted on Mon, 25 Feb 2008
- Union All in Management Studio issues Syntax error posted on Mon, 25 Feb 2008
- sp_OACreate + Sql Server 2005 problem! posted on Mon, 25 Feb 2008
- XML Question posted on Mon, 25 Feb 2008
- Build One row from 3 rows of SQL Table. posted on Mon, 25 Feb 2008
- Dump records as SQL file posted on Mon, 25 Feb 2008
- Will SQL Server Developer Edition 2005 run on Vista Home Premium / posted on Mon, 25 Feb 2008
- Address field error converting to 'proper' posted on Mon, 25 Feb 2008
- Paralel execution posted on Mon, 25 Feb 2008
- null value in stored procedure posted on Mon, 25 Feb 2008
- problems related to the MSSQLSERVER service posted on Mon, 25 Feb 2008
- Execution Plan XQuery / XPath examples posted on Mon, 25 Feb 2008
- SQL2005 INSERT is too slow posted on Mon, 25 Feb 2008
- SQL Server Programming Issue -- Please help posted on Mon, 25 Feb 2008
- hey iam stuck plz help :( posted on Sun, 24 Feb 2008
- SQL database hang posted on Sun, 24 Feb 2008
- Query related to date posted on Sun, 24 Feb 2008
- Random Values and Dates posted on Sun, 24 Feb 2008
- Combining 2 queries posted on Sun, 24 Feb 2008
- Script to create users, map them to a database, and give them permissions posted on Sun, 24 Feb 2008
- Excel 2003 Linked Server posted on Sun, 24 Feb 2008
- sparse columns using more storage :-( posted on Sun, 24 Feb 2008
- Create Dummy Data posted on Sun, 24 Feb 2008
- multiple table joining problem posted on Sat, 23 Feb 2008
- Return Error Code posted on Sat, 23 Feb 2008
- XML Data source .. Expression? Variable? Connection? Error: unable to read the X posted on Sat, 23 Feb 2008
- Troubleshooting SSIS packages .. anybody? posted on Sat, 23 Feb 2008
- rearrange columns in select statement posted on Sat, 23 Feb 2008
- Delete Duplicates posted on Sat, 23 Feb 2008
- Internal SQL Server error. Group by in inner query?? posted on Fri, 22 Feb 2008
- Do not select rows with multiple columns = 0 posted on Fri, 22 Feb 2008
- Error during Procedure Execution posted on Fri, 22 Feb 2008
- Recursive Query posted on Fri, 22 Feb 2008
- Update Roles for users in DB1 to those in DB2, safe to usr sysusers? posted on Fri, 22 Feb 2008
- xml modify posted on Fri, 22 Feb 2008
- OSQL query error posted on Fri, 22 Feb 2008
- concatenate in computed column posted on Fri, 22 Feb 2008
- Order By / Sorting problem posted on Fri, 22 Feb 2008
- Is it possible to use CTE in a function? posted on Fri, 22 Feb 2008
- checking if #temptable exists posted on Fri, 22 Feb 2008
- sp_changeobjectowner vs alter schema posted on Fri, 22 Feb 2008
- Horizontal rather than Vertical posted on Fri, 22 Feb 2008
- Show All Clients where last Client Advert Less than DateADD(d,90 G posted on Fri, 22 Feb 2008
- Stored Procedure Help??? posted on Fri, 22 Feb 2008
- Dynamic Management Views posted on Fri, 22 Feb 2008
- Last inserted record posted on Fri, 22 Feb 2008
- Nested views - locking posted on Fri, 22 Feb 2008
- Q: Stored Procedure posted on Fri, 22 Feb 2008
- creating temporary table posted on Fri, 22 Feb 2008
- File not Create thru sp_cmdshell posted on Thu, 21 Feb 2008
- @@ROWCOUNT posted on Fri, 22 Feb 2008
- Obscure SQL CLR exception posted on Thu, 21 Feb 2008
- view to return column properties? posted on Thu, 21 Feb 2008
- Logical Operators posted on Thu, 21 Feb 2008
- Quartely time series ordering posted on Thu, 21 Feb 2008
- what kind of join is this? posted on Thu, 21 Feb 2008
- Sequence posted on Thu, 21 Feb 2008
- Best way to coordinate native date format between client and server? posted on Thu, 21 Feb 2008
- SQL Component to parse SQL posted on Thu, 21 Feb 2008
- LIKE IN posted on Thu, 21 Feb 2008
- Grouping with Max posted on Thu, 21 Feb 2008
- Select More than 1 column from a Nested Select posted on Thu, 21 Feb 2008
- Add Column question posted on Thu, 21 Feb 2008
- calculation question posted on Thu, 21 Feb 2008
- INSERT INTO....SELECT posted on Thu, 21 Feb 2008
- Newbie: Adding a value to max() posted on Thu, 21 Feb 2008
- SQL SERVER 2000 posted on Thu, 21 Feb 2008
- Cannot query SQL2005 from 2008CTP posted on Thu, 21 Feb 2008
- Lookup Transformation in SSIS posted on Thu, 21 Feb 2008
- The precision is invalid posted on Thu, 21 Feb 2008
- Retrieving SQL statement that fired a trigger posted on Thu, 21 Feb 2008
- dts versions posted on Thu, 21 Feb 2008
- Force Default value on NOT NULL column when NULL is passed? posted on Thu, 21 Feb 2008
- Converting varchar to datetime posted on Thu, 21 Feb 2008
- How to Prevent Log from Filling Up on When Saving Table in SSMS? posted on Thu, 21 Feb 2008
- an error on sql server posted on Thu, 21 Feb 2008
- Reindexing posted on Wed, 20 Feb 2008
- Query preventing other from updating the same table posted on Thu, 21 Feb 2008
- should i use function or one sql statement posted on Wed, 20 Feb 2008
- How to find relationship between tables posted on Wed, 20 Feb 2008
- MSSQL ODBC And Transactions posted on Wed, 20 Feb 2008
- how to create a .sql file posted on Wed, 20 Feb 2008
- help with statement please posted on Wed, 20 Feb 2008
- Looping in stored procedure using WHILE posted on Wed, 20 Feb 2008
- convert unix timestamp to SQL Dates posted on Wed, 20 Feb 2008
- Backup catalog... posted on Wed, 20 Feb 2008
- What is a cube? posted on Wed, 20 Feb 2008
- Error: Invalid Column name .. trying to avoid calling function twice .. Column posted on Wed, 20 Feb 2008
- anyway to check if a string is a date? posted on Wed, 20 Feb 2008
- text column inside a triggerMsg 311, Level 16, State 1, Procedure _acg_makehisto posted on Wed, 20 Feb 2008
- Which update statement is better? Or does it matter? posted on Wed, 20 Feb 2008
- dm_db_index_physical_stats posted on Wed, 20 Feb 2008
- SQL Server Procedure call from ADO not returning the correct error code posted on Wed, 20 Feb 2008
- Left Join of with BEST right match. posted on Wed, 20 Feb 2008
- Migration from Access DB to SQL Server posted on Wed, 20 Feb 2008
- Change table schema posted on Wed, 20 Feb 2008
- Bizarre Error on ODBC call posted on Wed, 20 Feb 2008
- dts storage types pros and cons posted on Wed, 20 Feb 2008
- Task not failing in DTS posted on Wed, 20 Feb 2008
- combine 2 queries into 1 posted on Wed, 20 Feb 2008
- Changing Column Length of one field in all the SQL objects (Tables/Stored proced posted on Wed, 20 Feb 2008
- SQL Question... posted on Wed, 20 Feb 2008
- PIVOT command do not work for count(distinct xxx) posted on Wed, 20 Feb 2008
- getting local IP on sql server posted on Wed, 20 Feb 2008
- select query on table on different servers posted on Wed, 20 Feb 2008
- Find name of 1st table that fires trigger posted on Wed, 20 Feb 2008
- Insert Default Values in a table posted on Tue, 19 Feb 2008
- NewSequentialID posted on Wed, 20 Feb 2008
- Increment Primary Key Value with a Trigger posted on Tue, 19 Feb 2008
- number after decimal point got truncated. posted on Tue, 19 Feb 2008
- How to find out the difference of row counts of two tables. posted on Tue, 19 Feb 2008
- Where is a constraint definition stored? posted on Wed, 20 Feb 2008
- Search Critera in Stored Procedure posted on Tue, 19 Feb 2008
- Microsoft SQL Server Management Studio 2005 posted on Tue, 19 Feb 2008
- How to compare for the null-ness posted on Tue, 19 Feb 2008
- Add Related Tables to a Diagram in 2005 posted on Tue, 19 Feb 2008
- display only rows with dates that contain hrs/minutes > 00:00:00 posted on Tue, 19 Feb 2008
- Variation on "latest order" query posted on Tue, 19 Feb 2008
- Comparing 2 fields from 2 different databases and them importing data from one f posted on Tue, 19 Feb 2008
- Comparing 2 fields from 2 different databases and them importing data from one f posted on Tue, 19 Feb 2008
- xp_cmdshell Not Doing Much posted on Tue, 19 Feb 2008
- combine two columns posted on Tue, 19 Feb 2008
- Use Nested Set for store multiple trees in the same table posted on Tue, 19 Feb 2008
- management studio question posted on Tue, 19 Feb 2008
- nvarchar field question. posted on Tue, 19 Feb 2008
- coalesce type function that returns highest or lowest value from a list posted on Tue, 19 Feb 2008
- Results as Columns Problem posted on Tue, 19 Feb 2008
- SQL 2000 Scalar Function advice posted on Tue, 19 Feb 2008
- There were errors configuring the data adapter Generated SELECT statement posted on Tue, 19 Feb 2008
- Scripting server objects in alphabetical order posted on Tue, 19 Feb 2008
- Trivial SQL syntax error posted on Tue, 19 Feb 2008
- tricky grouping posted on Tue, 19 Feb 2008
- SQL database users/roles posted on Tue, 19 Feb 2008
- please help posted on Mon, 18 Feb 2008
- Why is this nondeterministic? posted on Mon, 18 Feb 2008
- T-SQL Help: Matching a Comma Separated List posted on Mon, 18 Feb 2008
- SQL2005 - Linked Server View posted on Mon, 18 Feb 2008
- Need Query Where Field is One of Any Number of Variables posted on Mon, 18 Feb 2008
- retrieve all indexes posted on Mon, 18 Feb 2008
- New Table - 2000 vs 2005 posted on Mon, 18 Feb 2008
- Get user from ODBC connection posted on Mon, 18 Feb 2008
- flushing print output to the query window posted on Mon, 18 Feb 2008
- ExecPackageTask in DTS package doesn't get called when triggering from Job posted on Mon, 18 Feb 2008
- How to find table names from stored proc posted on Mon, 18 Feb 2008
- SQL Server 2000 - String Manipulation posted on Mon, 18 Feb 2008
- Any way to trap the use of SELECT on particular tables and columns or trap the u posted on Mon, 18 Feb 2008
- Any way to TRIGGER on a SELECT event posted on Mon, 18 Feb 2008
- sql2000: performance of table-returning functions versus views? posted on Mon, 18 Feb 2008
- Need help creating a concatenated string posted on Mon, 18 Feb 2008
- Remove non-digit characters from a string. posted on Mon, 18 Feb 2008
- xp_smtp_sendmail - attachment from substed drive - access violation? posted on Mon, 18 Feb 2008
- Is Not NULL still returning a NULL date?? posted on Mon, 18 Feb 2008
- using row_number() in an update statement posted on Mon, 18 Feb 2008
- will a trigger do this,.. posted on Mon, 18 Feb 2008
- Last day of month, 3 months from now? posted on Mon, 18 Feb 2008
- importing dts package from file into sql server posted on Mon, 18 Feb 2008
- Numeric Sort of Strings posted on Mon, 18 Feb 2008
- SQL datatypes - which ones use Length, and which ones Precision/Scale? posted on Mon, 18 Feb 2008
- not equal operators... posted on Mon, 18 Feb 2008
- use CONVERT(...) if there is error posted on Mon, 18 Feb 2008
- SSMS UI question posted on Mon, 18 Feb 2008
- Question about "TOP" for sqlserver 2000 posted on Sun, 17 Feb 2008
- Date Range posted on Mon, 18 Feb 2008
- Debugging the "Warning: Null value..." warning posted on Sun, 17 Feb 2008
- Connection failure error (by ADO) - anything special about it? posted on Mon, 18 Feb 2008
- Could Someone Verify My Syntax? posted on Sun, 17 Feb 2008
- Help locating records with specific values and EXCLUDING other values posted on Sun, 17 Feb 2008
- Bifurcate Table Name posted on Sun, 17 Feb 2008
- Specify the size of table posted on Sun, 17 Feb 2008
- sql output easy question posted on Sat, 16 Feb 2008
- Selecting proper column based on value from another table posted on Sat, 16 Feb 2008
- Created a secondary file group, how to move data from primary? posted on Sat, 16 Feb 2008
- Prefix column name with table name? posted on Sat, 16 Feb 2008
- profile provider posted on Sat, 16 Feb 2008
- Cant add a row to Access query against SQl Server posted on Sat, 16 Feb 2008
- Calculating cumulative product from previous row (without using cursors) posted on Sat, 16 Feb 2008
- How to loop through records posted on Sat, 16 Feb 2008
- help needed for a query posted on Sat, 16 Feb 2008
- Difference between version posted on Sat, 16 Feb 2008
- Help translating queries ... posted on Sat, 16 Feb 2008
- Summing rows posted on Sat, 16 Feb 2008
- Please help SQL Dump papers needed(ALL) posted on Fri, 15 Feb 2008
- Restoring state of database after running a Unit test posted on Fri, 15 Feb 2008
- performance hit question - Joining multiple views in a stored proc. posted on Fri, 15 Feb 2008
- Table Spool / Eager Spool posted on Fri, 15 Feb 2008
- Two separete Windows Login for two different databases posted on Fri, 15 Feb 2008
- calculating correlation coefficient posted on Fri, 15 Feb 2008
- Visual Studio Versions posted on Fri, 15 Feb 2008
- Implementing On Cascade Delete (traversing constraint graph) posted on Fri, 15 Feb 2008
- Can not insert into table with UID index posted on Fri, 15 Feb 2008
- Unique Key posted on Fri, 15 Feb 2008
- How to cancel an input in the middle posted on Fri, 15 Feb 2008
- Calling a Proc in a CASE WHEN? posted on Fri, 15 Feb 2008
- mm/dd/yyyy from datetime posted on Fri, 15 Feb 2008
- Group of records where a counter isn't continuous - want to make it continous. posted on Fri, 15 Feb 2008
- Upgrading query that uses status in sys.indexes posted on Fri, 15 Feb 2008
- Wish List: CONCAT() string concatenation aggregate operator posted on Fri, 15 Feb 2008
- LOGON trigger question posted on Fri, 15 Feb 2008
- How to change back into a null value posted on Fri, 15 Feb 2008
- WorkAround For Invoking AFTER UPDATE Trigger Post Update via Write posted on Fri, 15 Feb 2008
- Determine if date range contains the last day of the month posted on Fri, 15 Feb 2008
- SQL problem in SS2000 posted on Fri, 15 Feb 2008
- SP with sp_executesql like signature (variable number and type of parameters) posted on Fri, 15 Feb 2008
- MSSQL2005 import data from AS400 posted on Fri, 15 Feb 2008
- Select Distinct for Only 1 Column posted on Thu, 14 Feb 2008
- VS 2005 Pro (SP1) Hangs when I click [Stop Debugging] while stepping into a SQL posted on Thu, 14 Feb 2008
- Login failed for user ''. The user is not associated with a trusted SQL Server c posted on Thu, 14 Feb 2008
- Flagging Reversals in SQL posted on Thu, 14 Feb 2008
- expresseion will Cast to a decimal(15), but not to a bigint posted on Thu, 14 Feb 2008
- Help with delete large amount of rows with image column posted on Thu, 14 Feb 2008
- Need help with creating a view posted on Thu, 14 Feb 2008
- regular expressions posted on Thu, 14 Feb 2008
- Right way to preserve all parent table entries in a join with many tables!! posted on Thu, 14 Feb 2008
- Identity columns question posted on Fri, 15 Feb 2008
- Seperate Databases and Business Logic.. SQL vs. .NET code?? Design Ideas/Differe posted on Thu, 14 Feb 2008
- SQL server permissions for MS Access file? posted on Thu, 14 Feb 2008
- XML text as a table posted on Thu, 14 Feb 2008
- Current data snapshot posted on Thu, 14 Feb 2008
- IN vs. OR posted on Thu, 14 Feb 2008
- How to do Crosstab posted on Thu, 14 Feb 2008
- Get last SQL Statement to execute on error? posted on Thu, 14 Feb 2008
- Sql Server Simultaneous Transactions posted on Thu, 14 Feb 2008
- No Clustered Indexes?!? posted on Thu, 14 Feb 2008
- How get latest record per FK in a table? posted on Thu, 14 Feb 2008
- Comparison Tools of Two Identical SQL Server DB posted on Thu, 14 Feb 2008
- Query with a computed field posted on Thu, 14 Feb 2008
- Manipulating variable of data type Object in Script task posted on Thu, 14 Feb 2008
- datediff function posted on Thu, 14 Feb 2008
- importing data - philosophical question posted on Thu, 14 Feb 2008
- Retrieve Description or Extended Properties as part of query posted on Thu, 14 Feb 2008
- UDF For Column Default Value.. posted on Thu, 14 Feb 2008
- isNull default posted on Thu, 14 Feb 2008
- simple T-SQL question posted on Thu, 14 Feb 2008
- deadlock in SQL Server 2000 posted on Thu, 14 Feb 2008
- Pivot to get the result? posted on Thu, 14 Feb 2008
- change data stored row by row, to be col based data posted on Thu, 14 Feb 2008
- MS SQL Linked Server Issue posted on Thu, 14 Feb 2008
- uniqueidentifier column in c#? posted on Wed, 13 Feb 2008
- Creating views on the fly posted on Thu, 14 Feb 2008
- Multiple lookups to same table posted on Wed, 13 Feb 2008
- Backup Error Message posted on Wed, 13 Feb 2008
- Modifying an Existing Stored Procedure posted on Wed, 13 Feb 2008
- Concat string in strored procedure posted on Wed, 13 Feb 2008
- apostrohie search posted on Wed, 13 Feb 2008
- convert CTE to left outer joins posted on Wed, 13 Feb 2008
- COLUMN_DEFAULT returns NULL for columns in views posted on Wed, 13 Feb 2008
- Maddening SSIS posted on Wed, 13 Feb 2008
- Switch of exceptions in SQL Server 2005 posted on Wed, 13 Feb 2008
- Query on Latin1 charaters posted on Wed, 13 Feb 2008
- Need to get SP param in/out direction posted on Wed, 13 Feb 2008
- SELECT across 3 tables posted on Wed, 13 Feb 2008
- Stored Procedure Slow Problem posted on Wed, 13 Feb 2008
- Running Batches posted on Wed, 13 Feb 2008
- Katmai: Logging User info with Change Data Capture (CDC)? posted on Wed, 13 Feb 2008
- Best way to do this posted on Wed, 13 Feb 2008
- Do not want to count nulls posted on Tue, 12 Feb 2008
- Obtaining the length of a variable posted on Tue, 12 Feb 2008
- Linked server and calculated column posted on Tue, 12 Feb 2008
- SQl Server holds database files posted on Tue, 12 Feb 2008
- Searching for duplicates posted on Tue, 12 Feb 2008
- Question on joins posted on Tue, 12 Feb 2008
- Select a maximum of rows in a group by posted on Tue, 12 Feb 2008
- calulate 2 columns from 2 different tables posted on Tue, 12 Feb 2008
- Autoincrement column posted on Tue, 12 Feb 2008
- decimal value formatting posted on Tue, 12 Feb 2008
- Domains messing with my code posted on Tue, 12 Feb 2008
- Office 2007 Color Palette posted on Tue, 12 Feb 2008
- alter table column posted on Tue, 12 Feb 2008
- Connection String For Windows Authentication posted on Tue, 12 Feb 2008
- Remote sp_OA posted on Tue, 12 Feb 2008
- Locking performance in SQL Server 2005 posted on Tue, 12 Feb 2008
- Tricky for me, maybe not you! posted on Tue, 12 Feb 2008
- Putting a sequence number against a record in a select statement posted on Tue, 12 Feb 2008
- data type lengths posted on Tue, 12 Feb 2008
- UNION in SQL Server 2005 posted on Tue, 12 Feb 2008
- Ignore non significant row using self join? posted on Tue, 12 Feb 2008
- grouping in 5 min intervals posted on Mon, 11 Feb 2008
- Tips on Idenitty columns and Temp tables? posted on Mon, 11 Feb 2008
- Can't join tables from two databases using linked servers when DBs on same SQL i posted on Mon, 11 Feb 2008
- Insert select from 2 tables posted on Mon, 11 Feb 2008
- Days not already booked this week logic. Available dates ? posted on Mon, 11 Feb 2008
- Parameters and Plan posted on Mon, 11 Feb 2008
- How do I modify an SPROC grayed out? posted on Mon, 11 Feb 2008
- Multi thread inserts into a table with Identity column as primary posted on Mon, 11 Feb 2008
- need to call sys SP to get info about a stored procedure posted on Mon, 11 Feb 2008
- dbo owns objects? or not? posted on Mon, 11 Feb 2008
- Query Active Directory from SQL posted on Mon, 11 Feb 2008
- Deadlocking when running this procedure in stress testing:Standalone running no posted on Mon, 11 Feb 2008
- Simple question on SQL Query posted on Mon, 11 Feb 2008
- Pivot question posted on Mon, 11 Feb 2008
- adding two columns together posted on Mon, 11 Feb 2008
- sql server 2005 database in restore mode posted on Mon, 11 Feb 2008
- Varbinary(max) or image? posted on Mon, 11 Feb 2008
- Need to get current and YTD posted on Mon, 11 Feb 2008
- filling gaps posted on Mon, 11 Feb 2008
- DATEDIFF rounding posted on Mon, 11 Feb 2008
- sp_update_schedule error posted on Mon, 11 Feb 2008
- how to read which database I'm in? posted on Mon, 11 Feb 2008
- Preferred way to synchronize lookup table with .NET application posted on Mon, 11 Feb 2008
- Cross database dependencies on surrogate key, all gurus HELP! posted on Mon, 11 Feb 2008
- Reasonably easy SQL statement - need some help! posted on Sun, 10 Feb 2008
- List -Multiple selections - Newbie needs help posted on Sun, 10 Feb 2008
- List of Functions in a DB posted on Sat, 9 Feb 2008
- How to make VFP9SP1 read MSSQL2K5's varchar(MAX) as Memo instead of C(0) ? posted on Sun, 10 Feb 2008
- Need help with DTS posted on Sat, 9 Feb 2008
- Update Query Help posted on Fri, 8 Feb 2008
- LEFT OUTER JOIN Help posted on Fri, 8 Feb 2008
- Question on passing parameter to Stored Procedure. HELP posted on Fri, 8 Feb 2008
- Table Insert triggered by Active Directory change posted on Fri, 8 Feb 2008
- RTF and Stored Procedure posted on Fri, 8 Feb 2008
- How to extract records posted on Fri, 8 Feb 2008
- Back outs posted on Fri, 8 Feb 2008
- query OLE DB error posted on Fri, 8 Feb 2008
- how to update data based on data from a select query posted on Fri, 8 Feb 2008
- BIGINT posted on Fri, 8 Feb 2008
- How to insert or select posted on Fri, 8 Feb 2008
- Search Help Needed posted on Fri, 08 Feb 2008
- Converting HEX in nvarchar field posted on Fri, 8 Feb 2008
- Insert PDF - Newbie Needs Help posted on Fri, 08 Feb 2008
- Insert PDF - Newbie Needs Help posted on Fri, 08 Feb 2008
- ntext col in WHERE clause posted on Thu, 7 Feb 2008
- Create drop and recreate a temp table - why doesn't this work? posted on Thu, 7 Feb 2008
- Need help with T-SQL. IF-Else Statement posted on Thu, 7 Feb 2008
- Dynamic Partitioned Views? posted on Fri, 08 Feb 2008
- SQL Server Express databases posted on Thu, 7 Feb 2008
- RAD apps for db development posted on Fri, 8 Feb 2008
- SQL to get latest result and pull only one line for the OrderResc: posted on Fri, 08 Feb 2008
- Reformed access user needs advise for future posted on Thu, 7 Feb 2008
- how to add a Month to a date (stored procedure) posted on Thu, 7 Feb 2008
- Best practices for accessing Views posted on Thu, 7 Feb 2008
- Job posted on Thu, 7 Feb 2008
- Permissions and Bulk Insert posted on Thu, 7 Feb 2008
- Insert selected records posted on Thu, 7 Feb 2008
- Insert/Update Trigger help posted on Thu, 7 Feb 2008
- Count using sys.partitions catalog view posted on Thu, 7 Feb 2008
- Openquery and Joins posted on Thu, 7 Feb 2008
- Programming ODBC and table compare posted on Thu, 7 Feb 2008
- Calling .net exe file from within SSIS script task. posted on Thu, 07 Feb 2008
- I need to use MD5 hashing, RSA encryption from SQL Server 2000... posted on Thu, 7 Feb 2008
- print statment output immediate posted on Thu, 7 Feb 2008
- Convert varchar value to execute a function posted on Thu, 7 Feb 2008
- more effective way for this query posted on Thu, 7 Feb 2008
- pdf/chm for Microsoft exams posted on Thu, 7 Feb 2008
- Why Does xp_sendmail Always Creates Using Unicode? posted on Thu, 7 Feb 2008
- dts 2000 designer bug? posted on Thu, 07 Feb 2008
- SQL statement for calculation used memory posted on Thu, 07 Feb 2008
- how will you check using a T-SQL query (on system tables) that what has changed posted on Wed, 6 Feb 2008
- Image data type and text posted on Wed, 6 Feb 2008
- Transactional Replication SQL Server 2000 posted on Wed, 6 Feb 2008
- Using a view posted on Wed, 6 Feb 2008
- Dynamic SQL row value to column name posted on Wed, 6 Feb 2008
- having a sp do a select from a table where the table name is a var posted on Wed, 6 Feb 2008
- Keeping a table current. SSIS? Help.. Thank you. posted on Wed, 6 Feb 2008
- Finding similar company names in table posted on Wed, 6 Feb 2008
- Book on schema design posted on Wed, 6 Feb 2008
- Need help with a query posted on Wed, 6 Feb 2008
- Help with basic Group By mis understanding please posted on Wed, 6 Feb 2008
- table naming convention confusion posted on Wed, 6 Feb 2008
- Dynamic SQL execute as calling user? posted on Wed, 6 Feb 2008
- row level security posted on Wed, 6 Feb 2008
- FullText Index Search posted on Wed, 6 Feb 2008
- search between strings... posted on Wed, 6 Feb 2008
- lot allocation query posted on Wed, 6 Feb 2008
- Is Celko really Chuck Norris of the SQL World? posted on Wed, 6 Feb 2008
- Strange control-of-flow problem in T-SQL posted on Wed, 6 Feb 2008
- collasion posted on Wed, 6 Feb 2008
- SQL Server 2008 models question. posted on Wed, 6 Feb 2008
- Audit:Login posted on Wed, 6 Feb 2008
- Set a global filter on a table posted on Wed, 6 Feb 2008
- whether a table is a table on a subscription data base posted on Tue, 5 Feb 2008
- How to get the status of SQL instance? posted on Tue, 5 Feb 2008
- Boolean/Bitwise Expressions posted on Tue, 5 Feb 2008
- DateTime, Date and Time? posted on Wed, 6 Feb 2008
- DTS and Server Agent posted on Tue, 5 Feb 2008
- Where is T-SQL help in MS SQL 2005 Management Studio? posted on Tue, 5 Feb 2008
- copy a job from one server to another.... posted on Tue, 5 Feb 2008
- cursor question posted on Tue, 5 Feb 2008
- Fastload, context connection and CLR stored procs posted on Tue, 5 Feb 2008
- One to One relationship posted on Tue, 5 Feb 2008
- =?Utf-8?Q?is_it_possible_to_build_a_trigge?= =?Utf-8?Q?r_that_looks_to_see_wheth posted on Tue, 5 Feb 2008
- update insert delete trigger - how to determine which action caused the trigger posted on Tue, 5 Feb 2008
- Problems with scalar function, and dynamic SQL posted on Tue, 5 Feb 2008
- Friday prior posted on Tue, 5 Feb 2008
- Keeping two tables in Sync Accross Servers posted on Tue, 5 Feb 2008
- Within dates posted on Tue, 5 Feb 2008
- Column that points back to original row posted on Mon, 4 Feb 2008
- Help in taking backup and restore of any number of table posted on Mon, 4 Feb 2008
- where first letter = posted on Mon, 4 Feb 2008
- Table variable performance degradation in stored procedures posted on Mon, 04 Feb 2008
- bcp_bind with double posted on Mon, 4 Feb 2008
- Display records that do and don't match criteria posted on Mon, 4 Feb 2008
- Exists statement in SQL 2005 posted on Mon, 04 Feb 2008
- crosstabbing (or rotating) a sql table posted on Mon, 4 Feb 2008
- SQL Server 2005: how to find database_id (Initial catalog) for each session_id posted on Mon, 4 Feb 2008
- Database in recovery mode posted on Mon, 4 Feb 2008
- Exclusively lock database during multiple SELECT, UPDATE and INSERT operations posted on Mon, 4 Feb 2008
- help optimizing deleting large number of rows from table posted on Mon, 4 Feb 2008
- concurrent insert problem posted on Mon, 4 Feb 2008
- Creating Stored procedure that uses Linked Server posted on Mon, 4 Feb 2008
- Money and Accuracy posted on Mon, 04 Feb 2008
- Stored Procedure that checks to see whether a value exists and ent posted on Mon, 4 Feb 2008
- Documenting Reports and associated views. posted on Mon, 4 Feb 2008
- Windows SID posted on Mon, 4 Feb 2008
- Matrix Query posted on Mon, 4 Feb 2008
- sending table on email posted on Mon, 4 Feb 2008
- Help with SQL Query and performance posted on Mon, 4 Feb 2008
- TempDB files placement posted on Mon, 4 Feb 2008
- a convert issue posted on Mon, 04 Feb 2008
- SQL 2000 posted on Mon, 4 Feb 2008
- SQL query for this purpose posted on Sun, 3 Feb 2008
- delete or update posted on Sun, 3 Feb 2008
- Query performance is much better in SQL server 2k5. posted on Sun, 3 Feb 2008
- SQL returns different result after migrate to 2k5. posted on Sun, 3 Feb 2008
- format varchar value to decimal posted on Sun, 03 Feb 2008
- NOT statement posted on Sun, 3 Feb 2008
- GROUP BY posted on Sun, 3 Feb 2008
- BulkCopy problem posted on Sun, 3 Feb 2008
- Sql Server 2005 - time help (BETWEEN) posted on Sun, 3 Feb 2008
- Temp Table posted on Sun, 3 Feb 2008
- information_schema and extended properties posted on Sun, 3 Feb 2008
- SQL 2005 DTSRUN Utility posted on Sun, 3 Feb 2008
- SQL 2005 DTS Package with VB posted on Sun, 3 Feb 2008
- help for a complex query posted on Sun, 3 Feb 2008
- convert to new time zone posted on Sat, 2 Feb 2008
- user_objects table in sql server? posted on Sat, 2 Feb 2008
- SSIS Package Location? posted on Sat, 2 Feb 2008
- Script for setting Security Logins posted on Sat, 2 Feb 2008
- Database Project Procedure Stuck Executing posted on Sat, 2 Feb 2008
- extended properties for columns posted on Fri, 1 Feb 2008
- Integer - default value Problem posted on Sat, 2 Feb 2008
- Debug tracing with VB CLR posted on Fri, 1 Feb 2008
- Help Optimizing my query using MAX and COUNT aggregate function posted on Fri, 1 Feb 2008
- Querying a table on a smalldatetime field posted on Fri, 1 Feb 2008
- Generate a script that include all indexes in sql server 2005 posted on Fri, 1 Feb 2008
- BREAK statement in SQL Server 2000 and 2005` posted on Fri, 1 Feb 2008
- Query execution time question as relates to indexed columns posted on Fri, 1 Feb 2008
- Use Variable in Column Name posted on Fri, 1 Feb 2008
- Replication Error Log posted on Fri, 1 Feb 2008
- query question posted on Fri, 1 Feb 2008
- Can not run cursor when server error posted on Fri, 1 Feb 2008
- TEXTIMAGE_ON on existing large table? posted on Fri, 1 Feb 2008
- T-SQL Return row affected count in CLR proc? posted on Fri, 1 Feb 2008
- QUERY TOP 1 RECORD IN GROUP posted on Fri, 1 Feb 2008
- sql union only returning top query posted on Fri, 1 Feb 2008
- Best practice for connecting to SQL DB via .net web app? (web.conf posted on Fri, 1 Feb 2008
- Unable to tune stored procedure by switching indexes and code chan posted on Fri, 1 Feb 2008
- output of stored proc to command file? posted on Fri, 1 Feb 2008
- SQLCMD Output posted on Fri, 01 Feb 2008
- Identify SQL Server Installation posted on Fri, 1 Feb 2008
- Simple quotation. Is this the right way? posted on Fri, 1 Feb 2008
- Suggestions Needed posted on Fri, 1 Feb 2008
- Help with creating a pivot query posted on Fri, 1 Feb 2008
- Help needed in writting query posted on Fri, 1 Feb 2008
- MSSQL2005 -> is not updatable because a partitioning column was not found posted on Fri, 1 Feb 2008
- Script to deploy Multiple Views on 50 SQL DB's.. posted on Fri, 1 Feb 2008
- DTS-published in SQL Server Management Studio posted on Thu, 31 Jan 2008
- dynamic field name posted on Fri, 1 Feb 2008
- Date Table query posted on Thu, 31 Jan 2008
- join issue posted on Fri, 1 Feb 2008
- TSQL help .... posted on Thu, 31 Jan 2008
- determine schema owner posted on Thu, 31 Jan 2008