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. Multiple Apps on System DSN on Server from One PC
  2. Regarding table Order
  3. SQL Best Practices Analyzer Rule: Use of Schema Qualified Tables/Views
  4. Can't connect to Oracle Dbase with SQL Server 2005 Express
  5. SQL Server Express Edition vs MSDE
  6. Converting INT datatype to BIGINT datatype
  7. Grouping Dates
  8. Stored Procedure to change default
  9. links for fields
  10. Temp tables vs table variables
  11. Access to SQL Server
  12. Indexing a View
  13. Log shipping and DTS pakages
  14. Fuego, Tomcat, JDBC & SQL Server 2000
  15. Problem in Accessing SQL Server Views from Oracle Using TG4MSQL(Transparent gateway Connectivity)
  16. trigger simple question
  17. un-registering a server
  18. Question: Recording login access to SQL Database
  19. Error when setting up ODBC Connection
  20. Performance monitors
  21. Help with phoneBook db design
  22. Text datatype as local variables in Trigger
  23. Migrating to SQL 2003
  24. Adding Time Totals in SQL
  25. Why I can't drop a table
  26. query plan in clear text
  27. How to copy data from backup or data files to new SQL installation?
  28. dynamically trasnpose rows into columns
  29. Sync to databases nightly with BLOB data
  30. Strange FK relationship - how, and is it right?
  31. maintenace plan question please
  32. Deadlocks and Parallel Query Processing
  33. SQL Debugging Tool
  34. Export Data from SQL Enterprise to SQL Express 2005
  35. *=
  36. 1 question about psql table
  37. Please help the performance issue.
  38. When Linking A Server; Only System Tables Are Accessible!
  39. Database security (crosspost)
  40. Database security
  41. datetime
  42. Help with blocking on querying two joined tables
  43. XOR and foreign key constraints
  44. Toad & S2K5
  45. Transactional Replication
  46. SQL relationships and identities
  47. listing SQL Server databases on a network
  48. Disabling Constraint for Bulk Loading
  49. How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
  50. Regarding Index Rebuilding
  51. Help with SQL Query !
  52. Role/Person Table?
  53. Should I worry
  54. Concatenation Limits in SQL Server 2000?
  55. Reporting Services
  56. fix for long running transaction problem
  57. Help with select query
  58. Lock table problem
  59. Need Material for "Sybase to Sql Server Migration"
  60. Replication of several satellites into one central db: adding location key ?
  61. Query Optimization: CPU speed or Logical Reads better?
  62. Query Optimization: CPU speed or Logical Reads better?
  63. Using muliple smaller SPs and Functions better than using 1 big SP?
  64. Nested Nodes in XML from a table
  65. Compile/combine the contents of several records.
  66. Is this an efficient way to create a comma string
  67. Excel file import problem
  68. MSE
  69. Get previous record
  70. help with grouping query...
  71. User Loggon Password Changed
  72. 1 SP with dynamic input parameters and multiple rows as the source of the query
  73. Nested Triggers
  74. Getting data from multiple rows into one column
  75. SP and ADO Page Property Not Working Properly
  76. SLEEPING/AWAITING COMMAND question
  77. error handling and bulk insert
  78. Inserting dummy lines and padding
  79. Planning multiple queries
  80. Mini Index?
  81. Select *
  82. cannont create SSPI context (SQL connection problem after 30 minutes)
  83. Databases not showing up in Enterprise Manager
  84. upgrading to SQL 2005
  85. Help needed by deadlock problem
  86. Can REPLICATION on SQL Server 2000 allow dirty reads
  87. 2000 Replication with DB in 65 Compatibility Mode
  88. Application & Database Security Consultant
  89. Can I install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 in one PC win2000 sp4?
  90. Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
  91. Extracting and joining header from denormalized table
  92. HELP: Strange Blocking Performance Problem with Simultaneous Queries
  93. Indexing and Queries
  94. problem creating DTS package
  95. splitting a string
  96. Help needed with query syntax
  97. Clustered versus Create table on high speed FILEGROUP
  98. big log file
  99. String case problem
  100. accessing mssql in linux through c++ code
  101. Index Design Recommendation - Examine Column Uniqueness
  102. Index Design Recommendation - Examine Column Uniqueness
  103. PAGEIOLATCH is a lead blocker
  104. Query question
  105. Monitoring replication
  106. Wildcards On Columns?
  107. Show owner of database
  108. Temp Table and SP Advise
  109. Subtracting two columns from diff tables
  110. LOAD .SQL file
  111. Regarding BCP utility
  112. STORED PROCEDURE - passing table name as a parameter
  113. Passing DateDiff rather than Actual Dates as Parameters
  114. log shipping
  115. Problem with spid by sp_who
  116. Format() Function in MS SQL
  117. Select into / Linked Server / Missing IDENTITY attribute
  118. SQL errors, trapping in Server Agent
  119. multi-field primary key
  120. Bulk Import with header in text file
  121. Data grouped by 20 minutes?
  122. About: An INSERT EXEC statement cannot be nested.
  123. CASE problem
  124. An INSERT EXEC statement cannot be nested error.
  125. Strange Performance question
  126. Can't send operator email in SQL Sever 2005
  127. sql 2000 64-bit
  128. Return pkID of last saved record - ASPUpload & @@Identity
  129. connection TCP/IP through the port 1433
  130. Microsoft SQL 2000 Documenter
  131. Using the copy database wizard
  132. Timeout Period in SQL Server 2005
  133. SQL View Performance
  134. Bulk delete on operational data
  135. Performance when using php and mysql
  136. Query Retrieval is slow
  137. Oracle licensing for dual core processors
  138. SQL backup - dun understand
  139. Prepared SQL Plan vs. Procedure Plan
  140. difficult summing query
  141. SQL Query Help
  142. SQL server - script execution time
  143. Subquery headache with Count and GroupBy
  144. query problem
  145. 100 % CPU Usage
  146. How to move two separate databases into one?
  147. Combining INTO with UNION
  148. Enterprise Manager - problem
  149. Tuning API CURSORS
  150. How to drop one of the tempdb files
  151. SQL Equivalent of MAX and IIF
  152. Need help with Count function and temporary tables
  153. Limit saving DTS package to SQL Server
  154. batch replication
  155. problem with Select query
  156. About bcp_init
  157. Scheduled Job Hangs the server
  158. Active directory and SQL 2K
  159. Scheduled job hangs the server
  160. Compressed folder & Query speed
  161. UBOUND
  162. Recordset
  163. Requirement : IBM Process Choreographer
  164. Hiding secret columns from users
  165. Splitting a filename out of a filepath
  166. verify if database exists
  167. SP 4 error
  168. BULK INSERT and APPLICATION ROLE
  169. About dtsrun
  170. Database Problem related Clusterd data
  171. need a DBA Suggestion.
  172. Make a Bunch of Rows from a Table Resemble a Column
  173. Simple SQL Query (To Neglect time from DateTime DataType)
  174. Alex
  175. Log Invalidated after truncate table
  176. stored procedure with array of parameters
  177. HIT and MISS
  178. SQL Server Msg 1105, Level 17, State 2, Line 1
  179. Query returning 1.7million records slow
  180. Best use of inner join
  181. Is this normal
  182. What looks like a basic SQL query still not resolved
  183. Inner join weirdness in DTS
  184. exam ms 70-228
  185. need help
  186. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  187. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  188. Optimizing Stored Procedure with Datetime parameter
  189. SQL statement to compute employee pay for a year at different pay rates
  190. adding identity column dynamically
  191. need information on SQL SERVER 2000 with multi-threading CPU
  192. sql query update
  193. There is a question when i work on Linkedserver~Pls kindly help me:)
  194. full text catalog on remote (shared) server
  195. Merge Replication - Adding a new table
  196. QUESTION: Connecting with SQL Admin across domains
  197. Indexes being improperly used when selecting data through a view
  198. SQL-Server DBA-Full Time, Permanent, National Institutes of Health
  199. Optimal search for the nearest date
  200. get the DB index SQL
  201. NEWID()
  202. SQL 2005 Unhandled Exception Error
  203. SQL 2005 Developers Diagram question
  204. flexible back-end data handling in .net + sql project
  205. Query Question
  206. Options to upgrade an SQL 6.5 DB to 2000
  207. DTS package design - Not allaowed link
  208. Is DTS source file's name parameterizable?
  209. Tracking Package Execution Status
  210. Install or not to install Launch Give away version?
  211. Room availability
  212. Concatenating strings from different rows
  213. who knows reporting service
  214. SQL Join with unknown tables - but it works!?!
  215. Star Join
  216. why the MS DTC always stop services automatically ?
  217. SQL server connection problem
  218. working with large numbers
  219. regarding BLOB
  220. How to delete data older than X days, without considering time
  221. Something Basic
  222. Something Basic
  223. Store data horizontally or vertically?
  224. Need security advice on xp_cmdshell, bcp, xml procedure
  225. Linking a table
  226. Simpleton question please
  227. migrating form standard to enterprise edition
  228. how to have the DB diagram
  229. Parse Return value of SYSTEM_USER
  230. DBGEN TPCH Compiling
  231. How to do a JOIN statement for a table with 2, one-to-many relationships.
  232. Bulk Delete
  233. Help with SQL query
  234. Terminal Service cause TimeOut Expired
  235. QUESTION: No Support for SQL 2K on W2K3??
  236. Database optymalization(??)
  237. Filegroup restore problems
  238. Where are the maintenance plans stored in SQL Server 2005?
  239. stored procedure update HUGE PROBLEM
  240. grouping select query
  241. Tables in Parent-Child order
  242. DTS question: 2 source tables, 1 target, 3 connections
  243. Question about Views and sp_refreshviews
  244. Interesting SQL query requirement for <SELECT> menu
  245. Insert
  246. update spends 1800 times more than select
  247. Sql Server 2000 causing TCP/IP to crash?
  248. optional parameter in sql query
  249. commit and rollback problem
  250. tree structure select problem
  251. OpenDataSource trouble with Advantage SQL
  252. newby - AUTOINCREMENT problem.
  253. is WITH ENCRYPTION now safe in SQL2005?
  254. Return Stored Procudure Values
  255. MDF File Still Exists After DROP TABLE
  256. stored procedure
  257. DELETING 100 million from a table weekly SQl SERVER 2000
  258. row level security across multiple columns
  259. BlackBerry Enterprise Server - SQL problem
  260. an unexpected error occured during this operation
  261. mirrored sql servers
  262. How can I tell if a sql server is MSDN or Standard or Enterprise version
  263. sysprocesses memusage sleeping
  264. access MS SQL/ACCESS from linux?
  265. TCP/UDP ports used for Index server OpenQuery
  266. aggregate question
  267. Looking for an opinion
  268. help
  269. Using Query Analyzer with Windows Auth across domains
  270. Whats wrong with my join statement?
  271. Approximate String Searches
  272. Pros / Cons to this approach
  273. learning Microsoft Query Analyzer
  274. Automatic SQL Queries to dump data to folder
  275. Updating a Chunk of data without crashing transaction log
  276. Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server
  277. Default charset in sqlserver 2000? / jtds
  278. History of logins or Userids
  279. TPC -H creation script
  280. Torn Page
  281. Is there any REGEXP library for TSQL?
  282. Database design question...
  283. host_name
  284. SQL query question
  285. Unique Constraint on Multiple columns
  286. Stored Procs and db_owner
  287. Information Schema Query Question
  288. Passing authentication from PHP to reporting services
  289. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
  290. Mira Laura, toma la direccion web,,, dime algo. MS58
  291. Rendering directory structures
  292. question about log file size when alter Huge table
  293. Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
  294. Problem with HOST_NAME Function with Linked View
  295. Creating Tables on the Fly
  296. have sql file and want to run it on an ftp connection
  297. unique constraint to a column from another table
  298. DTS Table Import Issue
  299. error message 18542 level 16 state 1
  300. Count(*) Locking up things ...
  301. Distinct Filter in SQL Reporting Services
  302. Multiserver Administration
  303. MSDE and two instances on the same server?
  304. Attaching MDF without LDF
  305. Statement for returning stored procedure params
  306. SQL Server 2000 and 8k limit
  307. advice needed on new server product
  308. Find the Data Bases which can not be Backed up are some resons
  309. Find the Data Bases which can not be Backed up are some resons
  310. String manipulation challenge in SQL
  311. Table Synchronization across databases on the same server
  312. How to take data out of table, restructure the table and then put the data back in
  313. DTSRun causes The Memory could not be "read" application error
  314. Server Listing for TCP connection
  315. Identical database w/ identical stored procedures?
  316. Record , Row number
  317. Record , Row number
  318. Deriving unique rows from historical data
  319. too many connections
  320. User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
  321. Tool for clients
  322. Stripping Punctuation
  323. Create Procedure Output ntext
  324. need to replace replication server with main server
  325. DAO > SQL Server Processes
  326. How to select data
  327. Quarterly trending
  328. Quarterly trending
  329. excluding fields in SELECT statement
  330. mssql ide (front ide)
  331. SQL Server 2000 Error 17805 Invalid buffer received from client
  332. Many data entry tables - which ones hold records?
  333. CAST Command
  334. EnterpriseManager-->Process Info Screen
  335. How to create table names by using macro variable? Thanks!
  336. Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
  337. historical data
  338. How do I concatenate text to a sql statement
  339. Table Documentor
  340. DTS vs triggers
  341. Synchronising access and sql server
  342. I wish upon a new server ....
  343. Problem with simple cursor
  344. Foreign and primary keys
  345. Adding an auto-increment column to existing table with a particular order
  346. Derived tables from multiple resultsets
  347. MOM blocking analysis
  348. sum of sums
  349. Identifying results sets when stored procedure called multiple times
  350. simple userdefined function question.
  351. Unable to update view in Sql Server 2000
  352. A way to recursively look up hierarchal data using a lookup table
  353. How is inheritence like data best done in SQL
  354. .dat
  355. Certification is not so easy job.
  356. Query help
  357. Moving Data for Audit - Best Practice
  358. Sequence of columns in primary key
  359. How to display just user defined objects?
  360. Creating Primary key with ODBC
  361. Form Slow, Then Fast
  362. SQL UPDATE - PLEASE HELP
  363. Database Access over Internet
  364. How to Interpret Merge Agent History and Session Detail
  365. determine tables that are Simple recovery
  366. Organization tree
  367. MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
  368. Wrong default constraint shown from Object Browser in Query Analyser
  369. Tracking user activities
  370. Column By Column Comparison
  371. Relational Database Usage survey
  372. Unique Selections In Back End
  373. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  374. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  375. Type Mismatch Error On Bulk Insert
  376. Overflow error
  377. Defragment Heap Tables
  378. Bulk insert
  379. Bulk Insert Command
  380. Update One Based on ANother Table
  381. Help with Query
  382. Is logging the execution time of Stored Procedures with standard settings possible?
  383. registering SQL Server not in domain
  384. Problem with SUM
  385. Join statement
  386. Changing the 6th character of a string?
  387. Bulk Insert Data in Millions - Lock Issue
  388. AutoNumber vs. Key
  389. Any way to optimise this query?
  390. embedded control characters
  391. Errors with SP4 upgrade... Please Help
  392. One-One Relationship
  393. ...Contains more than the maximum number of prefixes. The maximum is 3.
  394. Template function
  395. Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
  396. LIKE and IN can I combine
  397. database in simple mode yet txn log file can be out of diskspace ?
  398. selecting only the last record in joined table
  399. Sooper Newb Ques: Starting with SQL Server 2000 DE
  400. Schema Diff Tool
  401. Dates in a date range
  402. Temp Table on Linked Server
  403. PK and Timestamp in same table?
  404. Backup for one new DB failing in regular maintenance job Error 3201
  405. SQL Import of LArge Amount of Data
  406. question about like
  407. OpenRowSet with Excel DENIED
  408. SQL Convert function!!
  409. changing indexes
  410. SQL for field names from a table
  411. Change Data Type
  412. seeing FMTONLY/NO_BROWSETABLE ON stuff in the profiler
  413. Import cell data from XLS into SQL table
  414. Please suggest backup software
  415. delete of mirrored rows
  416. Joins: strategy and how-to approach
  417. Unique ID added to a result set
  418. how to determine programatically what output of a sp will be?
  419. Display Money Type using + and -
  420. image data type
  421. Transaction Management
  422. resultset of proc in another proc
  423. new sql version control solution!
  424. Search Advice
  425. PostgreSQL Linked Server question
  426. OPENXML vs BCP
  427. my new function not found
  428. Error installing SQL Server2000: A previous program installation created pending file operations on the installation machine
  429. word xp
  430. Calling a Data Pump task from DTS?
  431. copying server objects
  432. Can't "SELECT" using CREATED_DATE column...help
  433. Multiple level nested Corelated query
  434. Problem with case expression
  435. jacek@karczmarczyk.pl
  436. Error handling when calling external sql-Files
  437. Trouble with SPROC
  438. Unit Testing
  439. Autogrow question
  440. Need help formulating a query
  441. ASP.NET + SQL 2005
  442. Query Help, thanks!
  443. How to save DTS package as an application
  444. How to convert from CHAR to Numeric in the table
  445. Horizotal to Vertical Display
  446. How to check Backup of SQL Server Database
  447. Controlling fields in a select statement by use of parameters
  448. NAMED SET / PIVOT TABLE !! HELP ME
  449. Howto set Access Recordsource onto a "select" sproc
  450. HELP MDX , NAMED SET AND PIVOT TABLES !!
  451. SQL Server 2000 Backup + Restore question
  452. SQL Mail setup
  453. SA can not create users
  454. Multiple entries script...help
  455. Database Replication
  456. Transaction log ???
  457. Problem causing me to have to restore tlogs WITH MOVE
  458. Restoring a missing db
  459. Job invoked by Alert but Alert never occured
  460. Fast Date Ranges Without Loops In SQL Server 2000
  461. Howto setup my user in order to grant him the drop privilege
  462. Performance and second table
  463. How to remove MSDE manually?
  464. Can I speed up this script...help?
  465. Stopping Query Execution from PHP
  466. Simple question
  467. Does DBCC DBREINDEX update stats?
  468. Consolidating Records
  469. Finding the most recient datetime
  470. ordering an int column
  471. SQL Server Hanging
  472. date format
  473. Access Control List (structure) invalid - updating Virtual directory information
  474. parsing varchar fields
  475. iSQL - Blank line at the end of the iSql output file
  476. Error : Difference of two datetime columns caused overflow at runtime.
  477. Error : Difference of two datetime columns caused overflow at runtime.
  478. The SMTP Server in xp_smtp_sendmail
  479. Blocking and Transactions OK?
  480. bit off topic: street name database US
  481. Report Services
  482. SQLColumns crash (Access violation)
  483. updating multiple fields
  484. Howto Format a string in a sproc ?
  485. Connecting Trace info to blocked users?
  486. PASS User Group Austria looking for MS-SQL professionals to take part
  487. Is there a way to find growth in log (ldf) and database(mdf) ?
  488. Any way to find out which SP is updating data in a specific table?
  489. min(date) + 1
  490. searching a list of tables, derived from another table
  491. XP and Replication
  492. Help finding the top 3 zipcodes within the top 5 counties
  493. Syntax to add records if primary key = list
  494. Renaming a Server
  495. Is there any way in a sproc to LOOP thru the records of a table ?
  496. inline if
  497. search on concatenated fields in sql server
  498. Original Data and Log size
  499. Rejoining replicating servers
  500. MDF / LDF
  501. Data Load Query
  502. Linked server
  503. Dynamic data elements for a data collection application
  504. Security Admin on a server with NO public permissions
  505. delete records
  506. bcp header
  507. Delete relationship?
  508. Insert based on a select query
  509. DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
  510. Single quote in NVARCHAR string?
  511. How to update 1000s of items in 50 tables
  512. Identity...I need to get the last (or highest number in Identity column)...
  513. Stumped by SQL challenge
  514. SQL Server paged recordset problem
  515. SQL 2000 installation on WinXP Pro problems
  516. Can't connect
  517. Scheduling Database - Design Help!
  518. Scheduling Database - Design Help!
  519. Reg Exp for digits
  520. Converting Binary Image to Readable Text
  521. IDENT_CURRENT and empty table
  522. NOLOCK and READPAST on same table?
  523. Determine fastest query in Query Analyzer
  524. Using IS NOT NULL on column result from subquery
  525. Query Syntax help
  526. Aliased column in stored procedure not seen by datagrid
  527. SQL Mail - MAPI profiles on Windows Server 2003
  528. Best way to tell if a SP is a query Programatically
  529. Tools for design recovery (reengineering) of C# source code with embedded sql statements ?
  530. Extremely Slow Table
  531. how to do text replacements
  532. SQL Server bouncing connections
  533. Dont backup if Database hasnt changed
  534. The "right" way to distribute a database to end-user
  535. Why dosn't IIF work here?
  536. saving output from multiple queries
  537. Can someone help me with multiple "Left Outer Joins"?
  538. Can someone help me with multiple "Left Outer Joins"?
  539. Need Help with "Left Outer Join"...
  540. Removing white spaces in a varchar column
  541. Help on a SQL query
  542. oracle pl/sql -> sql server
  543. Index corruption on table without key: what could be the reasons ?
  544. SCOPE_INDENTITY() Not Returning
  545. Script to search for a string in all varchar columns in all tables in a database?
  546. VB 6 & SQL Database: How can I create reports with charts ?
  547. Saving query plan
  548. Output stored procedures as text problem
  549. XML generation issues
  550. How to count