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