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