PDA

View Full Version : MS SQL


Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

  1. Write conflict on SQL 2000 ODBC linked table
  2. Executing a job using TSQL or Stored procedure on SQL 2005 Express
  3. Specifying Columns in a Bulk Insert
  4. u just click u get some dollars
  5. Re: Queries Occasionally Slowing Down
  6. database size vs. its performance
  7. Re: Clustered Indexes, what actually happens when you rebuild one, does the optimiser love them?
  8. Database backup using Scheduled Tasks
  9. SqlDataReader on Sql 2005
  10. Bulk Insert with LINQ to SQL
  11. LINQ to SQL with bulk insert
  12. SP timing out, can't find the cause
  13. slow DNS caused extreme SQLS memory pressure+CPU?
  14. sql server 2005 express problem wtih {7twud62389sdksdk} the like
  15. How to determin if current computer has functioning sql sever(s)installed?
  16. How add rows to table in Microsoft SQL 2008 Server
  17. Finding a way to avoid joins/inner selects
  18. How do I detect a local temp table
  19. ssis - Where is the sql?
  20. Re: Select with many to one relationship
  21. Precision in a REAL data type
  22. new blog
  23. Re: A dynamic table to be made into excel file
  24. Seeking Simple Tutorial for Connecting to SQL via C++ (VS2005)
  25. how to generate the following output in sql ?
  26. copy data from one server to another
  27. Re: CREDIT CARD SERVISES
  28. Exporting data
  29. IBM X336 server with RAID1 configuration formats all HDDs on newhardware installation
  30. A dynamic table to be made into excel file
  31. SQL STATE 22003: Numeric value out of range with TIME data type
  32. odd SqlInfoMessageEventHandler problem (source code provided)
  33. variables in SSIS
  34. Security for server tables on SQL 2000.
  35. test-sanderson@eliteinvestment.net
  36. Aborting a stored procedure?
  37. Datetime comparison problem
  38. point-in-time vs. shadow tables for audit history
  39. Linked Servers
  40. Performance: Conditions in WHERE clause vs. conditions in INNER JOIN?
  41. Displaying time from Datetime datatype
  42. Build a search query based on multiple userinput from textboxes
  43. SQL query question #2
  44. SQL query question #2
  45. Can't get "<>" (not equals) to work in view
  46. default schema resolution for user-defined functions?
  47. Maximize sql window in SSMS?
  48. SQL query question
  49. AntiVirus recommendation for SQL 2008
  50. How to compare two different columns in two different rows.
  51. Where clause
  52. Remove Seconds from Datetime: How To?
  53. To unicode or not?
  54. How to store big Arrays
  55. Create UDDT - good idea?
  56. Verify backup after the backup is completed
  57. Succinct way to return logical condition as column?
  58. DataServices World (November 20): SOA, WOA, cloud computing andfuture of database
  59. REALLY REALLY FUNDAMENTAL QUESTION....Response would be greatly appreciated
  60. spam
  61. Intellisense not working
  62. Selectively Executing Interactive SQL in Management Studio
  63. Yellowfin Enhances Business Intelligence Reporting forTelecommunications
  64. Parameterize FROM clause in Stored Procedure: How To?
  65. Does (code) size matter?!?
  66. Concatenate float data type
  67. osql import inserting carriage returns?
  68. Managing data between CRM and Informix
  69. Trans log backup based on size rather than time?
  70. number of Connection for Linked Server
  71. Change SQL Server 2005 Express's default port programatically
  72. SRS Reports
  73. SQL 2005 Optimizer not optimizing
  74. How to find out what type of the data procedure in MSSQL 2005returns?
  75. dataGridview
  76. sql 2005 express command line instalation
  77. Custom and UserControls
  78. spam
  79. sql server cluster node rebuild failure :(
  80. BCP out image files not working
  81. Problem Entering Item Into A Table
  82. Stored procedure Question
  83. Datetime in sqlserver 2005
  84. Copy 2000 database to 2005 - cannot detach/attach
  85. Error 262 create database
  86. How to control number of users in a database?
  87. [Newbie Question] SSMS indexes
  88. T-SQL
  89. Stored procedure
  90. SSMS - setting root of Object Explorer
  91. Accessing the call stack via TSQL
  92. Application Roles and SQL Server 2005 - DDL?
  93. SQL Server Management Studio question
  94. easily repeatable index corruption in SQL Server 2000 (8.00.2050,post-sp4)
  95. Import/Export Wizard
  96. Performance/stability issues
  97. SQL 2005 management studio vs SQL 2008 express
  98. set default value
  99. How To Look At Chronological Series To Find the First Values GreaterThan Zero?
  100. Inconsistent results for SELECT SUM(<<real field>>) ...
  101. DateDiff Calculation - odd results
  102. Interview type Question
  103. SQL Express on dual processor server?
  104. How do i write Set based queries and avoid a cursor?
  105. Connection issue when trying to connect MS SQL SERVER from Linux
  106. copying from a table to a file
  107. Services not listed on Configuration Manager screen?
  108. SQLSVR 2005 SP2 / Shrink data file will not work
  109. Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
  110. DTS package and new folder
  111. Trigger to Update Fields of Inserted Record
  112. SQL Server 2005 Profiler etc.
  113. Maintenance/Auditing Scripts for SQL Server
  114. SQL Server Agent Alert System - Operators?
  115. Standards for using Stored Procedures as an interface
  116. management tool express 2005
  117. data/schema comparison
  118. Error in Proc
  119. dividing return set into smaller sets
  120. spam
  121. selecting rows from a table
  122. datatable select
  123. I need a little cursor help
  124. Single server but multiple timezone database..
  125. Select Insert Deadlock
  126. using sp_helpdb and getting error
  127. FORMSOF Predicate: Need Plural, not Inflectional
  128. UDF using EXISTS help requested
  129. Customizing SQL Server 2005 Enterprise Manager colors depending ondatabase
  130. sp_executesql increases number of reads?
  131. How to read the xml and display using xslt from a DB in sql server2005
  132. Incorrect syntax near ','
  133. Incorrect syntax near ','
  134. Cannot find data type xml
  135. How to synch renamed NT account with SQL Server 2005
  136. Re: Datadevices
  137. Select Max() not working
  138. MS/SQL Developer--DTS--Contract--Detroit Area
  139. SQL Server 2000 Failover Cluster upgrade to SQL Server 2005
  140. ODBC mystery
  141. SPROC help for insert into from related records
  142. SQL Server 2005 copy objects
  143. Why Restore with Norecovery is incomplete?
  144. Re: Cannot Connect
  145. Sorting
  146. Passive Laddered Bonds: Table Structure?
  147. Location Intelligence where to from here?
  148. SQL 2000/2005 Transaction Log Reader Library
  149. Modified Proc
  150. logs
  151. ONLINE RESOURCE FOR HELP DESK SOFTWARE
  152. export relationships in SQL 2000
  153. TSQL Query
  154. SQL 2005 Management Studio/Express - Any differences
  155. Calculated fields...
  156. ODBC DSN connection fails from MS Access 2000 after SQL2005 mirrorfailover
  157. Microsoft's SQL Server and related products.
  158. SQL Server data dictionary
  159. How to use stored procedure parameter in sql-statement?
  160. Indexing Low Cardinality columns in a data warehouse scenario
  161. UPDATE query gives Incorrect Syntax error
  162. large data : how do you store multidimensional data ?
  163. DELETE only deleted 10000 records
  164. database problem
  165. Tweaking SQL to optimize the query execution plan
  166. Help Needed For writting a query (SQl Server 2005)
  167. How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?
  168. SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
  169. Different empty_string/NULL handling under ODBC and OLE DB?
  170. Project Management Knowledge Base !
  171. sql squeries
  172. Query with different WHERE clauses
  173. sql queries
  174. Truncate text in table? (ie 101928494 will become 928494)
  175. SQL Server 2008 Final release date
  176. relationship
  177. sql queries
  178. not showing proper datetime in tables
  179. sql server queries
  180. plz suggest me the query
  181. IT auditing tool SC Magazine Review
  182. Creative query assistance needed
  183. How to find out difference between two rows....
  184. SQL Server Engine Downgrade
  185. SQL 2000: Transport-level error on SELECT statement
  186. dropped tables
  187. Trying to insert a zero, its telling me i cannot insert a null
  188. A Question on query efficiency
  189. How to deploy a database on SQL Server Express 2005
  190. Can Analysis Server and Report Server run on SQL Server 2000 Cluster
  191. Jobs, Interview Questions, Certification, Knowledge
  192. Re: SQL Server 2008 caching
  193. Re: SQL Server 2008 caching
  194. select blocking sessions t-sql
  195. Write "Messages" window to a log file?
  196. Deduping
  197. Yellowfin seeks resellers for BI product
  198. load_file and blobs
  199. Using a Trigger to determine when a column was changed
  200. Data returned by SQL Server ODBC driver is not correct
  201. Certification in Mind???
  202. Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
  203. Finding duplicate records
  204. SQL 2000 DTS tool - 256 char limit?
  205. Linking Windows SQL Login to user database
  206. Calling Commonly Used SQL (reusable code)
  207. Export to Excel, exclude header
  208. Can a dropped table be recovered?
  209. How to show field that not being group
  210. Softclarity Builder
  211. Accepting wildcards like % in input parameters of stored procedures
  212. Distinct Row based on description count
  213. Re: problem with column alias
  214. Re: problem with column alias
  215. just u click make a money online
  216. Having problems using BCP for CSV output
  217. Re: ALTER proc vs IF EXISTS DROP/CREATE
  218. ALTER proc vs IF EXISTS DROP/CREATE
  219. Delete Trigger
  220. Intrusion Detection Strategies
  221. SQL Server Scripting Question
  222. sql server query problem
  223. Insert Into Select trouble
  224. SNL Sql
  225. ms sql 2000 - create update script
  226. SQL Query for Dummies
  227. CONVERT() problem
  228. Latest updates in database management and SQL server tools andtechniques
  229. Da MySQL a SQL express
  230. T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
  231. unable to install SQL Server 2005
  232. Re: Best practice on nullability and default value
  233. Formatting datetime when including in a PRINT command etc...
  234. Pb to open an attached mdf file
  235. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  236. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  237. Patch for KB948110 causing random "Could not find database table ID"errors
  238. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  239. How to compile TPC-H ver2.7 on Windows XP?
  240. complicated query (where statement inside select statement, don'tknow how to explain it)
  241. Insurance data models...any tips on good starting point?
  242. Are Deadlocks inevitable ?
  243. Help With Full Text Search. Performing AND across columns
  244. rupdating duplicate entries with random numbers
  245. Changing the name in the ServerName column
  246. Schedule a Query
  247. Multiple attribute design that need to be searchable
  248. Multiple attribute design that need to be searchable
  249. Sql Server 2005 Replication
  250. does this backup sequence commit all data to the database
  251. SQL problem - a variation on outer join
  252. BACKUP LOG questions
  253. Could not execute a package by a scheduled job
  254. dbcc shrinkdatabase
  255. Testing
  256. DB Structure Advice - lots of measurements in DB or file refs?
  257. programmatically stopping and starting transactional replication
  258. login failed
  259. Data loss importing from Excel
  260. transaction log
  261. How do I number an output field consecutively?
  262. Database management and latest updates on SQL server
  263. Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
  264. Cursor among several databases
  265. design issues with large amounts of data
  266. SELECTing from a DML statement
  267. Using UPDATE to sequentially abbreviate address information
  268. Odd character appended to data
  269. Datetime import/export issue
  270. Yellowfin Business Intelligence Release 4.0 Announced to Industry
  271. slow queries for a particular database
  272. sql agent JOB to Backup Database and Maintain Backup Files
  273. Need a script to recreate scheduled jobs
  274. Help needed for Data formatting.
  275. How can I do that using a trigger
  276. OLEDB configuration when deploying multiple SSIS packages
  277. Decimal point and comma
  278. Re: Stop hotlinking to a specific file & keeping a counter
  279. Please Help - Can't check for duplicates
  280. Deploying an app with SQL Server (installation on client machine)
  281. How to secure a database ...?
  282. Can I search for a string in a set of stored procedures?
  283. GROUP BY a computed column
  284. Creating a database from set of TSQLl files
  285. Concatenate in MSSQL
  286. Storing BLOBs outside database
  287. Re: Duplicate Tests - Help Please
  288. Re: Grouping by Day for a Date Range
  289. Question about recompiling a dll
  290. table naming convention about this case..
  291. Latest updates on SQL server 2008 tools and techniques
  292. Computing a column that is a percentage of the sum of another column
  293. Database security (non-existent?)
  294. Tool to chase down the consequences of adding field to DB tables?
  295. Applying tranaction log to old data file
  296. Re: Database naming conventions?
  297. Latin1_General_BIN comparing two char strings
  298. alter table query not working after working at least once. MS SQL2000
  299. Re: Database naming conventions?
  300. Re: Database naming conventions?
  301. Transact-SQL for Restore Filelistonly using a variable
  302. Toad for MSSQL problem: closing script file doesn't "release" thefile?
  303. bcp out in UTF-8 format
  304. Kuljetusalan ongelmista
  305. Basic SQL Statement Question
  306. Differences between relational DB and warehouse ?
  307. tbl_A CROSS JOIN top 1000 rows of tbl_B?
  308. bcp out empty string into csv files
  309. C++ API for SQL Server?
  310. SQL 2008 EULA and pricing
  311. SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
  312. Performing multiple bulkcopies for different tabels
  313. stored proc with datetime
  314. Forget about Referential checks??
  315. Re: Not finding GUID value after migration sql 2005 to 2000
  316. bulk insert in clustered index table
  317. Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
  318. database design
  319. Re: Not finding GUID value after migration sql 2005 to 2000
  320. DB migration
  321. Newbie basic questions
  322. HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
  323. Anyway to declare and use variables in a View
  324. MSDE upgraded to SP4 but showing SP2
  325. Select from a access table
  326. Migration of an Access Database. How is the best way?
  327. Problem connecting to SQL Server from Access Database
  328. simple SQL engine
  329. Fuzzy logic for duplicate identification?
  330. Full text search in albanian
  331. database owner?
  332. Convert Int to Date
  333. IF within SELECT
  334. live online training
  335. Re: "Maksanhierontalaite" ; )
  336. Problem With View and Changing Field Length
  337. stored procs
  338. Looping Through the Records returned from a DTS Lookup
  339. Snap-in failed to initalize.
  340. Compound vs Simple Indexes
  341. Re: Ruuska
  342. Not an ad hoc query?
  343. Stored Procedures and Commiting Data
  344. Connect problem
  345. Dell c610
  346. Re: search pyrkii nettiin
  347. Using Case within Select
  348. SQL 2005 report deploy issue
  349. Is this a correct table structure for my database?
  350. How to find if instance is cluster or non-cluster
  351. SQL Server 2008 - Filestream
  352. Error running DTS script in VB
  353. SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
  354. How do do a query against hardcoded row values
  355. Need SQL Server Dasbase Admin
  356. simple ALTER Table query question...SQL 2000.
  357. Disabling Triggers
  358. Installing sql server 2000 on windows server 2008
  359. Update Query Runs Forever
  360. Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
  361. How to sell sql skills? (Need your knowledge and thoughts)
  362. (Newbie) Join problem.
  363. Problem with joins in SQL.
  364. where do I download sql odbc drivers from?
  365. Re: Connection pooling issue with pass through queries
  366. Join zero padded char to varchar
  367. Re: Connection pooling issue with pass through queries
  368. Re: Strange select
  369. Re: Strange select
  370. Re: Need Help With an Update Script
  371. strange Problem
  372. your thoughts on this please
  373. SQL Server 2000 UDF Intermittent Slow Execution
  374. Sysmergesubscriptions question
  375. examples with SS2008 -xEvents?
  376. Need Help With an Update Script
  377. delete a named instance - how?
  378. SQL Server Browser service?
  379. select from two tables
  380. Strange connection problem
  381. Help with an Update Statment
  382. Install new instance...
  383. Simple Query Question
  384. Where's my instance???
  385. DBMS advantage and disadvantage
  386. Rename Default Instance Name SQL Server 2005
  387. Cannot Read Varchar(max)
  388. relocating Outlook Business Contact manager
  389. confusion over indexs via primary key and clustered index
  390. Link to external file
  391. SQL Excel - freeware add-in for excel
  392. Modeling/Constraint question
  393. Email Generation from within SQL/Server 2005
  394. Re: SELECT Optimalization
  395. Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
  396. Help with SQL Backup Problem
  397. DTS Transfer Data Task - output to text file with field names infirst line
  398. I want to update the column in a table based on the updation of theother column in the same table
  399. syscharsets unicode
  400. nested stored procedures and returning lots of rows
  401. Checking for duplicates in a database table
  402. firewall rules for SQL Server
  403. Modifying registry information to change type of login logging
  404. Suggested DB Reverse Engineering tool...
  405. Local Security Policy - Restricting Access
  406. Cursor and Procedure
  407. select from row1 to row n
  408. Reattaching database - identity_insert set to off
  409. Most Helpful Professional Award
  410. Cross Database Select
  411. Merge process could not update the list of subscriptions
  412. a and (b or c) better than (a and b) or (a and c) ?
  413. caching table Problem
  414. How to return a Pk value from one stored procedure to another storedprocedure
  415. create dynamic variable in procedure
  416. Advanced SQL Cubing
  417. SQL 2005 on Windows Server 2008 - Slow Connection Time
  418. Re: Display duplicate rows
  419. Help!
  420. Re: comp.databases.ms-sqlserver
  421. Altova v2008r2
  422. Urgent: Deciphering binary code executed against the database
  423. copying row from same table and adding value from form.request
  424. Doing a SELECT INTO using a Stored Proc as the data source
  425. SQL Statement Problem : Separate long varchar into word seqments 35chars long
  426. Setting SQL Server Agent Account without being part of a domain
  427. Limiting table access using stored procedure.
  428. SQL Select All Items where one meets the criteria
  429. optimal selection of all records for a certain month (illegal datesOK?)
  430. updating multiple columns with subselect
  431. Selecting several types
  432. Prevent Excel and Access access to SQL 2000
  433. Read HTML File though Network for Email.
  434. Disable and Rebuild or Drop and recreate Index
  435. Force protocol encryption on hosted database
  436. How to implement Audit/Alert for Row level access?
  437. Orphaned tupels, should I clean or is it ok to leave?
  438. Full text indexing scheduler SQL Options
  439. SQL and Database Design newsgroup
  440. ASP.NET 2.0 not connecting to SQL Server (not web.config)
  441. Help with bbrowser cell focus ?
  442. Client applications
  443. Re: SELECT * vs SELECT col1, col2
  444. COLUMNS_UPDATED() with triggers
  445. Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
  446. beginners question...
  447. Conditional data copy SQL Server to Oracle
  448. Can you tell who last edited a SProc, and when?
  449. Select CASE returning NULL value
  450. Why freetext query become very slow all of a sudden
  451. Select date in british format
  452. back up jobs, re-index question
  453. MSSQL - MySQL
  454. file crawler
  455. How to recover deleted records?
  456. capture and save running sql query to database table (for logging)
  457. Use of having with additional select
  458. design question - type heirarchy with supertype queries
  459. Performance question concerning varchar(max)
  460. Yet another basic SQL question
  461. using LEN to find a first word greater than 17
  462. Job ends successfully even when it's not true
  463. exporting a table with long field names to Access
  464. Basic SQL Question
  465. FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
  466. Another new DBMS
  467. copying data from one server to another
  468. How to find records with length greater than 17
  469. CHECKSUM to determine record changes
  470. first minimum date in the column for each distinct column a value
  471. Re: Get rows whose sum matches a value
  472. The Sql ranking OVERture
  473. sp_prepexec syscomments?
  474. select parent records that do not have a particular child
  475. how to create my own primary key which auto-increment
  476. Re: Get rows whose sum matches a value
  477. Re: tempdb size question
  478. Re: HELP WITH SELECT STATEMENT PLEASE
  479. SQL Server 2005: functions become slow after a while
  480. How to get the sql statement of a view? (by running a query or from ado.net)
  481. Granting permissions for a user from another database
  482. Login Seems OK but doesn't behave correctly
  483. table trigger just hangs
  484. SQL Server Management Studio
  485. Dump table as INSERTs
  486. Query Japanese Text in an NVarChar?
  487. SQL 2005 XML Searching
  488. import ADO DLL
  489. Performing Bulk Load of XML Data
  490. case-when error
  491. Secure Auditor, 30 security tools at the price of one.
  492. Secure Auditor, 30 security tools at the price of one.
  493. Finding "missing" rows
  494. Login failed for user 'sa'. Reason: Server is in single user mode.
  495. Re: T-SQL Duplicate Record Help
  496. Connection String on shared server- Almost there but need a littlehelp
  497. Please recommend SQL book with excercises
  498. Re: default value wich is not in DDL.
  499. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  500. where do I download sql odbc drivers from?
  501. (Newbie) Join problem.
  502. Problem with joins in SQL.
  503. Join zero padded char to varchar
  504. Constipated publisher (SQL 2005)
  505. PHP/MS SQL - automatic formatting: varchar, datetime
  506. xSQL Profiler - monitor multiple SQL Servers from one centrallocation
  507. How do I make a backup device file smaller ?
  508. SQL 2005: Renamed 'sa' account
  509. Client side insert update
  510. help,a regular text file how to sql 2000 table code ?
  511. Problem Connecting .NET app to SQL Server
  512. An optimum query..?
  513. boot camp
  514. getting tables that link to a table
  515. [IAT ELEZIONI] Presentazione candidati
  516. Simple Concatenation Question
  517. List Columns in a Table in SQL 2005
  518. SQL Assistance required
  519. Error History?
  520. Deleting multiple columns from multiple objects
  521. from 'image' to 'varbinary(max)'
  522. What does it mean to SET a value?
  523. Complex Calculation
  524. difference between explicit inner join and implicit
  525. delete output into <xml column of audit table>
  526. testing if value is null
  527. Internal query processor error
  528. Violation of primary key
  529. CASE WHEN Equivalent in WHERE Clause?
  530. Uninstall SQL 2000 Workstation Components
  531. Scalar Subquery in MS-SQL Server 2000
  532. Scalar Query in SQL Server 2000 like in oracle
  533. SQL 2005 Express - problem with no "SQL Serevr Agent"
  534. SSIS security
  535. converting SQLTable to Excel Sheet
  536. dbrpcparam datalen problem
  537. ADO vs ADO.net
  538. SQLServer - VC++
  539. DLL -> Database
  540. SQL Server
  541. help with DDL trigger. Moved from other newsgroup.
  542. UTF-8 Coding of MSSQL 2005 DB
  543. how to calculate rank in selected records in sql server 2000
  544. SQL Server - synchronizing database changes across servers
  545. Rounding not working
  546. Getting record position in sql server 2000
  547. Deleting Tables
  548. call script from another script
  549. nub question :(
  550. Triggers and Flag bit