View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 [19] 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. When DTS hits a bad date
  2. Normalizing a Crosstab
  3. Variable Math in Stored Procedure
  4. Primary key generating
  5. Transaction log keeps growing
  6. Replication performance - how to measure it ?
  7. Candidate key
  8. Problem with export of a table to a text file
  9. Can any one explain this query behavior
  10. Temp Table Column Type?
  11. Table Query Timeout Problem very specific
  12. Merging two tables with selection
  13. Help me with this query please.
  14. Help me with this query please.
  15. Case help and Identity help
  16. Efficient Store Proc for Paging Very large DataSet using Cursor Approach
  17. minimun installation
  18. wow
  19. Performance: Server Agent v's Query Analyser
  20. SQL Running process
  21. replication
  22. Whitepaper: "Yellowfin Reporting" enables Embedded Business Intelligence
  23. Max Row Date
  24. How do I get a count of each set of results?
  25. Changing DSN to DSN-Less
  26. Logging information about items of the Data Flow Task?
  27. adding unique keys
  28. SSIS Packages Dashboard
  29. Incorrect syntax near the keyword 'THEN'
  30. SQL 2000 dies on JOIN query
  31. 6.5 master database syslogs full
  32. data transfer
  33. columns as rows and rows as columns
  34. Viewing transactions in SQL server 2005 express
  35. what is informatio_schema.<something>
  36. sum problem please help
  37. USING 'CASE' TO GROUP DATA
  38. SQL query dilemma
  39. mp3 songs in SQLSERVER
  40. Trigger on a table in TempDB
  41. User authentication
  42. SQL DTS to DB2
  43. Collation problem - urgent help
  44. okay, I'm frustrated....how do I
  45. Problem with SELECT
  46. SQL Server 2005 - FILE manipulation hanging....
  47. Difference between 2 tables
  48. flat file connection string
  49. nee stored procedure please help
  50. Using SQL Server 7.0, Backup maintenance plan not working
  51. Summarize Unique changes of registration
  52. sqlserver 2005: indexes on raid-0?
  53. Creating rows based on date range from another table
  54. SQL Insert Help
  55. transaction log
  56. Move Databases on SQL 2000 Machines
  57. Changing stored procedure Freezes Crystal
  58. Recommendation for tools converting access databases to SQL
  59. Log Shipping Snyc Problem
  60. Using aba_lockinfo in a loop
  61. Help with query - anyone??
  62. Absolute Newbie Question
  63. Alter a SQL table
  64. do SS transaction logs have to be backed up for recovery to POF?
  65. Access to SQL Server Query Translation
  66. Best way to move datafile from C drive to D
  67. Hourly Average
  68. OLAP Specialist vs OLTP one?
  69. SQL Server 2005 Opening Script File Problem
  70. how to add primary key in existing table
  71. Does truncate and API Load invalidate statistics
  72. Slow Insert in SQL Server
  73. SQL select statement needed
  74. I can't create a temp table
  75. SQL access problem (SP2 pre-installed)
  76. Array / Table As return Type
  77. union all and order by problem
  78. Weird situation - Stored procedure executed twice
  79. installation problem for SQL 2000 Development Edition
  80. Trying to do REALLY simple procedure and loop in SQL Server
  81. SIMPLE command to convert string to number? Not CAST or CONVERT.
  82. SQL 2000 only using 8GB of 16 GB available
  83. Only update changed columns
  84. suggestions for books
  85. Views, UDFs
  86. Stored proc duplicating data
  87. Views
  88. After SP4, proc w. Cursor doesn't release keylocks
  89. Using FormsOf(INFLECTIONAL, )
  90. Multiple Search Criteria using FREETEXTTABLE function
  91. clustered vs. non clustered
  92. copy database via tapefile no SQL 2005
  93. need help with LEFT JOIN statemen
  94. Almost there with bulk insert
  95. Create View in SQL Server with data types
  96. SQL Server trigger that fires only on update of certain field?
  97. transaction logs full
  98. MS SQLServer or Pervasive SQL 2000i
  99. Validating State abbreviations using a Check Constraint
  100. Selecting on multiple tables
  101. SQL Server 2000 / [USA edition] = UK ???
  102. dependent assembly microsoft.vc80.mfcloc could not be found
  103. dependent assembly microsoft.vc80.mfcloc could not be found
  104. Accessing form controls values through ms sql fuction
  105. SQL 2005-Config Manager contains no data
  106. SQL Server 200 Developer vs Enterprise versions
  107. Weird DTS Problem
  108. Trigger problem in SQL
  109. Get the latest result (new in sql)
  110. Trouble with Impersonate User, ODBO and Analysis Services
  111. Hey I've got a homework problem I'm working on and am stumped.
  112. ALTER TABLE from sqlcmd script
  113. How to switch off automatic blanking of table views in enterprise manager ?
  114. 'MSDASQL' headache
  115. Flattening Parent Child Hierarchy: Urgent please help
  116. Error in Creating table in Sql server 2000
  117. New to stored procedure
  118. format files for use with bulk insert
  119. How to creat a sp for insert datas...
  120. Get files in different folder using sql
  121. Skip rows where the first column with letter 'S' - BCP
  122. Get column names with the corresponding table name from a SELECT with JOINs
  123. SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
  124. Tying together tables
  125. Database design question
  126. Change Logical Name in Script
  127. TRAN_ABORT gone?
  128. Global ODBC Settings
  129. Regional Setting in MS SQL
  130. SQL Challenge Urgent, Please help
  131. Cant install SQL Server '05 EE, VB 2005, or Visual Web Dev 2005
  132. Query Analyzer. What settings to see the data output again?
  133. Query Analyzer. What settings to see the data output again?
  134. Import multiple csv into multiple tables
  135. Is DEFAULT a constraint?
  136. Using Union and Join in a single view
  137. SQL Round
  138. How to get last date only once all have been filled in
  139. How to restrict evil create scripts?
  140. What is the correct sequence of Restoring databases in SQL Server 7.0
  141. SQL Server 2005 + SQL Server Express
  142. need some help
  143. Moving SQL installation to a new Partition
  144. On to Bulk Insert issues
  145. Need help adding 3rd table to a Join
  146. Error 22272: Cannot load the DLL xpstar.dll...
  147. understanding triggers
  148. Reporting No Records Found
  149. Script, Save, Export SQL 2005 Database Diagrams
  150. SQL-SERVER - APPEND from different databse's table
  151. Supress Column names in the output
  152. Table structure and data transfer from SQL2000 to Access (.mdb)
  153. Understanding constraints and binding
  154. How to implement a foreign key
  155. Move from SBS2003 MSDE to MS SQL 2005 Express
  156. How to recover deleted data from master database
  157. Update SQL from Excel - newbie question and a challange
  158. Tough query?
  159. MS-SQL Related
  160. Survey: Enterprise Architecture and Software Development
  161. SQL Server 2005 Express to SQL Server 2005 Standard
  162. trouble porting a trivially simple function - with declared variables
  163. 2005: cannot to connect from .NET
  164. Using SQL to append records to a table from a flat file using DTS
  165. Sql Server Hot backups (Clone/Fracture)
  166. Any help?
  167. Unable to Create a Maintenance Plan
  168. SQL Server 7.0 equiv of IDENTITY_CURRENT
  169. Help with Database Solution
  170. Help! Need to extract date/time from SQL database table
  171. OUTPUT and Recordset
  172. table owner
  173. Problem with cast error in adventureworks sample
  174. Count of records inside the records but based on distinct?
  175. loading data from text files
  176. SQL 6.5 upgrade to 2000
  177. Migrating data from DB2 to SQL Server
  178. What To Join?
  179. What To Join?
  180. Specify SQL2005 LogFiles Path on Install
  181. moved from ms sql 2000 to ms sql2005
  182. Insert Problem in MS SQL
  183. Starting
  184. Distributed Transaction Coordinator on SQL Server Cluster
  185. SQL Server 2005 and file systems, any recommendations
  186. passing tablename as parameter to function and to use it dynamically
  187. How to change owner for all tables in a database.
  188. ODBC readonly (viewonly) linked tables....
  189. More questions about porting from MySQL to MS SQL
  190. Reclaim disk space after DROP columns
  191. questions about keys - porting code from MySQL to MS-SQL
  192. SQL query
  193. Help! I'm using MS SQL Views
  194. Accessing SQL2005 as a Second Instance to SQL2000
  195. Compare Two Queries - Help
  196. Limitations in a query !!
  197. Problems when trying to build Connection to SQL Server Express from ASP.NET application
  198. Set time for UTC
  199. Previous day query
  200. Having Problem While Importing a Text File
  201. Select Statement Problem
  202. Why the memory usage of SqlServer doesn't go down
  203. Inserting a record using values from another Stored Procedure
  204. Recommendation os SQL Server Monitoring Tool
  205. Scrambled data in some fields
  206. Help with case when
  207. Allow NULL or Define DEFAULT Value
  208. i'm a newbe. please help
  209. Alter Table
  210. Reads and writes to a sql server database per table
  211. Very Small Numbers
  212. It proclaims of the Commandant in Boss Fidel Castro to the town of Cuba.
  213. Proclama del Comandante en Jefe Fidel Castro al pueblo de Cuba
  214. How to export xml in dts "Excute SQL Task" to a flat file
  215. Data Transfer
  216. Find which SPs have quoted_identifier set wrong
  217. Transposing rows to columns
  218. SQL Profiler hanging
  219. Problems when upgrading to sql server 2000 sp 4
  220. SQL 2005 Developer edition - install problems
  221. Satan and the evil
  222. Referencing colum names in recordset which is created by join - URGENT!
  223. FULLTEXT SEARCH any drawbacks??
  224. MS SQL & Visual Studio 2005
  225. Create Ranking Column
  226. Sorting with NULL
  227. Sorting with NULL
  228. Question about summing up different fields in different records
  229. 64-bit SQL 2000 Compatibility
  230. dts dynamic query & automap columns question
  231. AFTER INSERT trigger not firing in SQL 2005
  232. Index Computed Column?
  233. xp_cmdshell/DTEXEC in SSIS
  234. Delete Non System Table
  235. 2005: problem with Books Online
  236. optimising the following query
  237. Ordering results by order of the "IN' clause
  238. query optimisation
  239. Some issues regarding using MS SQL
  240. Yeartodate
  241. Working with NULLS
  242. Using xp_cmdshell to run application that uses domain credentials
  243. How to Access Query Anaylzer?
  244. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
  245. select minimum between two values
  246. new to sql....can anybody help..
  247. Having problems calling a procedure which returns output variables from another proc.
  248. Calling all MSSQL 2005 Experts
  249. Use both DBs in cluster?
  250. BULK IMPORT Stress
  251. CPU spike with SQL Server 2005 Express Edition
  252. Query optimization via table properties?
  253. Searching a database
  254. Urgent -- Outer Join Problem
  255. Change monitor server settings for Transaction Log Shipping
  256. SqlServer View Tuning
  257. backup job hang
  258. Admin Version of WITH(UPDLOCK)?
  259. 2005: installing Business Intelligence
  260. create trigger or stored procedure in external DB?
  261. MS SQL 2005, .NET, logins/sec and page faults
  262. 2005: Service Broker?
  263. sp_who and Citrix
  264. delete particular rows in a table
  265. syntax error ALTER TABLE
  266. Deleting more duplicates
  267. Select query help+primary key
  268. DTS Import Update table.
  269. sp_change_secondary_role missing in SQL Server 2005?
  270. Linear Regression for column values
  271. 2005: BACKUP
  272. System event triggers
  273. Deleting a column DEFAULT....
  274. Problem with Insert Exec in nested SP
  275. Wanna create a table field name as 'Name'
  276. Help with an online game project
  277. Sql Inner Join..
  278. Encryption Password
  279. Text column data incomplete
  280. SQL 2005 - SQLDMO - Adding Logins/ Users
  281. Recreating/reloading system stored procedures
  282. SQL Statement - Join
  283. Replace Access with a .NET front end and SQL Backend solution.
  284. Question on QUOTED_IDENTIFIER
  285. The best way to display values from a CURSOR
  286. ms sql 2005
  287. Newcomer to the whole milieu
  288. ODBC Timeout - Where to start looking
  289. Cryptography API for MS SQL Server
  290. SQL7 Files and HardDrive issue. Please Help
  291. DTS export to Excel
  292. Urgent SQL7 ISSUE
  293. Reduce Table Size without deleting data
  294. SQL Generator
  295. Updating text containing , or
  296. Scripting table with rows values
  297. MS SQL Caching
  298. Exporting data from SQL 2005 to Access
  299. Text Import Finding Table to Import to Problem
  300. Subquery Help
  301. Delete 2005 [user] schema?
  302. How to send an automated email when SQL Server 2000 is shutdown...
  303. select no. of rows from the current database
  304. Formatting text file using DTS Select/Export
  305. Conversion datetime to string
  306. 2005 Express Edition: installing full-text search
  307. Trigger Between Linked Server - DTC Issue
  308. query to populate child table
  309. not permitted in this context
  310. SQL Server 2005 Script Generation
  311. quicker way to create indexes
  312. Terminal Service Manager
  313. URGENT - Link server 2005 to 2000
  314. (2000) Unable to connect to debugger
  315. Second Transaction Log File
  316. LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans
  317. 2005: creating aggregate function from .NET assembly
  318. Book recommendations?
  319. What do you mean 'clustered' index?
  320. Server Components Can't Be Installed
  321. SQl Server 2005
  322. SQL Server
  323. sqldata dictionary
  324. Red-Gate SQL Log Explorer
  325. Table design request for comment. (Help please)
  326. need help regarding finding rows modifeid during certain time frame
  327. Column permission being ignored by Access Form Combo box
  328. Micro-pump is cool idea for future computer chips
  329. Remving duplicate rows and NULLS
  330. Fill Factor
  331. Automatic Import of Emails
  332. Size of Row
  333. Multiple files import
  334. Check if a Table is used in any sp or function
  335. Input string -> table -> output string?
  336. Query to find a missing number
  337. SQL 2000 Error: 1203, Severity: 20, State: 1 Error
  338. SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51
  339. De-normalizing query
  340. problems with query
  341. Limits in SQL 2000
  342. Character find and replace
  343. SQL Server 2005 JDBC 1.1 integrated security question
  344. SQL Server 2005 SP1 install
  345. changing records in tables
  346. Cursor loop
  347. vba sql server connection
  348. 955585 - Limited Term Employee / Infrastructure...position at hewlett Packard
  349. Backup and Restore on different computer?
  350. Using Decimal as a Key
  351. Problem with INSERT Trigger
  352. How to get modified time of a table
  353. Reporting Services 2000 & 2005 on same machine
  354. Reporting Services 2000 & 2005 on same machine
  355. Transact-SQL SUM Help!
  356. Get all table names with a given column name
  357. Problem with stored procedure and retrieving inserted identity value
  358. Error OLE DB
  359. Problem with installing SQL Server
  360. 2005: using SMO
  361. 2005: Business Intelligence Development Studio?
  362. How to combine 2 records into 1 unique record
  363. Strange results from "not in" query
  364. SQL2005 SSIS - won't allow text delimiters
  365. Turn of logging on SQL maintenance plans
  366. 2005: calling .NET procedure
  367. Databse Link will not connect
  368. I HATE Management Studio, how about you?
  369. Search Char in SQL query
  370. BCP using ODBC - problem with unique identifier
  371. Need help with denormalizing query
  372. Smarter Table build - might split the table
  373. Newby DTS Question
  374. MS SQL database Transfer
  375. 2005 EE: using full-text indexing
  376. stored procedure question
  377. sending a parameter from an access database to a DTS package in sqlserver
  378. Hierarchy
  379. Query: union on self
  380. User Defined Data Types Problem
  381. key column information is insufficient or incorrect
  382. Northwind database extra SQL needs
  383. Make and save a blob on the fly in stored proc
  384. Need More SQL Query NewID Help
  385. OUTER JOIN not working?
  386. Delete statement for a list of items with multiple columns identifying primary key
  387. Insert Function Help
  388. ADS user and sql 2005
  389. 2005 Express: testing replication
  390. Hide SQL Server DB; 2005 version on Win 98
  391. pulling all dates within a date range
  392. Insert Subqueries
  393. Odd SQL IN usage?
  394. Design question related to Grouping
  395. exporting to CSV
  396. Access Sql server using Javascript
  397. 2005: forbidding INSERTs and DELETEs
  398. Please Help with SQL Query Problem
  399. Building an application on multiple data sources
  400. BEGINNER: simple Delete trigger
  401. sequence of columns and preformance
  402. MS-SQL one .NDF file missing How to Recover/Rebuild DB??
  403. Create trigger - do users need to be out?
  404. Bizarre Query
  405. Problem when changing Views
  406. Update unique records only help
  407. Consolidate information from multiple rows into one row
  408. SQL 2005: keeping track of database changes
  409. Empty recordsets and artificial records
  410. How application can detect node restoring?
  411. need programmer to build a dts...
  412. to find a particular record set is present or not?
  413. Querying Windows Active Directory from Sql Server 2000
  414. Querying Windows Active Directory from Sql Server 2000
  415. comma separated values to stored procedures
  416. Announcing Yellowfin Version 2.5 release for SQL server based users
  417. SQL server 2000 timeout
  418. How to move transaction logs on-line?
  419. attach db MS SQL 2000 .BAK with enterprise manager
  420. multiple rows and columns MAX
  421. Getting Count(*) From Left side of Join using WHERE on right side of join
  422. How can I do a exact wording search?
  423. OR in the WHERE Clause?
  424. why don't group by work????
  425. memory usage/allocation/paging question
  426. Returning the newest rows
  427. conversion from Access query to mssql query
  428. SPROC won't execute - insufficient permissions
  429. Does anyone know of a tool that allows a SQL Server database to be
  430. inserting into two tables and transaction problem
  431. Sending email (recipients)
  432. SQL Server 2005 Express
  433. Export Image Data Types to Local PC from SQL Database
  434. Update statement, then insert what wasn't available to be updated.
  435. left() and right() function in MS SQL vs MS ACCESS
  436. Calling a SP inside a cursor loop..
  437. Calling a SP inside a cursor loop..
  438. Problem with Composite PK
  439. Select multiple rows into one row, MS SQL
  440. Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition
  441. mysql database session management with cj tracking
  442. MS Excel to MS SQL
  443. Insert trigger
  444. Need help with this select statement
  445. How to get rank?
  446. SQLserver on SBS2003 returns old data
  447. constraint expression for unique keys
  448. how/what should be the query for this result
  449. Datareader concepts to access SQL Server data using datareader.
  450. Scheduling of snapshot agent
  451. right padding equivalent
  452. Help With Syntax
  453. MS SQL date range and average
  454. sorting twice?!
  455. Problem on SELECT statement
  456. Combining 2 tables with date ranges
  457. dbcc reindex issue - - I don't understand!!
  458. Have Insert statement, need equivalent Update.
  459. SELECT statement help
  460. Developer Edition having issues connecting to server via TCP/IP
  461. "Sql Server 2005 Developer"
  462. need tool for managing database object ownership
  463. pulling progress data
  464. Enumerate databases
  465. trigger question
  466. "Ghost" primary key column
  467. I have a question With Related to performence
  468. The single OS nature of MS SQL
  469. EXcel sheet into database with stored procedure
  470. Network error IOException: Could not create socket (SQLState: 08S01)
  471. Insertion and Updates on 20.000.000 tuples table.
  472. Deleted "old" transaction logs = (no items) in EM. How to recover?
  473. Help.... This doesn't make sense...
  474. Access Query against SQL Server works only without criteria
  475. RUN SQL Stored Procedure in Access
  476. The identifier that starts with...is too long. Maximum length is 128
  477. 2 foreign keys to the same table - multitable selection query problem
  478. SQL Server Error "Missing end comment mark"
  479. SuperSocket Info: Bind failed on TCP port 1433
  480. Help sending email
  481. Separate databases for high/low transaction volumes?
  482. Speed up UDF
  483. SQL to Oracle update trigger fails due to distributed transaction error 7391
  484. What is Your Strategy for Upgrade an Access db to SQL Server 2000?
  485. Very Poor Performance - Identical DBs but Different Performance
  486. Query with Joins problem
  487. Extremely Poor Query Performance - Identical DBs Different Performance
  488. Comparison operator in Select list
  489. isql changes null behaviour in mssql 2000
  490. SQL Server 2005 and Cursors
  491. setup multiple SQL server listeners on one machine
  492. SQL server replication from non-clustered database servers
  493. Help with SQL Statement to find first and last populated field in string of fields
  494. Sql Server 2005 questions regarding editing views
  495. Ambiguous Column Names in Multi-Table Join
  496. Problem joining child data (JOIN, subquery, or something else?)
  497. Unable to reinstall Enterprise Manager from original disk: service pack rejected
  498. Ms Access to SQL
  499. Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000
  500. MSSQL/Related to XML Query
  501. For Xml Explicit//mssql
  502. Concat ??
  503. Ms Access upload to SQL Server 2005 BE & Sharepoint FE
  504. One Database vs. Multiple Databases
  505. Web FE & SQL BE
  506. T-SQL Problem - should I use the "ALL" clause?
  507. SQL 2005: creating "correct" and "incorrect" versions of a database
  508. encryption in sql server 2005
  509. Datatype-convertion in TSQL
  510. Error: 16954, Severity: 10, State: 1 and Timeout problem
  511. SQLDMO - Getting 'Local' Server name
  512. Creating Cursor from Stored Procedure
  513. SQL 2005 - Disappearing Relationships in DB Diagram
  514. help for shrinking database
  515. Sequence generator
  516. DTS copies from SQL Server to MySQL on Windows.
  517. group by
  518. SQL Server 2005 Hash Partitioning?
  519. Left Join variable not valid
  520. SQL Join
  521. ISP Driver Error?Line: 131 of /ips_kernel/class_db_mysql.php
  522. Cannot remove dbo rights from a user
  523. Rebuild index issue - - strange
  524. Connecting Sql Server 2005 from ASP?
  525. How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?
  526. Sybase driver and MSSQL 2k
  527. MS SQL 2000 SP4 Error: 1038
  528. How can I get all records for both tables with the latest begin date if exists?
  529. Stored Proc Question : Why If Exisits...Drop...Create Proc?
  530. Copy text columns to nvarchar
  531. Assistance building a query...
  532. SQL0440N error in Stored Procedure........
  533. Calling another record into this record
  534. how to conver number to string
  535. Debugging in Query Analyser
  536. Are we going right?
  537. out of order identity field - sql2000
  538. Results in Parallel columns
  539. output the latest date for each foreign key
  540. output the latest date for each foreign key
  541. getting the most latest date
  542. Authentication
  543. PArse syslog message into data fields
  544. Create Procedure in an IF block?
  545. Stored Procedure Issue - Problem with temporary tables
  546. Performance issue
  547. enterprise manager (or other software) to document tables and columns for Server2k?
  548. 2 different foreign keys in one table
  549. How to create SQL Server Express server (INSTANCENAME) programmatically?
  550. backup of transaction log