TheMSsForum.com >> SQL Server Programming >> Archive Page 4 - The Microsoft Software Forum

view full version: back to formated view

1051: DTS package for a new folder
1052: Diffrent performance when running sp from SSMS vs Web Application
1053: change Express connection string to SQL Server 2008 string
1054: BCP Utility
1055: how do I get a rowset from xml
1056: Split a row value to 3 tables
1057: Pipe delimited File in SPROC
1058: Moving Negative Sign From Right To Left Value
1059: Let join and Left outer join
1060: Insert Trigger Update Field of Inserted Record
1061: Convert Query to SQLEXPRESS
1062: encrypting the sa password after change
1063: Odd Stored Procedure Performance
1064: Users tables design and name
1065: Efficient view with many joins?
1066: help needed on bcp command utility
1067: SQL Bug? - deadlock on a simple scenario with nonclustered index
1068: datamart - is this possible
1069: Using MQ message queues in stored procedures
1070: How to get the Store Procedure (SQL2000) last modify datetime, thanks!
1071: Bulk Insert Error
1072: send using dbmail
1073: How to go from SQL Server Express to SQL Server 2008
1074: Service Broker receive runs twice
1075: search for key
1076: Remvoing SQL SMO from SQL Server 2005
1077: milliseconds to seconds
1078: XL formulas the same as some SQL commands
1079: Retrieving list of parameter values from within a stored proc
1080: linked server strangness
1081: how to split NTEXT field
1082: simulate TRY/CATCH in SQL 2000
1083: Master in single user mode
1084: displaying 0 for notexisting value
1085: Order By
1086: Undefined table from table function?
1087: Duration of a query in sproc depends on location of SQL client?
1088: Converting to Datetime format.
1089: How to avoid return result from dynamic sql
1090: Check for rows in last 5 minutes
1091: SET ROWCOUNT - unexplained behaviour
1092: How to query records with long text string by searching a short text
1093: Driving Me Nuts! Order of items in SELECT statement?
1094: Reason for duplicate foreign keys?
1095: Adding an Identity column to a view with multiple source tables
1096: Help with query to return joined results and nonjoined results
1097: Huge increase in .BAK File size after Backup
1098: System Sproc Problem on SQL 2K
1099: Help with stored procedure - if exist update else insert
1100: help needed regarding union query
1101: how to flush the print buffer?
1102: call Excel subroutine from SQL Server?
1103: Forfotten nested queries
1104: Query or index optimization
1105: Recursive subquery
1106: Size of all databases on SQL server.
1107: Complicated Table links in SQL query
1108: GetDate() to just 9/16/2008 format
1109: Need assistance with a query
1110: Create a view matching invoice numbers
1111: incorrect syntax near keyword SET
1112: Return (@ReturnedLanguageCode IS NULL)?
1113: Sql error number category
1114: Why would you ever create a composite non-clustered index?
1115: Calculate difference in dates, with conditions
1116: UPDATE is taking a very long time.
1117: Whats the benefit of spreading data across multiple file groups?
1118: Storing SQL in a table to recall for dynamic SQL statement
1119: sql2005 determine when trigger is disabled from script?
1120: Foreign key constraints with null
1121: The Curse and Blessings of Dynamic SQL
1122: Getting detail out of max count aggregate information
1123: SqlDependency.Start() method gets KeyNotFound Exception
1124: UPDATE using CASE within a CURSOR
1125: creating user accounts with Microsoft SQL Server Management Studio
1126: Comment: SSIS ScriptResults - why?
1127: backup up DTS packages
1128: How to not raise errors without try / catch?
1129: SQL that caused missing index
1130: Can triggers affect the triggering process?
1131: database too big and taking almost entire drive
1132: Criteria of Todays date or earlier
1133: Exactly One Month
1134: Problem with Insert Trigger
1135: User rights to read a table
1136: Identity column
1137: VFP 6.0 update
1138: Bulk Insert
1139: Subquery in From clause
1140: Calling Sproc from Master
1141: hard drive sector offset?
1142: What do you call this kind of binary construct? Likely off-topic
1143: Mysterious use of "out"
1144: select max 100
1145: Check constraints
1146: Is there an 'Exit Sub' or similar for Stored Procedures in tsql?
1147: Get Foreign key information
1148: SQL 2005 Integration Services problems
1149: comparing numbers that almost match
1150: Group by question
1151: SSIS100: Backward compatible with SSIS90?
1152: SQL Server Isolation Levels Question
1153: Grouping Question...
1154: Connection Issue
1155: Using Row_Number to increment only when value changes.. possible?
1156: retrieving characters to the left of a dash
1157: hw solution available for fragmentation problem ?
1158: BULK INSERT with variable names syntax help
1159: 64 Bit 2008
1160: sqlserver2005 - smdexec does not work
1161: which table keeps info about SET Commands on/off for all objects
1162: Crosstab/Pivot???
1163: Getting access to SQL Server
1164: SQL 2000 & 2005 Different SysObjects
1165: removing other fields of data based on another field
1166: using sql server 2008
1167: How to list functions from catalog views?
1168: stored procedure failing with different execution plan
1169: help query
1170: unique key vs unique constraint
1171: Rank and simple grouping
1172: Elementary question on query execution
1173: Too Random Resultset (Possible Bug?)
1174: Data Transfer question
1175: Top n records per category
1176: SQL 2005 integration services - viewing packages on named SQL 2005
1177: Update Active Directory through SQL
1178: XML to report
1179: selecting many rows with one distinct column
1180: IF statement???
1181: Temp tables in Triggers
1182: Constraint Check
1183: datepart
1184: permissions
1185: Create Index explanation
1186: xp_cmdshell Commands
1187: dts - activex script...
1188: SSMS Find and Replace Window
1189: circular reference that isn't
1190: bulk insert : ignore blank rows
1191: Inserting adjusted values based on last modified records
1192: stored procedure issue
1193: Insert new records from array?
1194: SQL Syntax Help - CASE statement or ISNULL?
1195: SQL 2005 job
1196: I need help selecting the last Invoice date from my data
1197: trying to connect to UPS WorldShip's DBMS
1198: Field value in Email
1199: SSIS - Fuzzy grouping
1200: xp_cmdshell---Getting File Name
1201: alter Login set password issue : the login name is a number... Any
1202: delete old backup files
1203: TRY/CATCH or IF (ERROR ...) GOTO...
1204: Permission problem with execute inside a stored procedure
1205: Service Broker New Service Broker Application
1206: Copying a database question?
1207: xp_cmdshell
1208: I need to autoincrement functionality and no duplicates
1209: SQL job to execute DTS
1210: Instead Of Trigger and Msg 4421
1211: BULK INSERT---LASTROW Attribute
1212: Trace not starting up after reboot. Is this normal?
1213: Foreign key issue
1214: Odd trigger programming problem
1215: Updating a table with more that one record in the join set
1216: How to do a dynamic where clause (in stored procedure)
1217: What is the best way to put my SQL into VBA editor when using
1218: Sum Values for Overlapped Rows
1219: xp_sendmail Procedure
1220: BULK INSERT with a Header and Trailer Record
1221: Help Optimize a query
1222: Stored Procedure 2 csv
1223: BCP - Formatting
1224: Random Records Question
1225: Union returns more rows than when i execute each select separately
1226: Service Pack
1227: not exists
1228: LEFT OUTER JOIN not working?
1229: Query to convert rows to columns (not a pivot)
1230: Converting Varchar to Int in a CASE statement
1231: Sending a string longer than 4000 characters gets converted to nte
1232: droplogin question
1233: Database Status RecoveryPending, Shutdown
1234: trigger using dirty property
1235: Several CASE statements on subsets of data..cursors best choice?
1236: SQL Server 2000 Query Help
1237: dropping the foreign key constraint
1238: Query question
1239: multiple insert (loop?) with trigger
1240: Bulk Insert question
1241: Adding On Completion workflow
1242: copy all tables
1243: adding to foreign keys from 2 different tables
1244: table last accessed/modified date
1245: phone numbers represented as scientific numbers
1246: What SQL statements were executed by a program?
1247: Newbie Help with Stored Procedures
1248: query to update a column with a calculated column
1249: What tables/indexes use what filegroups?
1250: Expression Builder
1251: Get Sum question
1252: Insert Query Help
1253: SQL Server exec() command, passing in very long SQL statements
1254: Using CLR stored proc for frequent efficient updates
1255: On completion wokflow: one-to-many
1256: nested sp
1257: sql syntax question
1258: Can this be done?
1259: Problem on clustered index with .net
1260: SQL server query to get Locks(waits)
1261: how do i detect the curret DB?
1262: SQL Server 2005 Data encryption problem
1263: Paste long text strings into a table in SQL Server
1264: Text Type Length
1265: stored procedures update table
1266: From zero to MCITP help
1267: No rows returned with NOT IN (SELECTT ...)
1268: query XML variable
1269: Creating a linked server to an Access Database from a 64 bit SQL2005 server
1270: 2 questions about table design
1271: Datetime comparison weirdness ?!?
1272: SELECT TOP 1
1273: SSIS: How to Retrieve Path To Current Package
1274: how to change timeout expire in SSMS (sql2005)?
1275: Am I reading this FROM correctly?
1276: Query help
1277: join
1278: Query in SELECT list vs Join
1279: Scripting a restore and permissions
1280: SQL Server 2008: Slow import when huge data in table because Reindex
1281: group by subquery
1282: Consecutive GUID Generation in DotNet Framework
1283: Error: Case expressions may only be nested to level 10.
1284: delete query
1285: query help
1286: Parameter help
1287: changing filenames
1288: hierarchy data - Storing and Retreiving Problem
1289: How to delete one row only
1290: SQL server query for getting number of locks
1291: need help with sql statement
1292: SQL Server 2000---XML---Web Services
1293: howto dynamic call to proc?
1294: Issue on selecting most recent transaction
1295: Execution Time Tremendously Different for Different Users
1296: Getting data for a range of dates when records only have one date
1297: Is there a way to find all tables that have a field with a given
1298: Survey. Need advice ...
1299: Search and replace for all procedures in a database
1300: Find the parent of a set of children
1301: Circular Reference.
1302: Omit previous redundant data
1303: Stored Procedure Question
1304: Replace Illegal Characters in a text string
1305: Interesting update question
1306: option force order
1307: OUTER JOIN With Filter Doesn't Return All Rows From Left-hand Side
1308: Look up alias from another table
1309: Getting a date based on year and weeknumber.
1310: Is this split function not allowed ?
1311: Where to get sql server 2005 management studio with sql server agent
1312: ANSI-related and other options for SQL Server 2005 database
1313: Cast not working
1314: Connection Performance degrades over time?
1315: View - Print out Result
1316: What is a "correlated update"?
1317: OpenQuery question
1318: running total of days in specific location
1319: Movenext in SQL?
1320: SQL Server and DBF
1321: help understanding ALTER PARTITION... SPLIT RANGE
1322: bulk insert : datetime formats supported
1323: help with query
1324: BULK Insert fails - Operating system error code 5(Access is denied
1325: SQL 2005 Perfmission
1326: Alter Table on/off
1327: Building dynamic table name based on YearMonth
1328: trying to avoid dynamic sql
1329: stored procedure to insert data in multiple tables
1330: stored procedure to insert data in multiple tables
1331: FileSystemObject issues
1332: How to input Bit type value
1333: printing characters of a text field that display after a dash
1334: call job in SQL Job agent from bat file
1335: SQL 2005 Service Broker poison message
1336: how to backup from Management Studio to another computer?
1337: Get count of files in a directory
1338: Chars in join
1339: Process each row in a table variable
1340: History table and Triggers?
1341: help for datetime data
1342: I know how to do this in MS Access, but how do I do this in SQL?
1343: OLE DB SQLNCLI "Expected data length" error
1344: Common Table Expressions referencing each other
1345: privatdetektiv essen in Oldenburg detektei ac privatdetektiv berlin
1346: Query Intermittently slow.
1347: Select\From\Where... what am I missing?
1348: Can CTE be used in this scenario
1349: Many to Many Update
1350: Analysis Service Pack 4
1351: IsNumeric Help
1352: Updating last column based on contents of other columns
1353: Debug sql2000 UDF with sql2005 Management Console?
1354: Sorted tables in sql server managment studio
1355: Sql error in SSRS tutorials
1356: Unable to get good statistics
1357: using SQLCMD on 2008
1358: add and subtract from field data
1359: dm_db_index_usage_stats
1360: detektei mainz in Dachau detektivbuero dedekteien privatdetektiv
1361: UNION ALL from view is very slow
1362: Monitor Linked Server From SQL 2000 using SQLDMO.SQLServer
1363: Deletes very slow
1364: select german umlaut
1365: Query regarding where clause( please help asap)
1366: diffrence between Insert and select INTO
1367: Query Regeneration
1368: hard disk space
1369: Collation Information
1370: Numeric character in Phone field (Pls ignore earlier post)
1371: Numeric character in Phone field
1372: Get changes to database
1373: Delete a record and all assoziated records in a hierarchie
1374: Multiple NULL Values in Unique Index/Constraint
1375: How to update multiple rows basing on SELECT statement
1376: List of Column Types by Number?
1377: sql help!!!
1378: To find employees who are continuously absent
1379: Adding multiple rows taken form another table
1380: Syntax error converting from a character string to uniqueidentifie
1381: Select IDENTITY_FIELD from table
1382: how can execute two stmts
1383: test
1384: Help query null/not null return 0/1
1385: Invalide object name '#Table (SQL2005 Query Analyzer)
1386: Calling sproc from CATCH block
1387: Unable to get Stored Procedure to return correct results
1388: DTS & copying between SQL 2000 & SQL 2005 (job fails when scheduled)
1389: table partitioning
1390: SubString on the Date filed
1391: Which is better OPENROWSET or OPENQUERY
1392: Simple query idea I can't figure out.
1393: I need help parsing a field
1394: Use BETWEEN or >= and <=
1395: bcp: surround output field with double quotation
1396: Table variable and tempdb
1397: Command Line Utilities
1398: How to get rid of duplicates
1399: No aliases with delete from?
1400: Error handling inside INSERT... SELECT statement