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